Compare Excel files by key

1. Choose 2–5 Excel files, with the first as the reference. Select one sheet per file.
2. Choose matching columns to identify the same record, then select values to compare, such as Quantity or Amount.
3. Click Compare files, review differences and records that need attention, then download the full .xlsx report.

Unique ID mode requires 1–3 matching fields and 1–8 comparison fields, with no shared column. Matching values should uniquely identify each row. Row matching uses 1–8 fields in total, including at least one match field; other fields can compare values. Set their purposes in detailed settings.

In Unique ID mode, add SKU or another matching field for orders with multiple lines. Row matching allows duplicates: equal values match first within each matching group, then remaining rows pair in source order and differing fields are marked. Unpaired rows show which file is missing a row. Each row is used once.

Matching columns identify the same record, such as Order ID + SKU. Columns to compare are the values you want to check, such as Quantity, Unit price, and Amount. Select or clear columns in the dropdowns.

Identical headers map automatically. For different headers, open Map columns and select the corresponding column in each comparison file. You can also set decimal precision and trim leading or trailing spaces.

Use .xlsx or standard, unencrypted Excel 97–2003 .xls tables. Both formats can be mixed in one comparison. Hidden rows are included. Entirely blank rows, including templates with saved blank formula results, are skipped; original Excel row numbers are preserved. Limits are 10 MiB per file, 30 MiB total, 10,000 rows and 50 columns per sheet, and 1 million cells across all files.

Encrypted or damaged files and merged cells in required columns need preparation first. The source preview shows the first 10 rows of each selected sheet.

Choose 2–5 files. The first file is the reference; each remaining file is compared with it separately. Select one sheet per file. Headers default to row 1; choose rows 1–10 in each file row.

Raw values distinguishes text from numbers: the text "10" differs from the number 10. Leading zeros in text are preserved. Numeric values mode can convert strict decimal text and compare at your chosen precision. Reports keep the original values.

Numeric values mode does not convert currency symbols, thousands separators, percentages, or units. Values that cannot be converted are marked as needing review with a reason. Formulas use saved results; calculate and save the workbook in Excel first.

In Unique ID mode, duplicate matching values cannot identify one row; source rows stay in Issues without merging. Row matching allows duplicates and pairs rows according to the selected field purposes. Error cells, formulas without saved results, and other invalid values still need review.

Unique ID mode counts each comparison file’s keys relative to the reference. One reference record can affect several comparison files. Use Issues to understand records that need review.

Unique ID mode opens differences and review groups, shows changes as reference → comparison, and lists duplicates or invalid records in Issues. Row matching opens all results with original values and sources side by side, highlighting fields that differ.

Both modes export .xlsx files. Unique ID mode includes three sheets: summary, comparison details, and issues. Row matching uses one sheet with original values, sources, and statuses side by side. Search, filters, and paging do not reduce either export.

Full screen is available in Unique ID mode. Choose Full screen on a computer, or use More on a phone to enter or exit. Your search, filters, and page stay selected.

Reading files, comparing values, and exporting reports all happen on your device. Original files are not modified. Refreshing, closing the page, or leaving the workspace clears the current files and results. Download your report first.

Select a saved setup in the columns section to reuse settings, or choose Save this setup to create one. You can also choose Save this setup on the results page, under More on phones, and keep reviewing or exporting afterward. Setups save sheet names, columns, and rules; they do not save business data.