Free online
Convert JSON data to Excel .xlsx format—arrays and objects become rows and columns. Also supports CSV export and JSON Lines (NDJSON).
Need to automate at scale? This page is a free manual converter. For recurring pipelines or API-driven exports, use your own runtime (scripts, ETL, cloud jobs) or reach out via Contact if you have a partnership or integration question.
Download a standard .xlsx (Office Open XML) that opens in Microsoft Excel, Google Sheets, LibreOffice Calc, and other apps.
Move API responses and exports into rows and columns so you can filter, sort, pivot, and chart in familiar tools.
We generate .xlsx for Excel 2007 and later—not legacy binary .xls. You can also export CSV from the same tool.
Paste and upload are processed in your browser for the core export. If you use From URL, our server fetches that public link once to return JSON to your page—then the sheet is built locally.
Single workbook with one worksheet (Sheet1) containing all rows—simple to share and import elsewhere.
Column names come from flattened JSON paths (sorted alphabetically by default for stable columns).
Objects are flattened with dot notation (e.g. category.name) so nested data fits a grid.
Arrays of objects expand to multiple rows when that matches your structure; primitive arrays are merged into one cell with semicolons.
Your browser saves the file when you click Download Excel (.xlsx) or Download CSV.
No install for the core flow—use a recent Chrome, Edge, or Firefox.
Paste JSON, upload one .json or .txt file, or load from a public URL. Arrays of objects, single objects, nested API-style payloads, and JSON Lines are supported—see the home page mapping section for rules.
Click Download Excel (.xlsx) for XLSX. Optional: Download CSV with header, quoting, and line-ending options.
The file saves through your browser. Open it in Excel or any spreadsheet app—no account required for the core export.
XLSX (Excel Open XML) is the modern spreadsheet package format used since Excel 2007. Converting JSON to XLSX is a practical bridge between machine-oriented APIs and human-oriented reporting—whether you are a developer or a data analyst.
Sample inputs—the converter turns object keys into columns and array elements into rows when the structure matches our rules.
[
{
"name": "John Doe",
"age": 30,
"email": "john@example.com",
"city": "New York",
"salary": 75000
},
{
"name": "Jane Smith",
"age": 25,
"email": "jane@example.com",
"city": "London",
"salary": 68000
}
]Typical columns: name, age, email, city, salary—one row per object.
[
{
"id": 1,
"name": "Product A",
"price": 29.99,
"category": {
"name": "Electronics",
"id": 10
},
"tags": ["new", "popular"]
}
]Nested fields become dot paths (e.g. category.name). Primitive arrays like tags are often merged into one cell with semicolons—see the home FAQ for edge cases.