SPARKPOND / COMPARE CSV

Compare Two CSV Files Online

Use a stable key to distinguish moved rows from real changes. Duplicate keys are reported before comparison because they make one-to-one changes ambiguous.

✓ Processed locally✓ No account✓ Original unchanged

LOCAL WORKSPACE

Add your data files

Two CSV files, Two TSV files. أو أفلتها هنا.

Download the example file ↓

Focused purpose

What this tool does

Compare two CSV or TSV versions locally by a chosen key. Find added, removed and changed rows, inspect duplicate keys and export a report without an account.

  • ✓ Added and removed rows
  • ✓ Cell-level modifications
  • ✓ Key selection
  • ✓ Duplicate-key report

Workflow

How to use it

  1. 01

    Open old and new files.

  2. 02

    Choose a key and resolve duplicates.

  3. 03

    Review added, removed and changed groups, then export.

Available controls

Available options

  • Choose one stable key column.
  • Select columns to compare.
  • Ignore explicitly selected fields.
  • Export a machine-readable report.

Product price changes

Example before and after

One product changed, one disappeared and one was added.

Before

old.csv
sku,price
A,10
B,20

new.csv
sku,price
A,12
C,30

After

changed: A price 10 → 12
removed: B
added: C

Expected result: The report separates the three change types by SKU.

Download example ↓

Practical scenarios

Common use cases

Audit a new supplier export.

Review a catalogue update.

Verify a migration result.

HONEST LIMITS

Important limitations

  • iWithout a stable key, row moves can look like deletion and addition.
  • iDuplicate keys must be resolved or accepted as ambiguous groups.

FAQ

Questions about this tool

How is a modified row detected?

Rows with the same chosen key are compared field by field.

What if keys are duplicated?

The tool reports ambiguity and estimates matching groups before comparison.

Can I export the differences?

Yes. Export a CSV or readable HTML report with no file content sent away.