CSV to clean
CSV file
Read in your browser. Nothing is uploaded.
Input delimiter
Auto-detect
Comma ,
Semicolon ;
Tab
Pipe |
Input encoding
Auto-detect
UTF-8
UTF-16 LE
UTF-16 BE
Windows-1252 (Western Europe)
Windows-1250 (Central Europe)
Windows-1251 (Cyrillic)
ISO-8859-2
ISO-8859-15
Shift_JIS (Japanese)
GB18030 (Chinese)
Big5 (Chinese)
EUC-KR (Korean)
First row is a header
Rows are duplicates when
Every column matches (whole row)
The ticked key columns match
Ignore spaces at the start and end of values
Ignore upper and lower case
Treat runs of spaces as one space
Also drop completely blank rows
Keep
The first occurrence
The last occurrence
Output file
Delimiter
Same as the input file
Comma ,
Semicolon ;
Tab
Pipe |
Line endings
Same as the input file
CRLF (Windows)
LF (macOS, Linux)
Encoding
UTF-8
UTF-8 with byte order mark (opens accents correctly in Excel)
UTF-16 LE with byte order mark
Windows-1252 (accents only, no other scripts)
Put quotes around every field
Keep original cell text exactly (may be unsafe in Excel)
By default, cells that start with = + - or @ get a leading quote so Excel and Sheets cannot run them as formulas.
Remove duplicates
Reset
Result
Choose a file to begin.