Columns to keep
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 (column names)
Trim spaces from the start and end of every cell
Drop completely blank rows
Columns: tick to keep, edit the name, move with the arrows
Tick all
Untick all
Untick empty columns
Reverse order
Sort A to Z
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.
Download CSV
Reset
Result
Choose a file to begin.