“This data set is too large for the Excel grid” — open files over 1,048,576 rows
What to do when a CSV has more rows than Excel can show, without losing data.
The message you see
This data set is too large for the Excel gridFastest fix
Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.
Why this happens
- Excel worksheets are limited to 1,048,576 rows and 16,384 columns.
How to fix it
- 1Do not save the file from Excel — rows that weren't loaded will be lost.
- 2Split the CSV into parts below the limit and open those.
Related guides
Excel
“Excel cannot open the file because the file format or file extension is not valid”
ExcelExcel error “SYLK: File format is not valid” when opening a CSV
Excel“We found a problem with some content” — Excel workbook won't open properly
Still stuck? Ask SheetFix Support