Clean up your CSV and get it ready for Excel.

Your file never leaves this computer. Everything runs in your browser, nothing is uploaded.

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.

Preview 0

Related tools