Files to merge
CSV files (select several)
Hold Ctrl or Cmd to pick more than one. Each file can use its own delimiter and encoding.
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)
Match columns by
Header name (recommended)
Position (ignore header names)
Treat
ID
and
id
as the same column
Add a
source_file
column with each row’s file name
Skip completely blank rows
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.
Merge files
Reset
Result
Choose a file to begin.