THE FOLIOTERN WORKBENCH

Find what changed between two spreadsheets.

Compare two CSV, TSV or Excel sheets using the column that identifies a record. Row order can change without creating false additions. Choose one value pair or compare all shared non-key columns.

Compare Excel & CSV files by ID Try sample data
File contents stay in your browserFree · no account to run or export
A PRACTICAL EXAMPLE

Order 00102 can move from row 3 to row 9 and still match. If its amount changes from 49.90 to 54.90, it is marked Changed rather than Removed and Added.

01

Choose an original and an update

Add two files and select the worksheet in each Excel workbook. File A is the original and file B is the updated export. Choose a matching ID column on each side.

02

Set the comparison rules

Compare all shared non-key column names, or choose one value column from each file. Trim spaces or ignore case if that is appropriate for your data. Amount formatting can be normalised without converting ID keys.

03

Inspect the differences

The result labels Added, Removed, Changed and Unchanged records. Duplicate IDs are reported as ambiguous, and blank IDs are listed separately. Download the overview plus a cell-level change report.

Know what to expect

This compares table values. It does not compare Excel formatting, charts, formulas or workbook structure. Formula cells are read from their saved cached values; recalculate and save the source first.

Supports CSV, TSV and unencrypted XLSX, up to 20 MB per file and 100 input columns. Free use includes 2,000 total input rows per run. Excel downloads contain text cells to preserve identifiers such as 00123. Workbook styling and formulas are not retained.

Read the file and export guide

Clean CSV & Excel files

Trim spaces, remove duplicate rows and standardise selected date and number columns. Download a change report alongside your cleaned data.

Merge CSV & Excel files online

Stack exports with different headers or join two files using an ID. Keep source file and row details so the combined result is easier to trace.

Map & rename CSV columns

Rename, reorder and select columns for an import. Set defaults or constant values, then save the mapping for the next export.