Skip to content
utilnest

Compare CSV files

Spot exactly what changed between two versions of a spreadsheet export.

  • Works in your browser
  • No sign-up
  • Free to use

How to use Compare CSV files

  1. 1

    Paste or choose the original CSV on the left and the changed one on the right.

  2. 2

    Check the "Match rows by" column. An ID column is picked for you when there is one.

  3. 3

    Read the counts and the highlighted table, then download the differences as a CSV if you need them.

What this tool does

Compare CSV files shows the difference between two versions of a table: which rows are new, which are gone, and which cells changed. It's handy for checking price list updates, stock changes, customer list edits and data exports before you import them.

Features

  • Added, removed and changed rows, with counts.
  • Key column matching with automatic ID detection, or whole-row comparison.
  • Changed cells highlighted with the old value crossed out next to the new one.
  • New and dropped columns listed.
  • Options to ignore case and surrounding spaces, and a CSV download of all differences.

Limits

  • If an ID appears more than once in a file, only its first row is compared; the tool tells you when this happens.
  • The table shows the first 300 rows of each kind; the download includes everything.

Where your files are processed

This tool works in your browser: both files are compared on your own device, so they aren't sent to our server for this tool. Some other tools on UtiloNest do use our server, and their pages say so.

Frequently asked questions

Why should I match rows by an ID column?

With an ID, such as an order number or product code, a row that keeps its ID but has a new price shows as changed, with the old and new values side by side. Without one, the tool can only see that the old row disappeared and a new one appeared.

Does the row order matter?

No. Rows are matched by ID or by content, so sorting a file differently doesn't count as a change.

What happens with columns that were added or removed?

They're listed above the table. When matching by ID, a new column's values in existing rows are shown as changed.

Can it ignore small differences?

Yes. Turn on "Ignore upper/lower case" and "Ignore spaces around values" so that "lahore " and "Lahore" count as the same.

Are my files uploaded?

No. The comparison runs in your browser, so both files stay on your device.

Was this tool helpful?