Files to compare
File A (before)
File B (after)
Both files are 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)
Key column(s): identify the same record in both files
Ignore these columns when comparing (optional)
Useful for columns that always change, such as updated_at.
Ignore spaces at the start and end of values
Ignore upper and lower case
Differences 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.
Compare
Reset
Result
Choose a file to begin.