Example request and result
You send
curl -X POST …/v1/convert \
-H "x-api-key: $KEY" \
-d '{"data": [
{"name": "Alice", "plan": "Pro",
"address": {"city": "Austin"}, "seats": 12},
{"name": "Bob", "plan": "Free",
"address": {"city": "Leeds"}, "seats": 3}
]}' -o team.xlsx
You get team.xlsx
| A | B | C | D | |
| 1 | Name | Plan | Address.City | Seats |
|---|---|---|---|---|
| 2 | Alice | Pro | Austin | 12 |
| 3 | Bob | Free | Leeds | 3 |
Nested address.city became its own column. No spreadsheet code on your side.
- Both directions, one key. JSON or CSV to Excel, and Excel or CSV back to JSON.
- Nested data, handled. Objects become dot-notation columns, with the same rules as the web tool.
- Nothing stored. Each request runs in AWS Lambda and ends there. We don't keep your data.
Get your API key
Step 1: create your free account and get your key. Step 2: add credits on the pricing page. One balance for the website and the API.
We use it for your account and sign-in links. Your key appears right here, once, so save it.
Account only
$0
Get your key now, add credits later.
- Your API key and email sign-in
- Preview the converter example free
- No credits included: pick a pack next
Credits
From $5
Prepaid packs, no subscription.
- 1 credit per API request
- Shared with the website
- Any pack unlocks no-code webhooks
No subscription: you pay once, and credits never expire. On the website, loading your own JSON, each download or copy, and each answered question use 1 credit; through the API, each request does. A request that fails on our side doesn't use a credit. When you run out, the API answers 402 Payment Required with a link to buy more, and every successful response says how many credits are left in the X-Credits-Remaining header.
Already have a key? Sign in to see it and your credit balance. Buying more credits with the same email adds them to the same key.
What people build with it
- Export buttons. Add "Download as Excel" to a dashboard or admin panel without writing spreadsheet code.
- Automated reports. With no-code webhooks (unlocked by any credit pack), a Zap or n8n flow posts the day's data and a formatted Excel file arrives by email.
- Spreadsheet imports. Turn the Excel or CSV files your users upload into JSON your app can read.
API reference
Two endpoints, one key. Send your key in the x-api-key header. Each successful request uses 1 credit from the same balance; X-Credits-Remaining on the response says how many are left, and 402 means you're out.
Convert JSON or CSV to Excel
POST https://veqix61rpf.execute-api.us-east-1.amazonaws.com/dev/v1/convert
x-api-key: <your API key>
Content-Type: application/json
{"data": [{"name": "Alice", "age": 30}, {"name": "Bob", "age": 25}]}
Returns a binary .xlsx file (same output as the web converter, including headers and formatting). A single JSON object is automatically wrapped in an array.
Example
curl -X POST https://veqix61rpf.execute-api.us-east-1.amazonaws.com/dev/v1/convert \
-H "x-api-key: YOUR_API_KEY" \
-H "Content-Type: application/json" \
-d '{"data": [{"name": "Alice", "age": 30}]}' \
-o converted.xlsx
Convert Excel or CSV to JSON
The reverse direction: same key, same credits (1 per file), no separate signup. The file field is base64-encoded for xlsx, or raw text for csv.
POST https://veqix61rpf.execute-api.us-east-1.amazonaws.com/dev/v1/excel-to-json
x-api-key: <your API key>
Content-Type: application/json
{"format": "xlsx", "file": "<base64-encoded .xlsx contents>"}
Returns {"data": [...]}: the header row becomes object keys, one JSON object per following row.
Example
curl -X POST https://veqix61rpf.execute-api.us-east-1.amazonaws.com/dev/v1/excel-to-json \
-H "x-api-key: YOUR_API_KEY" \
-H "Content-Type: application/json" \
-d "{\"format\": \"xlsx\", \"file\": \"$(base64 -w0 report.xlsx)\"}"
No-code webhooks with Zapier
Zapier has no built-in step for turning JSON into a spreadsheet. Once you've bought any credit pack, your account gets inbound webhook URLs that fill the gap with zero code: Zapier posts JSON, JSON Support converts it and emails back a formatted .xlsx file. Each conversion uses 1 credit.
- Create a webhook. On the account page, create a webhook and set the email address that should receive the converted file.
- Add a "Webhooks by Zapier: POST" action. In your Zap, use Zapier's built-in Webhooks action, set the method to
POST, and paste in your webhook URL. - Set the payload. Configure the request body as
{"data": [...]}, an array of objects built from your Zap's trigger data. - Turn it on. Every time the Zap fires, an Excel file lands in the destination inbox.
It works the same way with any no-code tool that can send an outbound webhook, such as Make, n8n or IFTTT. For a full walkthrough, see how to convert JSON to Excel in Zapier.