A list gets its own sheet
An order with three items does not become items/0/sku, items/1/sku, items/2/sku. The items land on their own sheet with the order's ID on every row, so a lookup or a pivot works the way you already know.
jsonloupe
Convert JSON to Excel
Paste the JSON you were handed and get a spreadsheet back: one sheet per list, joined up by ID, with every digit of every number intact.
| id | status | total | address.city | |
|---|---|---|---|---|
| 2 | 1234567890123456789 | shipped | 27.50 | Pune |
| 3 | 1234567890123456790 | packing | 12.50 | Delhi |
| 4 | ||||
| 5 |
| order_id | sku | qty | price | |
|---|---|---|---|---|
| 2 | 1234567890123456789 | MUG-RED | 2 | 8.75 |
| 3 | 1234567890123456789 | TEA-500G | 1 | 10.00 |
| 4 | 1234567890123456790 | TEA-500G | 1 | 10.00 |
| 5 | 1234567890123456790 | SPOON | 2 | 1.25 |
Paste JSON
nothing leaves this tab
you see the sheets it found, and can rename or drop columns, before anything downloads
⌃↵ to convert
What this converter gets right
Long IDs keep every digit
A 19-digit order number comes out as the number you put in, not rounded off in the last four digits. The same goes for prices and quantities: what went in is what comes out.
You approve it before it downloads
You see real rows from your own file first, and rename headings or drop columns. Save the setup, and next month's file gives you the same sheets with the same headings.
.xlsx
one CSV per sheet
saved setups
The file never leaves your browser
The conversion runs inside this tab, the way a formula runs inside Excel. There is no server to send your file to, so it keeps working with your wifi off. A file you are not allowed to email is a file you are allowed to convert.
bytes uploaded0
account needednone
works with wifi offyes
pricefree · MIT