Google Sheets: “above the limit of 10,000,000 cells” — import a big CSV anyway
Why Google Sheets refuses large imports and how to split the file into usable parts.
The message you see
This action would increase the number of cells in the workbook above the limit of 10000000 cellsFastest fix
Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.
Why this happens
- A Google Sheets spreadsheet holds at most 10 million cells across all tabs.
- Empty columns and rows count too.
How to fix it
- 1Remove unused columns and blank rows first.
- 2Split the file by rows and import each part into its own spreadsheet.
Related guides
Google Sheets
Phone numbers turn into dates or lose their leading zero in Sheets/Excel
HubSpotHubSpot import error: “Make sure each column with data has a header”
ShopifyShopify CSV import: “Illegal quoting on line …”
Still stuck? Ask SheetFix Support