JSON to Excel

JSON to Excel is an API that converts an array of JSON objects into a real .xlsx file (opens directly in Excel, Google Sheets or Numbers), with columns taken from every object's keys.

How it works

You send data (an array of objects) and get the .xlsx file back. If one object has a field others don't, that column still shows up, blank on the rows where it's missing.

All you need

Your API key. Create it in your dashboard with "+ Create key".
In your automation platform, an "HTTP Request" step (n8n, Make, Zapier, Pipedream…).

How to use it in n8n

Method: POST · URL: https://api.cofferdock.com/json-to-excel
Send Headers: x-api-key = your key, Content-Type = application/json
Send Body (JSON): { "data": [{"name":"Ana","age":30}] }
In Options → Response → Response Format: choose File

Options

Option	Default	What it does
`data`	-	Required. Array of objects.
`sheet_name`	`Sheet1`	Sheet name (max 31 characters, Excel's own limit).
`header`	`true`	Include the column-name row.

API overview

Endpoint: POST https://api.cofferdock.com/json-to-excel
Auth: x-api-key: YOUR_KEY.
Input: JSON ONLY, { "data": [...] }.
Engine: exceljs.
Limits: 30 requests/min per IP. Up to 100,000 rows. 1 call = 1 credit.

Example

curl -X POST "https://api.cofferdock.com/json-to-excel" \
  -H "x-api-key: YOUR_KEY" -H "Content-Type: application/json" \
  -d '{"data":[{"name":"Ana","age":30}],"output":"xlsx"}' \
  --output data.xlsx

Response

{ "success": true, "xlsx": "UEsDBBQA...",
    "mime_type": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
    "meta": { "rows": 1, "columns": 2, "used": 12, "remaining": 488 } }

What you get back

By default (JSON): xlsx as base64. Add output=xlsx for the raw binary, or output=url for a temporary link.