Compare two tables by ID
Find added and removed records and see exactly which fields changed between two spreadsheet lists.
Start here
Copy the full table including column names from each Excel sheet and paste it here, or choose two CSV files. Select a unique ID column such as asset ID or account number; row order can differ. Values are compared exactly, including spaces and letter case. The comparison runs in this browser.
See an example input (made-up data)
ID Model Status A01 Pump Open A02 Valve Ready
Your result
Add your input, then use the button to see your result here.
What this can and cannot do
Both tables need the same column names, but their order may differ. Each ID must appear once per table and cannot be blank. The tool reports added records, removed records and each changed field; it does not edit either source. CSV and tab-separated text are supported. For Excel workbooks, copy the cells into the boxes; .xlsx upload and formula comparison are not supported. Only the displayed cell values are compared. Up to 5 MB and 50,000 data rows per table, 100 columns. Keep your source files and review the downloaded change list before acting on it.
Something missing or not working?
Tell us what happened or what would make this more useful. Only the message you write here is sent. Please leave out private files, passwords and customer details. You do not need to give an email address. This suggestion form cannot show replies. Use a private help request if you need a reply.