VLOOKUP finds rows in one list that exist in the other. A reconciliation needs both directions, plus the differences. This does all three in one step.
How it works
- Drop two files: Excel (.xlsx), CSV or a text PDF. Any pair works.
- The shared key (invoice number, ID, reference) and the matching columns are found automatically. Adjust them if needed.
- See what is clean, what is within your tolerance, what differs, and what exists on only one side.
- Export the result to Excel or CSV. The side you choose takes precedence.
Why VLOOKUP falls short
- It checks one direction, so rows that exist only in the second list stay invisible.
- It returns the first match, so duplicate keys are silently skipped.
- It compares nothing: you still add columns to subtract and flag differences.
What you get instead
Each key is matched across both files. Duplicates are paired in order. Every compared column shows a difference, and totals for both sides tie out to a single difference figure. The result exports to Excel with a summary and an exceptions sheet.
Files are read inside your browser tab. Nothing is uploaded, no account is needed, and nothing is saved: closing the tab clears everything. The comparison code is open source.
Questions
Are my files uploaded anywhere?
No. The files are read and compared by code running in your browser tab. There is no server that receives them, no account and no storage; closing the tab clears them.
Is it free?
Yes. There is no sign-up. Files up to 50 MB and 150,000 rows each are supported.
What can I compare?
Excel (.xlsx), CSV and PDFs that contain selectable text with a table. Scanned PDFs (pictures of paper) are not supported.
How are rows matched?
On a key column both files share, such as an invoice number. The key is detected for you and can be changed. Rows are then compared column by column.
What is a tolerance?
How far two values may differ and still count as a match: for example 1, $1, 0.1%, "1 or 0.1%" for amounts, or 3 days for dates. Use ignore case for text.