Fix CSV character encoding

Repair broken-looking letters and download a CSV that opens correctly in Excel. 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. The encoding (UTF-8 or Windows-1254) is detected automatically.
Check in the preview that the letters look right. If not, pick the encoding by hand in the Reading section.
In the Output section the UTF-8 BOM for Excel option is on. Download the CSV.

Frequently asked questions

Why do accented letters look broken?

The encoding of the file does not match the encoding the program expects. Older Turkish Excel uses Windows-1254 while most modern programs expect UTF-8. The tool detects the encoding automatically.

Which output should I choose?

If you will open the file in Excel, keep Add UTF-8 BOM on. If you hand it to another program or system, UTF-8 without BOM is usually safer, so turn the box off.

What if automatic detection is wrong?

In the Reading section you can pick UTF-8 or Windows-1254 by hand from the Character encoding list.

Preview 0

How to use it

Frequently asked questions

Related tools