How to correct a CSV and save the edited file

A CSV can look fine at first, then reveal a wrong address, a misspelled category, repeated rows, or columns that do not line up. You can correct the data in a browser without changing the original file on your computer.

Use the CSV Editor to open a file, find values, edit cells, sort rows, and remove duplicates. Then save a corrected copy and check it before using it elsewhere.

Correct the CSV and save a copy

1. Open the CSV Editor and open the CSV file from your device. Keep the original file unchanged as a backup, especially if the data is important.
2. Check the column headings and a few rows near the top. Make sure each value appears in the right column. If a whole row appears in one column, pause before editing because the file may use a separator the editor did not read as expected.
3. Find the incorrect value using the editor's search. Select the relevant cell and replace only the part that is wrong. Check the row heading and column heading first so you do not change a similar value in the wrong place.
4. For repeated rows, decide what counts as a duplicate before removing anything. If two records share a name but have different dates or IDs, they may be separate records, not duplicates. Sort the data if that makes the rows easier to compare.
5. Use the editor's save or download action to create the corrected CSV. Give it a new name, such as contacts-corrected.csv, then open that saved copy and check the changed values.

The CSV Editor can handle files with up to 10 million rows, but a large file may take longer to open and edit on a computer with limited memory. Make a copy before sorting or removing rows so you can go back if the result is not what you intended.

Choose the right kind of correction

One value is wrong

Search for the value, confirm the matching row by checking another column such as an ID or date, and edit just that cell. For example, changing Jonh to John is safer than replacing every occurrence of a short name that might also appear in other records.

The same incorrect value appears in many rows

Search for the repeated mistake and review each match before changing it. A search term can occur in different contexts, so do not assume that every result should be replaced. If the editor does not offer a bulk replacement, change each confirmed cell individually.

Rows are repeated

Use the duplicate-removal feature only after deciding which columns define a duplicate. Two rows that match in every field are stronger duplicate candidates than rows that share only a name. Keep the original file so you can restore a row if the removal was too broad.

The rows are in the wrong order

Sort by a useful column, such as a date, name, or ID. Sorting changes the order of the records, not their values. If a record has several related fields, make sure the whole row moves together so names do not become paired with the wrong email addresses.

If the saved CSV still looks wrong

1. Check the column layout. If values appear joined together, or split across unexpected columns, the file may use a different separator or contain unusual quoting. Do not save over the original. Reopen the source with a tool that lets you choose how the file is separated, then save a clean CSV.
2. Check leading zeros. Codes such as 00417 can lose their first zeros when another program treats them as numbers. A CSV stores text values, but programs may interpret them when opening the file. If a code must keep its zeros, check it in a plain-text view or import it as text in the program where you use it.
3. Check special characters. If names with accents or symbols show as strange characters, the issue may be the file's text encoding. Reopen the original in a program that lets you select an encoding, then export a UTF-8 CSV and check it again.
4. Confirm the file you opened. Make sure you are viewing the newly saved copy, not the untouched original. Check the filename and the folder where the download was saved.
5. Compare the row count. If you removed duplicates, compare the number of rows before and after. If too many disappeared, return to the original and repeat the removal using a more specific set of matching fields.

Keep the CSV format in mind

A CSV is plain text arranged in rows and columns. It does not preserve spreadsheet features such as colors, multiple worksheets, formulas, or cell formatting. A value that looks like a date or number may also be interpreted differently by the next program that opens the file.

Commas and quotation marks can be part of a value, too. CSV files use quotation marks to keep a value together when it contains a comma. Avoid editing the raw punctuation unless you are sure how it is being used. The editor handles the rows as data, which is safer than changing separators by hand.

Your CSV file stays on your device while you use the browser editor. Save a separate corrected copy and keep the original until you have confirmed the new file works where you need it.