Open a large CSV file
Excel can't open more than 1,048,576 rows in one sheet. This page counts the rows instead of building that sheet. Your browser reads the file in the background and reports the real row count. The preview loads only the rows on screen.
🔒 Your files stay in your browser and are never uploaded
- Choose file.
- Search.
- Next.
Before
id,name 1,A 2,B
After
| # | id | name |
|---|---|---|
| 1 | 1 | A |
| 2 | 2 | B |
Will a million-row file freeze the page?
The whole file is read into memory. A very large file can slow the browser or make it unresponsive. The preview loads only the rows on screen.
Is the count the same number Excel would load?
No. Excel stops at 1,048,576 rows. This page counts every data row in the file.
Why does Excel stop?
A worksheet holds at most 1,048,576 rows. Rows after that are not loaded. For example, Excel only opens the first 1,048,576 rows of a 1.2-million-row file.