JSON to Excel (URL)
Convert a remote JSON array to a downloadable Excel (.xlsx) file.
GET
1 credit
/v1/convert/json-to-excel-file
curl -OJ "https://convert.toolkitapi.io/v1/convert/json-to-excel-file?url=https://toolkitapi.io/data.json"
import httpx
resp = httpx.get(
"https://convert.toolkitapi.io/v1/convert/json-to-excel-file?url=https://toolkitapi.io/data.json",
)
print(resp.json())const resp = await fetch("https://convert.toolkitapi.io/v1/convert/json-to-excel-file?url=https://toolkitapi.io/data.json", {
});
const data = await resp.json();
console.log(data);# See curl example
Response
200 OK
Binary XLSX file download (Content-Disposition: attachment; filename="output.xlsx")Description
Convert a remote JSON array to a downloadable Excel (.xlsx) file.
How to Use
1
1. GET this endpoint with the JSON URL in `url`.
2
2. Optionally pass `sheet_name` and `filename`.
3
3. Save the streamed `.xlsx` to disk.
About This Tool
Fetches a JSON array of objects from a public URL and streams back an `.xlsx` workbook as a file download. Object keys become column headers; nested objects are flattened with dot-notation.
Use this endpoint for direct browser downloads or shell pipelines where a JSON payload is impractical.
Why Use This Tool
- One-click exports — "Download as Excel" buttons backed by a JSON feed
- Scheduled reports — Cron jobs that turn API feeds into spreadsheets
- Browser downloads — Zero-JS integrations via `<a href>`
- Pipeline artifacts — Produce workbook artifacts inside CI
Frequently Asked Questions
Must the JSON be an array?
Yes — the top-level value must be an array of objects. Single objects and primitive arrays are rejected.
Are nested objects supported?
Yes. Nested objects are flattened using dot-notation keys; arrays are JSON-stringified into a single cell.
How are mismatched keys handled?
The union of all object keys forms the column set. Missing values render as empty cells.
Start using JSON to Excel (URL) now
Get your free API key and make your first request in under a minute.