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:
- Highlight the column
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 🇬🇧