Fidument Tools · Beta version

How to compare two CSV files by key

Match two lists by an ID or compound key. Find changed, missing and duplicate records in your browser.

Need to reconcile inventory exports, order lists or snapshots before and after an update?

How to use this tool

  1. Choose two files

    Select both CSV files in the same dialog. Set the A and B order and inspect the columns.

  2. Check delimiters and choose a key

    Confirm each file's delimiter and header. Match the key columns and pair the fields to compare.

  3. Compare and download

    Review changed, missing and ambiguous records. Download the complete CSV report.

Leading zeroes, duplicates and report import

Yes. The comparison treats values as text, so 00123 and 123 are different keys. Import the report's key columns into spreadsheets as text.

Repeated keys and rows with a blank key component appear in dedicated categories. Resolve those records before matching them.

The report prefixes formula-like cell starts with an apostrophe. The comparison preview displays the original values.

Who is it for?

  • Documentation, operations and analysis

Input

  • Two UTF-8 CSV or TSV files

Output

  • UTF-8 CSV report

Capabilities

  • Select both CSV files in the same dialog. Set the A and B order and inspect the columns.
  • Confirm each file's delimiter and header. Match the key columns and pair the fields to compare.
  • Review changed, missing and ambiguous records. Download the complete CSV report.

Limitations

  • Each file must use UTF-8. The per-file limit is 10 MiB, 50,000 data records and 100 columns.
  • Comma, semicolon and tab delimiters are supported. The report uses semicolons and is limited to 32 MiB.
  • Files and processing stay in the browser.

Example use

Compare Monday and Friday inventory exports. Use product code and warehouse as a compound key, then compare quantity.

Questions and answers

Does the report preserve 00123?

Yes. The comparison treats values as text, so 00123 and 123 are different keys. Import the report's key columns into spreadsheets as text.

How are duplicates handled?

Repeated keys and rows with a blank key component appear in dedicated categories. Resolve those records before matching them.

How are formula-like cells exported?

The report prefixes formula-like cell starts with an apostrophe. The comparison preview displays the original values.

Related tools

PDF to text

Download existing text as UTF-8 in the chosen page order.

Compare CSV files

Check access and export conditions in the app. A product description does not grant access.