How to open a CSV with more than 1 million rows

Trying to open a large CSV in a spreadsheet can leave you waiting, show only part of the file, or produce a warning. The CSV file may be fine: spreadsheet apps have row limits, and large files can use a lot of memory.

The CSV Editor opens CSV files in your browser and supports files up to 10 million rows. You can search, sort, edit, and remove duplicate rows. Whether a particular file loads smoothly also depends on its size, number of columns, and your device. The file stays on your device.

Open the CSV file

1. Open the CSV Editor.
2. Choose the option to open a file, then select the CSV from your computer. If you downloaded it, check your Downloads folder.
3. Give the editor time to read the file. A large CSV can take longer than a small one, so avoid refreshing the page while it is loading.
4. Once the rows appear, search for a value you recognize or sort a column to check that the data is present and in the expected order.
5. If you need to clean the data, use the editor's search, sorting, editing, or duplicate-removal features. Keep a copy of the original before making changes.

A CSV is a text file containing rows and fields separated by delimiters, usually commas. It is not an Excel workbook, so opening it does not require Excel. If you need help with the next steps after opening it, see how to work with a huge CSV without opening Excel.

What the result means

The file opens and the values are in separate columns

The editor has read the CSV structure. You can search for a value to check whether a row is present, or sort by a column to inspect the data. If you need to make corrections, work on a copy so you can return to the original if needed.

The file opens, but the data is in one column

The file may use a different separator, such as a semicolon or tab, instead of commas. It can also happen when the file was exported with unexpected formatting. Check how the data was created, and if possible, export it again as a standard comma-separated CSV.

The file opens in Excel but some rows are missing

Excel worksheets have a limit of 1,048,576 rows, including the header row. A CSV can contain more rows than that, but Excel cannot show all of them on one worksheet. For example, a file with 1,048,576 data rows plus a header exceeds the worksheet limit. Use a tool that supports more rows, such as the CSV Editor, instead of relying on the spreadsheet preview.

The page is still loading or stops responding

The file may be using more memory than your browser or device can comfortably provide. Row count is not the only factor: a CSV with many columns or long text fields can be much larger and harder to process than another file with the same number of rows.

What to do if it will not open

1. Wait before trying again. A file with millions of rows may take longer to process than you expect. If the browser is still responding, let it finish rather than opening the same file in another tab.
2. Close other large apps and tabs. Freeing memory can help the browser handle a large file. Close unused browser tabs and programs, then reopen the editor and try again.
3. Check that the file downloaded completely. Compare its size with the file at the source, if available, and download it again if the transfer stopped early. A file with a .csv extension is not necessarily a complete or correctly formatted CSV.
4. Try a smaller export. If the data comes from a report or database, export only the columns and date range you need. Smaller files are faster to load and easier to check.
5. Split the file carefully if it is too large. Export separate batches from the source when possible, and include the column headings in each batch. Avoid splitting a CSV at arbitrary line breaks: quoted text fields can contain line breaks, which can split a record incorrectly. For another local approach, read how to inspect a 10-million-row CSV file locally.

Why a CSV can be larger than a spreadsheet can handle

A CSV file is not limited to the number of rows a spreadsheet can display. It can store more rows as plain text, but the application opening it still needs enough memory to read and display the data. A spreadsheet may also stop at its own row limit even when the file contains more information.

The CSV Editor supports files up to 10 million rows, but that is a maximum row count, not a promise that every file of that size will load on every device. If the file has unusually wide rows, large text fields, or your browser is already using substantial memory, try a smaller export or inspect the file in batches.

When you only need to locate or check data, search the file before editing it, and keep the original CSV unchanged as a backup.