Google sheets data not loading

Sometimes pre-existing formatting in Google Sheets might cause issues when you want to load your Trevor query data. If you find you get an error message or the sheet seems to get stuck on 'Loading...' try the following:

  1. Refresh the sheet
  2. Delete and re-add the query data import
  3. If possible, remove existing formatting on the Google Sheet and re-add the import

If the above doesn't work and you need to maintain the Google Sheet formatting, try the following workaround:

  1. Add a new sheet
  2. Copy and paste the import to your new sheet
  3. Click the cell where you want to enter the query data
  4. Type =
  5. Go to the sheet where you imported your query data
  6. Click on the A1 cell (or where your query data starts)
  7. Return to the sheet where you want to enter the query data
  8. Hit enter
  9. The data from cell A1 in the other sheet will now be in the formatted sheet. You can drag to fill in the rest of the imported data

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.