How to sort a large CSV file in your browser

A large CSV file can be hard to search when its rows are out of order. You may need to group records by date, find the highest value, or put names in alphabetical order without installing a desktop app.

The CSV Editor opens CSV files in your browser and can sort, edit, find, and remove duplicates. It supports files up to 10 million rows, although the time it takes depends on the file and your device.

Sort the CSV file

1. Open the CSV Editor and choose your CSV file from the file picker. If the data matters, keep an untouched copy of the original before you start.
2. Wait for the rows and column headers to appear. Check that the first row is being treated as column names, not as an ordinary row of data.
3. Choose the column you want to sort by. Set the order to ascending for A to Z, smallest to largest, or oldest to newest. Choose descending for the reverse order.
4. Check a few rows near the top, middle, and bottom. If the order is right, save or download the sorted result using the editor's available export option.

Sorting should move whole rows, not just the values in one column. That keeps each name, date, and other field attached to the same record. If the result looks wrong, do not overwrite your original file. Check the issues below, then sort again.

What the sorted result means

Rows appear in the order you expected

The sort worked for that column. For a quick check, look at the first and last few values, then spot-check a value from the middle. If the file contains related columns, verify that the values in each row still belong together.

Numbers look out of order

Check values such as 2, 10, and 100. If they appear as 10, 100, 2, the values may be treated like text instead of numbers, or may contain extra characters. Look for spaces, currency symbols, or inconsistent formats in that column.

Dates are not in calendar order

Dates written in different formats can sort unexpectedly. For example, a mix of 2025-02-10 and 2/10/2025 may not be read consistently. Make the date format consistent in a copy of the file, then sort again.

The header is mixed in with the data

The first row may have been treated as a regular record. Reopen the original and check whether the editor recognizes the header row. If your file has no column names, the first row is data and should remain part of the sort.

How to fix a sort that looks wrong

1. Check the column. Confirm that you sorted by the field you meant to use. A file can have similar columns, such as created_at and updated_at.
2. Reverse the order. If the values are in the right sequence but start at the wrong end, switch between ascending and descending rather than choosing a different column.
3. Look for blanks and inconsistent values. Empty cells, spaces, or mixed formats can make a sort seem uneven. Review the affected column and make its values consistent before trying again.
4. Check whether the header is included. Reopen the original and set the first row as a header if the editor offers that choice. Without a header, leave the first row in the data.
5. Try a smaller copy. If sorting takes too long or the browser becomes unresponsive, make a copy with fewer rows and test it first. Large files use more memory, especially when they have many columns or long text fields.
6. Use a device with more available memory. Close other tabs and apps, then try the full file again. The editor supports up to 10 million rows, but wide files can reach a device's practical memory limit sooner.

Why a large CSV can take time to sort

A CSV is plain text arranged as rows and columns. The browser has to read that text, separate the fields, and reorder the rows. A file with many long text fields can take more memory than a smaller file with short values. Your browser and device also affect how quickly the work finishes.

Commas inside a properly quoted CSV value are part of that value, not a new column. If the file appears to have shifted data or unexpected columns, check how it was saved before sorting. Sorting cannot repair a damaged or inconsistently formatted file by itself.

The CSV Editor runs in your browser, and files you open stay on your device. Keep a copy of the original until you have checked and saved the sorted version.