Convert JSON to Excel

Paste the JSON you were handed and get a spreadsheet back: one sheet per list, already joined up by ID, with every digit of every number intact.

A list inside your file becomes its own sheet — not sixty columns called items/0/sku, items/1/sku, items/2/sku.

0 bytes uploaded · no account · free

Paste JSON nothing leaves this tab

you see the sheets it found, and can rename or drop columns, before anything downloads

⌃↵ to convert

The three things that usually go wrong

lists

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.

privacy

The file never leaves your browser

There is nothing to upload, no account to make, and no server behind this page that could keep a copy. Turn your wifi off once the page has loaded and the conversion still works.

numbers

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.

Your file, as sheets

One sheet per list, joined by an ID column that is filled in for you. Download it as an Excel file, or as a folder of CSVs if you are feeding it to something else.

orders        id · customer · placed_at
order_items   order_id · sku · qty · price
addresses     order_id · line1 · city · postcode

You approve it before it downloads

You see real rows from your own file first, and rename headings or drop the columns you do not want. Save the setup when it looks right, and next month's file gives you the same sheets with the same headings — no redoing it by hand.

.xlsx one CSV per sheet saved setups

Why nothing is uploaded

The conversion runs inside this browser tab, the way a formula runs inside Excel. Your file is read here and nowhere else — there is no server to send it to, which is why it keeps working with your wifi off. Nothing is logged, counted, or kept anywhere but your own computer, so 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