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.
#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 processingrow
rows
Ad space
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.
| Format | Support |
|---|---|
| XLSX / XLS | Parsed locally; advanced workbook objects may not be preserved |
| CSV / TSV | Quoted 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.
Related office tools
Processing summary
| Stage | Action |
|---|---|
| Input | Validated and parsed locally |
| Output | A newly generated file is downloaded |
Browse more office tools
Office tool hubsSpreadsheet ConversionConvert Excel, CSV, JSON, HTML, and other table formats.View all
Spreadsheet CleanupRemove duplicates, blanks, extra spaces, and inconsistent values.View all
Merge Split & OrganizeCombine, divide, extract, and arrange workbooks and sheets.View all
CSV & Delimited FilesView, edit, clean, validate, and convert delimited data files.View all