I'm seeing a 'This worksheet is too large to import' error

The file size limit for uploaded spreadsheets is 5MB. If you're seeing the error message “WARNING: This worksheet is too large to import”, first check to see if the actual size of your .xlsx file exceeds the 5MB limit.

Checking the actual file size isn’t straightforward though as.xlsx files use ZIP compression within them, and since plain text can be compressed considerably, a document of only 2–3MB could have an actual size when uncompressed of several hundred MB.

A good rule of thumb is that the actual size is 10 times the uncompressed file size i.e. a 2MB file would be near 20MB uncompressed. In other words, the actual file size of your.xlsx document should be about 10 times the size reported on your device.

The rule of thumb should be enough for troubleshooting, but if you’re curious a more precise method for checking the actual size is explained on this GIF:Check the size of your worksheet in Mac OS

If your file is too large to import to Geckoboard, not everything is lost. We recommend creating a new.xlsxdocument and reference only the particular cells, columns or rows that you need for your metrics using ImportRange, then use the newly created file (that contains only the data you needed) to power your Geckoboard widget(s).

Use Google Sheets’ ImportRange function to display data in Geckoboard

Was this article helpful?

Awesome! 👍 Thanks so much for your feedback!

Sorry about that! Start a conversation now.

Ready to create your own dashboard?

Get started for free

Still have questions? Get in touch.