Skip to content
Fylane
Get API key

Free tools › Documents

JSON to Excel

Keys become the header row; every object a row; nested values kept as text.

More free conversions, where you upload. The Fylane extension does the same work inside any upload form, on its own free share every day.About the extension

How to convert JSON to Excel

  1. Drop the JSON.
  2. Nothing to choose.
  3. Press Convert and download the XLSX.

What happens to your file

The JSON is read on Fylane’s servers and written as a real XLSX — no app in the loop. A list of objects gives a header row of every key in the order first seen, then one row per object with blanks where a key is missing. A list of lists is written row for row. An object whose values are lists becomes one sheet per key. Numbers stay numbers; true, false and null become that text; a nested object or list is written as its JSON in one cell.

Fifty thousand cells and twenty sheets at most. The file is refused, with the reason, when it is not JSON or not a table shape.

Questions

Why is my nested object one cell of JSON?

Because a cell cannot hold a tree, and flattening it into columns is a guess that is right for some files and wrong for the rest. Flatten it in your script the way you want, then convert.

Do this in code

curl -X POST https://api.fylane.dev/v1/jobs \
  -H "Authorization: Bearer $FYLANE_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "file_id": "<file id>",
    "operation": "sheet.create",
    "options": {}
  }'

The same operation, sheet.create — A workbook from JSON: a list of objects (keys as the header) or of lists, or an object of sheets — 50 000 cells at most. Upload first with the quickstart; every option is on the operations page. 500 free credits a month, then $5 per thousand.