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

The file size limit for connected spreadsheets is 5MB. If you're seeing the error message WARNING: This worksheet is too large to import, it's highly likely your file exceeds this limit.

I'm connecting an Excel file

We recommend importing .xlsx file to Google Sheets. You can then use ImportRange to reference the data from the converted file.

An alternative option is to export the .xlsx spreadsheet to a .csv file and use ImportData to import that data into Google Sheets.

I'm connecting a Google Sheet

We recommend using ImportRange to feed the data you need from the original spreadsheet into a second spreadsheet – leaving the original untouched.

My file size is lower than the 5MB limit

.xlsx files use ZIP compression within them. This means a 2–3MB file could roughly be about 10 times the size reported on your device.

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.