Guide
CSV and spreadsheet row limits, compared
TL;DR
Excel caps at 1,048,576 rows. Google Sheets caps at 10 million cells, so wide files hit it far sooner than narrow ones. Browser viewers are bounded by tab memory rather than a fixed number. Every one of these becomes unpleasant to use well before it stops working.
“What is the row limit?” is the wrong question surprisingly often, because the number where a tool stops working and the number where it stops being usable are rarely close together. Both are in the table.
| Tool | Hard limit | Practical limit | Notes |
|---|---|---|---|
| Microsoft Excel | 1,048,576 rows × 16,384 columns | Slows badly past ~200k rows with formulas | Hard format limit. Extra rows are silently dropped on import. |
| Google Sheets | 10,000,000 cells | ~250k rows at 40 columns; ~1M rows at 10 columns | The cap is on cells, so width costs you rows. |
| Apple Numbers | 1,000,000 rows × 1,000 columns | Struggles well before the ceiling | Lowest column ceiling of the desktop spreadsheets. |
| openbigcsv.com | Bounded by tab memory | Millions of rows, fewer if the file is very wide | Read-only. No editing, formulas, or charts. |
| Row Zero (Free) | Tens of millions of rows | Stays interactive at that scale | Full spreadsheet, plus live warehouse connections. |
| Row Zero (Enterprise) | 1 billion+ rows | Custom data plane and connector options | Custom pricing — schedule a demo. |
How to read this table
A hard limit is the point where the tool stops working at all. A practical limit is where it stops being pleasant — where sorting takes a coffee break and every edit triggers a recalculation you can watch happen. The gap between the two is usually a factor of five or more, and it is the practical limit that determines whether you can actually do your job.
Cells, not rows, is usually the real constraint
Google Sheets makes this explicit with its 10-million-cell cap, but the same logic governs every tool including this one: memory is consumed per cell. A 4-column log file with 3 million rows and a 40-column export with 300,000 rows are the same 12 million cells, and they cost roughly the same to hold — even though a row-based limit would treat them as wildly different. This is why file width matters as much as length.
When the limit is not the point
If you are running into these ceilings regularly, the fix is usually not a bigger spreadsheet. It is to stop producing the flat file — query the warehouse directly, keep the data live, and let the tool pull only what it needs.
See how Row Zero handles this scale
Limits reflect each product’s publicly documented specifications as of 2026. Vendors change these; verify against current documentation before relying on a number.
Got a file to open right now?
Open a CSV file