CSV too big for Excel: the 1,048,576-row limit and what to do

What you see

Excel says "File not loaded completely", the sheet stops at row 1,048,576, or Excel freezes for minutes on a file of a few hundred megabytes and then opens it with some rows missing. The export looked fine; it is simply larger than a worksheet can hold.

Why Excel cannot open it

A worksheet holds at most 1,048,576 rows and 16,384 columns. A CSV with more rows is cut at that line, silently in older versions and with a warning in newer ones. Well below that limit the size itself bites: a 300 MB text file becomes several gigabytes of cells in memory, so Excel spends minutes parsing and may run out of memory. Google Sheets stops earlier, at 10 million cells per spreadsheet.

Option 1: open it in the browser and cut it down

The large CSV viewer reads the file on your device, draws only the rows on screen, and never uploads it:

• Drop the file on that page. A 120,000-row file opens in under a second; the viewer has no row limit of its own, and a file over 50 MB shows a warning first because the limit is your device's memory, not the tool.
• Search, filter and sort as usual: a filter runs over every row, and a column profile shows blanks, distinct values and a chart.
• Keep only the rows you need: choose "Download options" in the More menu and tick "only the shown rows". The result is a CSV Excel opens without complaint.

Option 2: load it into Excel without a worksheet

Excel can hold more than a million rows in its Data Model, just not in cells. Go to Data, Get Data, From File, From Text/CSV, then instead of Load choose Load To, tick "Only Create Connection" and "Add this data to the Data Model". You can then build a PivotTable over all the rows, filter in Power Query and load only a slice into a sheet.

Option 3: split or summarise the file first

If the goal is a report, aggregate before Excel: a database (SQLite reads CSV directly with .import), a few lines of Python with pandas, or the command line (split -l 1000000 file.csv part_ on macOS and Linux) cut the file into pieces Excel can open. For a one-off look at the data, the browser viewer above is faster than any of these.

What to check before you blame the size

A file that opens in one column, or with Arabic shown as symbols, is not too big; it has the wrong separator or encoding. Those are separate problems with their own fixes: CSV opens in one column and broken Arabic in Excel. And a .csv that is really an HTML page or a ZIP (common with downloads that failed) will not open anywhere until renamed.

Still stuck?

Write to support@openanydoc.com with the file size and row count (no personal data), and what you need from the file.