Guide
CSV too big for Excel? Here is what is happening
TL;DR
Excel stops at 1,048,576 rows and 16,384 columns. It usually becomes unusable well before that, because it holds the whole workbook in memory and recalculates across the entire used range. Open the file in a browser viewer to look at it, split it if you must, or move it somewhere built for the size.
Excel’s real limit
A worksheet is capped at 1,048,576 rows by 16,384 columns. That number is not a licensing choice — it is 220, baked into the file format. When you open a larger CSV, Excel does not fail cleanly; it loads the first 1,048,576 rows and quietly discards the rest, which is considerably worse than an error because nothing tells you the analysis you just ran was on partial data.
Why it slows down long before the ceiling
Most people never reach a million rows before Excel becomes unpleasant. Three things compound:
- The entire workbook is held in memory, along with formatting and per-cell metadata, so memory use runs far above the file’s size on disk.
- Recalculation sweeps the whole used range. One formula column over 800,000 rows means 800,000 evaluations on every edit.
- Rendering, sorting, and filtering all operate on the full sheet rather than on what is visible.
That is why a 300 MB CSV can turn a fast laptop into a beachball while a browser viewer scrolls the same file smoothly — the viewer is simply doing much less work.
Three ways to open it anyway
1. Look at it in a browser viewer
If you need to inspect the file, check a few values, or pull out a filtered subset, a local viewer is the shortest path. Nothing to install, and on this site nothing to upload. Open a file here.
2. Split it
Splitting a large CSV into sub-million-row chunks lets Excel open each piece. It works, but you now have several files that must be kept in sync, and any analysis spanning the whole dataset has to be stitched back together by hand. Treat this as a workaround, not a workflow.
3. Move it somewhere built for the size
If the file is this large routinely, the tool is the problem rather than the file. A spreadsheet designed for large data opens tens of millions of rows and keeps formulas, pivots, and charts working at that scale.
The uncomfortable question
A CSV too big for Excel is often a sign the flat export should not have happened at all. Someone ran a query against a warehouse, dumped the result to a file, and mailed it onward — and every downstream consumer now deals with a stale, oversized snapshot. Connecting to the source directly removes the file, the staleness, and the size problem in one move.
Connect to the source in Row Zero
For the exact numbers across every tool, see CSV and spreadsheet row limits, compared.
Got a file to open right now?
Open a CSV file