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.Add to Chrome

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 it once, not on every form

Fixing a file here means downloading it and going back to the form. The Fylane extension does this work inside the form instead, on the file you already have.

And it keeps the result. The next application that asks for a résumé, a cover letter and a photo fills all three from one tap, each one refitted to what that site accepts.

Your files stay in the browser, encrypted, on your machine. Nothing is uploaded to keep them and nothing is sent anywhere to fill a form.

Filmed from the extension: three upload fields on a job application, filled from one tap.

Add to Chrome — freeWhat it does

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.