Table Diff
Compares two tables by a chosen or inferred key column and lists added, removed and changed rows cell by cell, side by side or as a change log.
Last month’s file and this month’s, answered cell by cell: what was added, what was removed, and in the rows that survived, which cells changed and from what to what. Columns are paired by name rather than by position, so a column inserted in the middle does not make everything after it look different.
Before
Drop the earlier table
Read in this tab. Nothing is uploaded. Files from Korean, Japanese, Chinese and Western Excel (CP949, Shift_JIS, GBK, Windows-1252) are recognised.
After
Drop the later table
Read in this tab. Nothing is uploaded. Files from Korean, Japanese, Chinese and Western Excel (CP949, Shift_JIS, GBK, Windows-1252) are recognised.
How to use it
Drop the before and the after
Order matters here: added and removed are relative to the first file.
Choose the key column
The column that says which row is which — an order number, an employee id. Automatic looks for a column that is unique on both sides, and says which one it picked.
Filter to what you care about
Differences only is the default. Changed cells are highlighted with the old value struck through and the new one beside it.
Download the change log
One row per changed cell, which is the shape an audit trail wants. The side-by-side export is the other shape, for reading.
Common questions
Everything after row 40 shows as changed
No key column was found, so rows were compared in file order, and a row inserted at 40 shifts everything below it by one. Pick a key column and the noise disappears.
Is 1,000 different from 1000?
Not when the column was read as numeric — numbers are compared as numbers. If the column came in as text they are two different strings, which the column statistics tool will show you.
What if the key repeats?
Rows with the same key are paired in the order they appear, and the page says how many there were. A key that repeats is usually itself the problem you were looking for.
A column exists in only one file
It is shown, tagged with which side it came from, and it does not count towards a row being changed. A new column added this month should not make every row look modified.
Feed it from
Text Diff
Compares two texts side by side or inline, at line, word or character granularity.
CSV Join
Joins two tables on a key column with inner, left, right or outer semantics and shows unmatched rows.
Delivery Platform Reconciliation
Reads 배달의민족·쿠팡이츠·요기요 settlement CSVs by column name, totals the fees, and matches each payout against your bank statement by amount and date, listing what never arrived.
Timezone Converter
Converts a moment across timezones and shows a shared-hours grid for scheduling across regions.
Next
These accept what this tool produces, so the result can go straight in.
CSV Cleaner
Trims cells, normalises headers, fixes number and date formats and reports rows with the wrong column count.
CSV Join
Joins two tables on a key column with inner, left, right or outer semantics and shows unmatched rows.
Delivery Platform Reconciliation
Reads 배달의민족·쿠팡이츠·요기요 settlement CSVs by column name, totals the fees, and matches each payout against your bank statement by amount and date, listing what never arrived.
Text Diff
Compares two texts side by side or inline, at line, word or character granularity.
CSV Viewer
Opens a large delimited file with type detection, column stats and sorting, without loading it all into memory.
Quick Chart
Draws a bar, line, area, pie or scatter chart from a table with round-number axes and a legend, and exports it as SVG or PNG.