Large CSV viewer
Excel stops at 1,048,576 rows. This does not.
- Rows
- 0
- Columns
- 0
- File size
- 0 MB
- Read in
- 0 ms
- Matches
- -
Drop a CSV or TSV here
or
Any size. Nothing is uploaded.
That did not work
Load a file to begin
Before you start. There is no row limit. Files of four or five gigabytes open, because only the rows on screen are ever drawn.
How it works
The file is read once to record where each row begins, which takes longer the larger the file is. After that only the rows you are looking at are read and drawn, so scrolling a five gigabyte file is as quick as scrolling a small one.
Questions
Why will Excel not open my file?
Excel stops at 1,048,576 rows. It is a fixed limit in the program and cannot be raised. A longer file opens only as far as that row, with a warning, and saving it from Excel then loses the rest.
How big a file can this open?
There is no row limit. Files of four or five gigabytes work, because the whole file is never held in memory at once.
Can I search the whole file?
Yes. The search reads through the entire file and lists every matching row, however large the file is.
Is my data uploaded?
No. This matters here more than anywhere else on the site, because large CSV files are usually exports of customer or financial records.
Can I save part of it?
Yes. Save keeps up to 500,000 rows of what is listed, the whole file or only the rows that matched your search. Split writes the whole file in parts.