How to compare two CSV files row by row
CSV Compare — open the free tool →CSV exports from CRMs, online stores, banks and databases are the everyday way to move data around. When you have two exports — last week's and this week's — you often need to know which customers were added, which prices changed or which orders disappeared.
Compare two CSV files in four steps
- Open CSV Compare.
- Upload the older file on the left and the newer one on the right (or paste the data).
- Turn on Ignore whitespace or Ignore case if the exports format text differently.
- Click Compare now. Added, removed and changed rows are highlighted, with changed values marked inside each row.
The files are read in your browser, so customer lists and price files are not uploaded to a CompareOnline4U server.
Prepare your files for a clean result
CSV comparison matches rows by position. A little preparation makes a big difference:
- Sort by a unique ID. Sort both files by the same column, such as order ID, SKU or email.
- Use the same delimiter. Some tools export with commas, others with semicolons. Save both files with the same one.
- Keep the same columns in the same order. If a new column was added, remove it or add it to the older file too.
- Check number formats. "1,000.00" and "1000" mean the same but will show as different.
Reading the result
- A row only on the right is a new record.
- A row only on the left was removed.
- A row on both sides with highlights has changed values — for example a new price or status.
Common uses
- Price list updates from a supplier.
- Stock levels between two days.
- New and lost subscribers in a mailing list export.
- Bank or payment exports during reconciliation.
- Database table exports before and after a migration.
Working with .xlsx workbooks? Use Excel Compare instead, which reads every sheet directly.
CSV Compare — open the free tool →Frequently asked questions
Can I upload CSV files instead of pasting?
Yes. Use the file pickers to upload .csv or .txt files, or paste the data.
Why does every row show as changed?
Usually the rows are in a different order or use different delimiters. Sort both files by the same ID and use the same delimiter.
Are my CSV files uploaded?
No. Files are read and compared in your browser.