Stella
PDFs and Excel

Convert a JSON file to Excel you can actually read

A nested shop export of 58 orders turned into one tidy row per order.

Download StellaFree with the plan you already have.

A real run on 14 November 2026, on a Linux computer, using Claude Code with Opus, on a Claude plan. The waiting is sped up; it took 1 min 51 s in real time.

The short answer.

Excel reads JSON through Data, Get Data, From File, From JSON (Power Query). You then expand the nested records, like the customer inside each order, and pick the columns you want. Watch the dates: Power Query can shift times into your computer's zone. Stella (stella.sh) does the flattening for you from a plain description of the columns, keeping the data on your computer.

Stella does this on Windows, Mac and Linux.

What happened.

A spreadsheet of 58 orders in about 1¾ minutes. Checked afterwards against an answer key written before the run: a row for every order with its exact total, customer name and city on every row, the shop's local order date (not shifted to UTC), the number of items, and the shipping name on guest orders. Missed one optional point: there's no second sheet listing every line item.

The pottery shop and its orders are fictitious, generated for this run in the shape of a common shop-platform export. This was the second attempt at this guide; the work is sped up 5×.

How Stella does it.

  1. Opens the shop's orders_export_2026-10.json in Downloads: 58 orders, each with a customer, a shipping address, line items, discounts and shipping nested inside
  2. Builds one row per order with order number, date, customer name, city, number of items and total
  3. Keeps each order's date as the shop's own local date, so an order at 10 pm on 31 October stays on 31 October
  4. Uses the shipping name for three guest orders that have no customer record, and keeps refunded and cancelled orders with their status
  5. Saves orders_2026-10.xlsx next to the export and checks that the item count and total ($4,513.00) match the JSON

The prompt.

My shop exported last month's orders as a JSON file, it's in my Downloads. Put it in Excel for me: one row per order with the order number, date, customer name, city, number of items and total.

Paste it into Stella and press Enter.

This is the exact prompt from the recording. If your files are somewhere else, say where.

Do it yourself.

  1. Windows: Get Data from JSON

    In Excel, Data, Get Data, From File, From JSON, and pick the file. Power Query opens with a List or Record: click Into Table, then expand the column holding the orders (the double-arrow button) to get one row per order.

  2. Expand what you need

    Expand nested records like customer and shipping_address and tick only the fields you want (first_name, last_name, city). Leave line_items unexpanded if you want one row per order, or expand it to get one row per item.

  3. Count items and fix dates

    For items per order, expand line_items into a separate query and Group By the order number with Sum of quantity, then merge it back. Set the date column's type to Text or Date, not Date/Time/Timezone, so late-evening orders don't move to the next day.

  4. On a Mac

    Recent Microsoft 365 builds of Excel for Mac have Data, Get Data with a JSON option and the same steps. Numbers can't open JSON. A converter website works but uploads your customers' names and addresses.

Where it stops.

  • This run made one row per order as asked, with no separate sheet of line items (an optional point in the answer key). Ask for one if you want item-level detail.
  • Very large exports (hundreds of MB) take longer, and Excel stops at 1,048,576 rows a sheet.
  • Stella reads the structure and some sample records, which go to the AI model you use; the conversion of the full file runs on your computer.
  • Recorded on Linux with Python's built-in JSON reader and a free spreadsheet library. A Mac or Windows PC works the same way.

Questions.

How do I convert JSON to CSV instead?

The same steps, then save as CSV; or ask Stella for a CSV. If leading zeros or dates matter, see convert Excel to CSV.

Why are my order dates a day off?

The times were converted to UTC or your own time zone. Keep the date as written in the export, which carries the shop's offset.

What about XML exports?

See convert XML to Excel, which works through an iPhone Health export.

Is Stella free for this?

Yes. Free with the ChatGPT or Claude plan you already have. Sign in with your ChatGPT plan, or use your Claude plan through Claude Code, and this task costs nothing extra. New accounts also get a small free trial of Stella’s own models.

Can I control what Stella changes on my computer?

Yes. Stella works on Windows, Mac and Linux with your own files and shows each step in the chat, so you can watch it and stop it at any point. Tell it what it may not do, as the prompts on these pages do (“don't delete anything without asking”). In the Downloads recording it deleted nothing until it was told to go ahead. It also refuses commands that would wipe a whole disk, your home folder or system folders.

Checked against these sources on 14 November 2026.

Stella