Convert JSON payloads into Excel workbooks

The only required field is rows. It can be an array of objects or a single object. If you do not provide a filename, the generated workbook will use an automatic UUID filename.

{
  "rows": [
    {
      "order_id": "ORD-1001",
      "customer": "Acme Operations",
      "total": 149.99
    },
    {
      "order_id": "ORD-1002",
      "customer": "Northwind Analytics",
      "total": 89.5
    }
  ]
}

A successful request returns a JSON object containing a pre-signed download URL. The URL is valid for 5 minutes. Set csv to true to generate a CSV file URL instead of an XLSX file URL. Set rawFile to true to return the generated file directly.

{
  "url": "https://s3.eu-west-2.amazonaws.com/json-to-excel-rapid-api/dev/7f30b789-3e6a-4b10-aa5a-68b8c6fcb762.xlsx?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIA45OIHTVPVKWWDIRC%2F20240901%2Feu-west-2%2Fs3%2Faws4_request&X-Amz-Date=20240901T175355Z&X-Amz-Expires=300&X-Amz-SignedHeaders=host&X-Amz-Signature=9b4ebaf3ba0158f3c5182e795b8455fe5ca680bcdfe5e76d66a94853ce08e3e0"
}

In browser code, redirecting to the returned URL starts the workbook download:

window.location = response.url;

Raw file responses use Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet for XLSX files or Content-Type: text/csv; charset=utf-8 for CSV files, plus Content-Disposition: attachment. Add csv to a raw file request to return CSV bytes instead of XLSX bytes.

{
  "rows": [
    {
      "order_id": "ORD-1001",
      "customer": "Acme Operations",
      "total": 149.99
    }
  ],
  "rawFile": true
}

{
  "rows": [
    {
      "order_id": "ORD-1001",
      "customer": "Acme Operations",
      "total": 149.99
    }
  ],
  "rawFile": true,
  "csv": true
}

Nested structures are supported. Nested object fields become path-like columns, and arrays are flattened so deeply nested API responses can still be exported. Object paths use dot notation, such as customer.name. Array paths put the index before the child field, such as items.0.sku.

{
  "rows": [
    {
      "id": "03e02566-cea6-4c24-8cef-a084e30d99a2",
      "object": {
        "nested_": {
          "id": "c9ff2782-38c3-4ba2-a9e9-2a6d60090038",
          "deeply_nested_object": {
            "id": "6e750787-7105-42d1-8be6-82e7f980ef71"
          }
        }
      },
      "array": [
        {
          "id": "3aa0bf70-001c-4f21-8aa1-b4a7de5f5a31",
          "deeply_nested_array_ids": [
            "0f9fdb29-0821-4065-9b99-b6b89407e29c"
          ]
        }
      ]
    }
  ]
}

Explicitly define column order. Use dot notation for nested fields. For arrays, place the index before the child field: items.0.sku. Values are zero-based, so 0 is the first column. Negative values count from the end: -1 is the last column and -2 is the second-last column.

{
  "order": {
     "nested_object.id": 0,
     "items.0.sku": 1,
     "name": 2,
     "role": -2,
     "age": -1
  }
}

{
  "filename": "orders",
  "order": {
    "order_id": 0,
    "customer.name": 1,
    "items.0.sku": 2,
    "total": -1
  },
  "rows": [
    {
      "order_id": "ORD-1001",
      "customer": {
        "name": "Acme Operations"
      },
      "items": [
        {
          "sku": "API-EXPORT"
        }
      ],
      "total": 149.99
    }
  ]
}

{
  "filename": "orders"
}

{
  "filename": "orders",
  "rows": [
    {
      "order_id": "ORD-1001",
      "customer": "Acme Operations",
      "total": 149.99
    }
  ]
}

{
  "sheetname": "January"
}

{
  "rawFile": true,
  "filename": "orders",
  "rows": [
    {
      "order_id": "ORD-1001",
      "customer": "Acme Operations",
      "total": 149.99
    }
  ]
}

{
  "csv": true,
  "filename": "orders",
  "rows": [
    {
      "order_id": "ORD-1001",
      "customer": "Acme Operations",
      "total": 149.99
    }
  ]
}

Set multiTable to true to create an XLSX workbook with separate sheets for nested object and array relationships instead of flattening everything into one row. Each sheet includes a generated internal _id column, which is hidden in the workbook by default. Relationship sheets also include _parent, which links each child row back to its parent row.

The visible _parent link text uses the parent row's own id when available, then a localized name field, then title, and finally the generated internal ID. Supported name fields are name, nombre, nom, nome, naam, namn, navn, nazwa, isim, and nazev.

Link-only wrapper objects are skipped. For example, charges: { data: [...] } creates a charges.data sheet and links those rows directly to the nearest parent row with data, rather than creating an empty charges sheet.

multiTable is only available for XLSX output and cannot be combined with csv.

{
  "multiTable": true,
  "filename": "users",
  "sheetname": "Users",
  "rows": [
    {
      "user": {
        "count": 2,
        "ref": "/ref/sales",
        "names": [
          { "id": 1, "name": "chris" },
          { "id": 2, "name": "adam" }
        ]
      }
    }
  ]
}

curl

curl -X POST "https://json-to-excel.com/" \
  -H "Content-Type: application/json" \
  -H "X-API-Key: 5b33af5fc46c4c18b738e000f8507174" \
  -d '{
    "filename": "orders",
    "sheetname": "January",
    "rows": [
      {
        "order_id": "ORD-1001",
        "customer": "Acme Operations",
        "total": 149.99
      }
    ]
  }'

JavaScript fetch

const response = await fetch("https://json-to-excel.com/", {
  method: "POST",
  headers: {
    "X-API-Key": "5b33af5fc46c4c18b738e000f8507174",
    "Content-Type": "application/json",
  },
  body: JSON.stringify({
    filename: "orders",
    rows: [
      {
        order_id: "ORD-1001",
        customer: "Acme Operations",
        total: 149.99,
      },
    ],
  }),
});

const data = await response.json();

if (!response.ok) {
  throw new Error(data.error || "Conversion failed");
}

window.location = data.url;