CSV comparison workflow
Compare two CSV files before trusting the update
An updated export can silently drop or change rows. Compare it against the previous version before using it downstream.
Compare using a stable key
Row position is not reliable. Match rows using an identifier column instead.
Load the earlier file
Use the version currently trusted as correct.
Load the updated file
Use the new export you want to verify.
Choose the key column
Select a stable identifier such as an ID or code.
Review the differences
Check added, removed, and changed rows before proceeding.
Two ways to compare
- Row-by-row with a line-by-line diff report
- Key-based comparison that matches rows on a chosen column
- Summary counts of added, removed, and changed rows
Why row comparison is tricky
- Row order can differ between exports
- A missing key column makes matching unreliable
- Minor formatting differences look like real changes
- Large files are impractical to compare by eye
Compare with confidence
- Always compare using a unique key column
- Normalize formatting before comparing values
- Review removed rows first, since they are often the most important
- Keep both files until the comparison is confirmed
Frequently asked questions
What is the difference between row and key comparison?
Row comparison aligns files by position; key comparison matches rows by a column value, which tolerates reordered rows.
Does the report show the actual changed values?
Yes. Changed rows are listed with both the old and new values for review.
Can I compare files with different column orders?
Key comparison works when the key column exists in both files regardless of position.
Is my data uploaded?
No. Comparison runs locally in your browser.
Both files are compared locally
The comparison runs in the browser. Sensitive records are not uploaded for standard processing.
Open Compare CSV Files