Guide
“This data set is too large for the Excel grid”: what it means and how to fix it
Excel warns that the data set is too large for the grid and that you'll lose data if you save. What happened to your rows, and four ways to get all of them back.
Updated 18 October 2026 3 min read
You double-click a big CSV export and Excel stops with a warning: “This data set is too large for the Excel grid. If you save this workbook, you'll lose data that wasn't loaded.” The file opens, it looks complete — but it isn't.
What the message means
An Excel worksheet holds at most 1,048,576 rows and 16,384 columns. When a file has more, Excel loads what fits and silently leaves the rest out. Scroll to the very bottom (Ctrl + ↓): if the last filled row is 1,048,576, you are looking at a cut-off copy.
The same limit explains a cousin of this message, “File not loaded completely”, and why a file can look “too broad” when it has more columns than Excel accepts.
First: don't save over the original
The warning is serious. If you press Save and keep the CSV format, Excel rewrites the file with only the rows it loaded. Close without saving, or use Save As with a new name, and keep the original export somewhere safe.
Fix 1: split the file into Excel-sized parts
The quickest fix for most people. Cut the CSV into files of, say, 1,000,000 rows each, with the header repeated at the top of every part. Each part then opens normally, with nothing lost.
Fix 2: one workbook, several sheets
If you need everything in a single file to send to someone, convert the CSV to an Excel workbook that continues on a new sheet each time the row limit is reached: rows 1 to 1,048,575 on the first sheet, the rest on the next.
Fix 3: Power Query and the Data Model (analysis only)
To summarise millions of rows rather than scroll through them, load the file without putting it on a sheet:
- Data → From Text/CSV, pick the file.
- Click the arrow next to Load, choose Load To…
- Select Only Create Connection and tick Add this data to the Data Model.
- Build a PivotTable from the Data Model. It can count, sum and filter far more rows than the grid can display.
You still can't see or edit individual rows past the limit this way — it is for totals and pivots.
Fix 4: open it without Excel
Databases, Python (pandas) or a dedicated large-file viewer have no 1-million-row ceiling. They are the right tool when you need to search or sort the whole file at once.
Coming soon: a huge-CSV viewer that runs in your browser
Open, search and sort millions of rows — with nothing uploaded.
More background on why big files get cut off: your CSV is too large for Excel — 4 ways to open it.
Frequently asked questions
Did Excel delete my data?
No. Excel only loaded the first 1,048,576 rows into the sheet. Your original CSV file is untouched — as long as you don't save over it from Excel.
Can I change a setting to raise the limit?
No. 1,048,576 rows by 16,384 columns is a fixed limit of every Excel worksheet since Excel 2007, Microsoft 365 included.
Why does the warning say I'll lose data if I save?
Saving writes only what Excel loaded. If you save the workbook over the original CSV, every row beyond the limit is gone from that file for good.