JSON Tabular Diff & Comparison ToolDot-Notation & Workstation
Compare JSON datasets row-by-row and field-by-field. Detect identical rows, modified fields, added records, and removed rows with custom primary key matching.
Sample Preset Datasets:
Dot-Notation Path & Primary Key Configuration
JSON A Dot Path:e.g. data.items
Detected:
JSON B Dot Path:e.g. data.items
Detected:
Total Rows A
4
Total Rows B
4
Match As Is
1
Modified
2
Added (B)
1
Removed (A)
1
SECTION 1: MATCHING ROWS AS IS (1 records)100% Identical rows in both JSON A & JSON B
| # | Row Key | id | name | price | stock | category | status |
|---|---|---|---|---|---|---|---|
| 1 | 101 | 101 | Wireless Headphones | 99.99 | 50 | Audio | Active |
SECTION 2: ROWS WITH SOME DIFF (2 records)Matched by Key, showing Version A (Original) vs Version B (Modified) side-by-side
| # | Row Key | Field Column | Version A (Original Value) | Version B (Modified Value) |
|---|---|---|---|---|
| 1 | 102 | id | 102 | 102 |
| name | Mechanical Keyboard | Mechanical Keyboard | ||
| price | 129.5 | 119.99 | ||
| stock | 30 | 45 | ||
| category | Accessories | Accessories | ||
| status | Active | Active | ||
| 2 | 103 | id | 103 | 103 |
| name | Ergonomic Mouse | Ergonomic Mouse | ||
| price | 49.99 | 49.99 | ||
| stock | 100 | 100 | ||
| category | Accessories | Accessories | ||
| status | Active | Discontinued |
SECTION 3: NEW ROWS (1 records)Present in JSON B, missing in JSON A
| # | Status | Row Key | id | name | price | stock | category | status |
|---|---|---|---|---|---|---|---|---|
| 1 | + Added | 105 | 105 | USB-C Docking Station | 149.99 | 60 | Accessories | Active |
SECTION 4: MISSING ROWS (1 records)Present in JSON A, removed in JSON B
| # | Status | Row Key | id | name | price | stock | category | status |
|---|---|---|---|---|---|---|---|---|
| 1 | - Removed | 104 | 104 | 27-inch 4K Monitor | 399 | 15 | Displays | Active |
FAQ
Frequently Asked Questions
Everything you need to know about this tool
The tool converts nested JSON objects or top-level arrays into structured tabular rows. It uses a primary key (e.g. `id`, `uuid`, `user_id`) to correlate rows between Version A and Version B. It then compares every field value cell-by-cell to classify rows into Identical (Match as is), Modified (Has Diff), Added (New in B), or Removed (Only in A).
Missing Something?
Want a missing feature? Or want a new tool?
We will implement it for you - 100% free of cost. Reach out to our team with your specifications and we will build it.