Common Issues in Google Sheets

Resource at url contents exceeded maximum size

Google sheets has a cell limit of around 190k cells, and a file limit of around 1MB. It's not always consistent, and sometimes you can export more, other times, less 🤷‍♀️

We have a workaround that can help - go to the Google Sheets exports page and scroll down to the section 'Exceeded Google's import limit?' to get the links for this. 

 

Google has changed my dates to strange numbers

Sometimes, Google Sheets doesn't recognise the date format exported from Trevor.io. 

i.e. it appears as a number instead of a date. 

To correct this, simply:

  1. Highlight the column
  2. Click Format > Number > Date.

And you're all set 💪

 

My commas and dots are the wrong way around

In Google Sheets, click File > Spreadsheet Settings and change your local to United Kingdom 🇬🇧

 

 

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.