Favorite places of your favorite city
Home
Add to preferred sources on Google

Compare Two CSV Files

Match rows by a key column and find added, removed and changed records.

Each file: 10 MiB raw and 5,000,000 text units. Both files together: 2,000,000 parsed cells.

File A — Before / File B — After

File A — Before

Separator

Encoding

File B — After

Separator

Encoding

Match by key

Keys match as exact text. Case, spaces and leading zeros matter.

Key in A

Key in B

Comparison results

Supply data or choose an empty dataset.

How to compare CSV files

  1. Paste or open the before and after files.
  2. Choose a key column on each side and the value columns to compare.
  3. Review differences and unresolved rows; download the full report.

What the comparison shows

  • Matches records by exact key, regardless of row order.
  • Shows duplicate keys separately instead of guessing.
  • Exports complete JSON and CSV reports.
  • Compares only the selected value columns and lists schema differences separately.

When this is useful

  • Check changes between inventory exports.
  • Compare reports with reordered columns.
  • Audit changed prices in recurring supplier files.

How to read the results

Added means only in B; removed means only in A. A changed key appears as a removal and an addition.

One-sided columns are schema differences; excluded fields limit equality.

Reading the CSV record report

The CSV report uses fixed field names: status, key_before, key_after, row_before, row_after, before_present, after_present, changed_columns, before_values, after_values, reason. Source record numbers are 1-based and include the header record.

The statuses added, removed, changed, unchanged and unresolved are stable codes. changed_columns and the values fields contain JSON arrays; a missing side is JSON null. The JSON report also includes settings, column mappings and counts.

Privacy and limits

Files are parsed in your browser. Each may be 10 MiB raw and 5 million text units; together they may contain 2 million cells.

CSV comparison questions

No. Records are matched by the key you choose.

Every related row is unresolved and included in the report.

JSON to CSV Converter

Convert flat JSON records to delimited text with first-seen columns, original number spellings and explicit empty-value rules.

Open tool — JSON to CSV Converter

CSV Delimiter Converter

Convert CSV separators, preview real columns and spot import problems. Works locally with CSV, TSV and text; values remain unchanged.

Open tool — CSV Delimiter Converter

CSV Duplicate Finder & Remover

Find exact duplicate CSV rows or repeated IDs. Review conflicting values, keep original data and download retained, removed and unresolved records.

Open tool — CSV Duplicate Finder & Remover

CSV Merger

Combine rows from several CSV files by exact column name. Preview alignment and download CSV with a merge report.

Open tool — CSV Merger

CSV to JSON Converter

Convert CSV text or UTF-8 files to JSON objects or arrays, keeping cells as strings without guessing data types.

Open tool — CSV to JSON Converter

CSV Splitter

Split a CSV by rows or exact file size. Keep headers and download each part.

Open tool — CSV Splitter
View all tools in this category