EXPORTS IN. DIFFERENCES OUT.
Two files.
One clear comparison.
Match records by key, then inspect missing entries, changed values and duplicates. Your files stay in this browser.
Profiles contain column mappings and format settings only.
Left source
Your first export or reference file.
Add a source to map its columns.
Right source
The export you want to compare.
Add a source to map its columns.
COMPARISON REPORT
Your results
| Status / record key | Left | Right | Review note |
|---|
HOW TO USE IT
A comparison you can inspect.
- Export two files covering the same scope. In Excel, save each worksheet as CSV UTF-8. Native .xlsx files are not supported.
- Choose formats and map columns. Select a unique key. Amount and currency are optional, but must be enabled on both sides.
- Review and export. Repair invalid rows and duplicate keys before relying on missing-record findings.
Exactly what is compared?
Record keys use exact, case-sensitive matching after surrounding spaces are removed. Amounts use exact signed decimals, never floating-point arithmetic. Currency labels are trimmed and uppercased; three letters are required, but codes are not checked against an ISO registry.
A match means the key and your selected fields are equal. Unmapped columns are not compared. No fuzzy matching, currency conversion, grouping, totals or business-loss estimates are performed.
Which CSV formats are supported?
Choose comma, semicolon or tab per source. UTF-8, a UTF-8 BOM, CRLF/LF line endings, quoted delimiters, quoted newlines and escaped double quotes are supported. Empty physical lines are ignored. Header names must be non-empty and unique ignoring spaces and letter case; each data record must have the same number of columns.
Amounts require 1–18 whole digits and up to 6 fractional digits. A leading + or − (ASCII hyphen) is accepted. Select dot or comma decimals explicitly; thousands separators, scientific notation, parentheses and currency symbols are not supported. Thus 1,234 in comma-decimal mode means 1.234, not 1234.
Each source is limited to 2 MB, 100 columns, and the row limit shown above. Record keys can contain up to 300 characters. If text looks garbled, re-export it as UTF-8.
How are duplicates and invalid rows handled?
If a key is duplicated or a mapped value is invalid, that key is excluded from matching on both sides. No duplicates are collapsed or summed. A duplicate group creates one review entry; an invalid row can create another, so review entries are not a count of affected records.
If a source contains an empty key, a record found only on the other side is marked unresolved until the empty key is repaired. Report row numbers count CSV records (header = 1), not physical lines inside quoted cells.
Where do my files and settings go?
Your data is processed in this browser tab. The app makes no network requests, saves no input to browser storage and contains no analytics. Clearing the app removes its current working data. Refreshing or closing the page loses the session.
Downloaded reports contain your compared values. Keep them private. Profiles contain header names, mappings and format settings only; do not put sensitive values in header names. Report cells that could be interpreted as spreadsheet formulas receive a leading apostrophe.