Table Compare
Compare two tables row by row, matched by a key, and see which fields changed.
Your data stays in your browser
Table A
Waiting for data
Table B
Waiting for data
Compare by
Rows match by this key.
Keys and shared fields are compared exactly, including value type and letter case. Reset clears Table B, the key, and the result.
Comparison
No resultAdd two valid tables, choose one common key, then compare.
Example
Key column: id
Table A
id,name 1,Ada 2,Grace
Table B
id,name 1,Ada 2,Grace Hopper 3,Alan
Output
Added: 3 Removed: none Changed: 2 (name: Grace → Grace Hopper) Unchanged: 1
How it works
- Rows are matched by one key column that both tables have.
- Keys and values are compared exactly, including type and letter case.
- A duplicate, empty, or missing key stops the comparison and names the row.
- Changed rows list each changed field, before → after. Fields in only one table are listed but don't change a row's status.
- Keys of added, removed, or changed rows can be formatted as SQL IN or used as a list.