“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 grid
Fastest fix

Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.

Split my CSV →

Why this happens

How to fix it

  1. 1Do not save the file from Excel — rows that weren't loaded will be lost.
  2. 2Split the CSV into parts below the limit and open those.

Related guides

Still stuck? Ask SheetFix Support