image.png

Why this error?

Import to Google Sheets failed because this action would exceed the max limit of 10 million cells per spreadsheet.

This is a Google API limitations for spreadsheets:

Up to 10 million cells or 18,278 columns (column ZZZ) for spreadsheets that are created in or converted to Google Sheets.

source: Files you can store in Google Drive - google.com

How to fix it?

Here are some ways to avoid this error:

Pay attention: it's 10.000.000 cells per spreadsheet, not per sheet!

A Google spreadsheet is made of multiple sheets.

The limitation applies to the spreadsheet, in other words to the sum of the cells of its sheets.

image.png