Clean up your CSV file

Drop your CSV, set the cleanup options and download the fixed file. Your file never leaves this computer.

Rules

Reading

Delimiter Character encoding First row is a header

Clean up

Trim spaces at the start and end of each cell Collapse repeated spaces inside cells Remove empty rows Remove completely empty columns Remove duplicate rows Compare by

Find and replace

Find Replace with

Applies to every cell. If "Replace with" is empty the match is deleted.

Columns

Checked columns stay in the output.

Sort

By column

Direction

Sort as numbers

Output

Output delimiter Wrap every cell in quotes Add UTF-8 BOM for Excel (keeps accented letters intact) Windows line endings (CRLF)

Drop your CSV file here or click to choose. To paste text instead, use the link below.

Preview 0

Only the first 100 rows are shown. The downloaded file contains every row.

How to use it

Drop your CSV file into the box or paste the text.
The delimiter and character encoding are detected automatically.
On the left, set the cleanup of empty rows, duplicate rows and extra spaces.
Check the preview and download the CSV.

Frequently asked questions

Accented letters look broken in Excel, what can I do?

Turn on Add UTF-8 BOM for Excel in the Output section. Excel then opens the file with the right encoding.

Do large files work?

Files up to 30 MB work as long as the browser has enough memory. A file with 50,000 rows is processed in under a second.

Can I remove duplicates by a single column?

Yes. Pick a column such as email in the Compare by list under Clean up, and the first row for each value is kept.

Preview 0

How to use it

Frequently asked questions

Related tools