Compare CSV Files
Check two CSV files against each other and get a list of every changed cell and every row that was added or removed. Everything is done in your browser.
- Free, no sign-up
- Files stay on your device
- Key-column matching
- Each file's separator found
- Runs on your device. Files are never uploaded.
- Free and unlimited. No sign-up, no watermark.
Compare CSV files in three steps
No account, no email, no waiting for an upload.
- STEP 01
Add both CSVs
Put the older file first and the newer one second.
- STEP 02
Set the options
Optionally name an ID column to match rows. Choose if case and extra spaces matter and whether row 1 is a header.
- STEP 03
Download the report
A text file lists changed cells, extra rows and missing rows.
What Compare CSV files does, and what it doesn't
We'd rather tell you up front than surprise you after the download.
What you get
- Row-matching by keyMatch on an ID so reordered files still compare correctly.
- Cell-by-cell modeWithout a key, row 5 is compared with row 5, with column letters and values shown before and after.
- Header-awareWith a key, columns are paired by header name, so a new column order in the second file does not cause false differences.
- Whitespace and case optionsIgnore extra spaces, or treat upper and lower case as the same.
- Hidden differences labelledA changed kind of space is called out so it is not a mystery.
Good to know
- Values onlyBoth files are plain text, so only text content is compared.
- Report, not a merged fileYou get a list of differences. It does not produce an updated CSV. Use Combine CSV files if you need to join them.
- Long reports are cutAfter 5,000 lines the rest is summarised as a count.
Your spreadsheets never leave your device
The tool runs inside your browser instead of on our servers, so there is nothing to upload, store or delete afterwards.
Typical online tool upload
Your file travels over the internet, sits on someone else's computer for a while, and you wait for the upload and the download.
Mediaextractr no upload
The tool loads into your browser once, then works on your file locally. Nothing is sent, so nothing can leak.
When people use Compare CSV files
Audit a data export
See what changed since yesterday's download.
Compare price lists
Find changed, new and discontinued products by SKU.
Verify a migration
Check that exported and re-imported data match.
Check list updates
Find which contacts were added or removed.
Mediaextractr vs typical upload tools
| MediaextractrPrivate | Typical upload tools | |
|---|---|---|
| Your file is uploaded | Never | Yes |
| Sign-up needed | No | Often, after a few files |
| Daily file limit | None | Often 1–2 free files |
| Watermark | Never | Sometimes |
| Wait for upload & download | No | Yes |
| Speed on very large files | Depends on your device | Depends on their servers |
Choosing between key and no key
Use a key whenever your rows have a unique identifier. It makes the report short and meaningful. Skip it when the files are meant to line up exactly, line for line, and you want every difference located.
Make the comparison fair
Differences in separators and quotes do not matter, because each file is read as a table first. Differences in encoding and trailing spaces can, so tidy them if you are only after content changes.
To strip repeated rows beforehand, use Remove duplicate CSV rows. To make two files share a separator, try the CSV delimiter changer. Comparing workbooks instead? Compare Excel files works the same way.
A good habit is to name the older file first. Then a plus sign always means a row that is new, and a minus sign a row that went away, which reads naturally when you are reviewing a weekly export.
Questions, answered
How do I compare two CSV files?
Add both files, optionally enter a key column and read the report of differences.
Do the CSV files leave my device?
No. Comparison is done locally in your browser.
What if the files use different separators?
That is fine. Each file's separator is detected on its own.
Can I ignore capital letters?
Yes. Untick the option that treats upper and lower case as different.
Does it show new and deleted rows?
Yes. With a key, they are listed as only in the second or only in the first file.
Will it work on my phone?
Yes, but long files are easier on a computer.