#178 · Compare Audit & Reconcile Tool

Find New Rows in Updated File

Compare an original and updated spreadsheet by selected key columns, then export rows that appear only in the updated file.

Office File Tool

Local browser processing
row
rows
Ad space

How to use this office tool

Select exactly two files: the original first and the updated file second. Enter one or more 1-based key columns, separated by commas, when prompted.

What this tool does

Rows are compared using normalized values from the chosen key columns. Rows whose composite key is absent from the original are exported to a new XLSX workbook.

Rows are compared using normalized values from the chosen key columns. Rows whose composite key is absent from the original are exported to a new XLSX workbook.

Duplicate keys are treated as the same record identity. Choose columns that reliably identify a row.

Supported formats

XLSX, XLS, CSV, and TSV are accepted where the operation supports them. Browser memory, parser support, and Excel worksheet limits apply.

FormatSupport
XLSX / XLSParsed locally; advanced workbook objects may not be preserved
CSV / TSVQuoted fields supported; encoding is read by the browser

Tips for better results

  • Select files in baseline-then-updated order.
  • Use stable IDs rather than names when possible.
  • Check blank or duplicate keys before relying on the result.

FAQ

Which file should I select first for comparison?

Select the original baseline first and the updated file second.

How does the tool decide that a row is new?

It builds a key from the 1-based columns you choose and checks whether that key exists in the baseline.

Can I compare using multiple key columns?

Yes. Enter comma-separated column numbers such as 1,3 to create a composite key.

What happens when the updated file has duplicate keys?

Every updated row with a key absent from the baseline is exported; duplicate new rows are not automatically collapsed.

Are changed rows reported as new?

Only when the selected key changes. Changes in non-key columns do not create a new identity.

Processing summary

StageAction
InputValidated and parsed locally
OutputA newly generated file is downloaded

Browse more office tools

Office tool hubs