JSON to Excel converter

Paste JSON and download a real workbook, where numbers stay numbers and dates stay dates. The same table comes as a PDF or CSV too. Your JSON never leaves this page.

Open file

{
  "shop": "Quire Press Ltd.",
  "exported": "2026-10-01",
  "data": {
    "orders": [
      {
        "id": "A-1001",
        "date": "2026-09-02",
        "customer": {
          "name": "Folio & Sons",
          "country": "IE"
        },
        "status": "paid",
        "total": 1440,
        "items": [
          {
            "sku": "TS-12"
          },
          {
            "sku": "FG-4"
          },
          {
            "sku": "PC-1"
          }
        ]
      },
      {
        "id": "A-1002",
        "date": "2026-09-03",
        "customer": {
          "name": "Atelier Vink",
          "country": "NL"
        },
        "status": "paid",
        "total": 320.5,
        "items": [
          {
            "sku": "FG-4"
          }
        ]
      },
      {
        "id": "A-1003",
        "date": "2026-09-07",
        "customer": {
          "name": "Marlborough Books",
          "country": "IE"
        },
        "status": "refunded",
        "total": 89.99,
        "items": [
          {
            "sku": "PC-1"
          },
          {
            "sku": "PC-2"
          }
        ]
      },
      {
        "id": "A-1004",
        "date": "2026-09-11",
        "customer": {
          "name": "Atelier Vink",
          "country": "NL"
        },
        "status": "paid",
        "total": 1600,
        "items": [
          {
            "sku": "CB-250"
          }
        ]
      },
      {
        "id": "A-1005",
        "date": "2026-09-15",
        "customer": {
          "name": "Papierfabriek Deckle",
          "country": "NL"
        },
        "status": "pending",
        "total": 275,
        "items": [
          {
            "sku": "FS-250"
          },
          {
            "sku": "FS-251"
          }
        ]
      },
      {
        "id": "A-1006",
        "date": "2026-09-21",
        "customer": {
          "name": "Folio & Sons",
          "country": "IE"
        },
        "status": "paid",
        "total": 48,
        "items": [
          {
            "sku": "PC-1"
          }
        ]
      },
      {
        "id": "A-1007",
        "date": "2026-09-28",
        "customer": {
          "name": "Ledger & Co",
          "country": "GB"
        },
        "status": "paid",
        "total": 712.4,
        "items": [
          {
            "sku": "TS-6"
          },
          {
            "sku": "FG-2"
          }
        ]
      }
    ],
    "next": null
  }
}

Valid JSON · 2,441 charactersParsed and rendered on this page

7 rows from $.data.orders[*], with 7 columns.

TitleGroup rows byMoney in Totals row

Columns

Drag to reorder, or Alt and an arrow key. Select a column to rename it, change its type or hide it.

orders.xlsx

Orders

ID	Date	Customer name	Customer country	Status	Total	Items
A-1001	Sep 2, 2026	Folio & Sons	IE	paid	$1,440.00	3
A-1002	Sep 3, 2026	Atelier Vink	NL	paid	$320.50	1
A-1003	Sep 7, 2026	Marlborough Books	IE	refunded	$89.99	2
A-1004	Sep 11, 2026	Atelier Vink	NL	paid	$1,600.00	1
A-1005	Sep 15, 2026	Papierfabriek Deckle	NL	pending	$275.00	2
A-1006	Sep 21, 2026	Folio & Sons	IE	paid	$48.00	1
A-1007	Sep 28, 2026	Ledger & Co	GB	paid	$712.40	2
Total					$4,485.89

The workbook has the same columns, with numbers, money, and dates as real cells you can sort and sum.

Run the same conversion from your own code

Every export on this page is a quario definition: the report.json in the panel. It names the rows and the columns, and says how to present each value. Store it with your code and render it with your data. You get the same workbook, PDF, or CSV from a server, a worker, or the browser.

{
  "data": "$.data.orders[*]",
  "style": {
    "family": "sans",
    "size": 9
  },
  "header": [
    {
      "type": "text",
      "value": "Orders",
      "style": {
        "family": "serif",
        "size": 15,
        "bold": true,
        "spaceAfter": 12
      }
    }
  ],
  "detail": {
    "columns": [
      {
        "header": "ID",
        "value": "{{ @.id }}"
      },
      {
        "header": "Date",
        "value": "{{ @.date }}",
        "style": {
          "format": "date"
        }
      },
      {
        "header": "Customer name",
        "value": "{{ @.customer.name }}"
      },
      {
        "header": "Customer country",
        "value": "{{ @.customer.country }}"
      },
      {
        "header": "Status",
        "value": "{{ @.status }}"
      },
      {
        "header": {
          "value": "Total",
          "style": {
            "align": "right"
          }
        },
        "value": "{{ round(@.total, 2) }}",
        "style": {
          "align": "right",
          "format": "currency"
        }
      },
      {
        "header": {
          "value": "Items",
          "style": {
            "align": "right"
          }
        },
        "value": "{{ count(@.items) }}",
        "style": {
          "align": "right"
        }
      }
    ],
    "header": {
      "style": {
        "family": "mono",
        "size": 7,
        "uppercase": true,
        "color": "#6b7a82",
        "paddingBottom": 3,
        "borderBottomWidth": 0.5,
        "borderBottomStyle": "solid",
        "borderBottomColor": "#cfd8dd"
      }
    },
    "row": {
      "style": {
        "paddingTop": 2,
        "paddingBottom": 2,
        "borderBottomWidth": 0.25,
        "borderBottomStyle": "solid",
        "borderBottomColor": "#e6ecef"
      }
    },
    "total": {
      "style": {
        "bold": true,
        "align": "right",
        "paddingTop": 5,
        "borderTopWidth": 0.75,
        "borderTopStyle": "solid",
        "borderTopColor": "#1e1f22"
      },
      "rows": [
        {
          "cells": [
            {
              "value": "Total",
              "span": 5
            },
            {
              "value": "{{ round($.total0, 2) }}",
              "style": {
                "format": "currency"
              }
            },
            {
              "value": ""
            }
          ]
        }
      ]
    }
  },
  "aggregates": {
    "total0": "sum:[email protected]"
  }
}

Questions

Is my JSON uploaded anywhere?: No. This page reads the text you paste or the file you open, and quario renders the preview and every download right here. Nothing you paste reaches a server.
What shape does the JSON need?: A list of objects, either at the top level or anywhere inside. When there are several lists, you choose which one becomes the rows. A nested object becomes columns such as customer.name, and a list inside a row becomes a count.
Do numbers and dates still work in Excel?: Yes. The workbook stores numbers, money, and dates as typed cells, so you can sort, filter, and sum them. It never writes a value as a formula.
Is there a size limit?: The preview shows the first 200 rows. Downloads include every row, up to what your browser can hold in memory.
Is it free?: Yes, with no sign-up. To generate these files from your own application, quario is free to evaluate, and a license covers each production deployment. See pricing.