Excel to JSON

Excel to JSON is an API that converts a sheet from an .xlsx file into an array of JSON objects, using the first row as field names.

How it works

You send the .xlsx file (binary, or base64 inside a JSON body) and get the array back. If the workbook has several sheets, it uses the first one by default; pick another with sheet (by name or number, starting at 0).

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/excel-to-json
Send Headers: x-api-key = your key
Send Body: binary file (in n8n: "n8n Binary File")

Options

Option	Default	What it does
`sheet`	the first one	Name or number (0, 1, 2…) of the sheet to read.
`header`	`true`	First row as field names. With `false`, rows as arrays.

API overview

Endpoint: POST https://api.cofferdock.com/excel-to-json
Auth: x-api-key: YOUR_KEY.
Input: raw .xlsx bytes, or JSON { "file": "<base64>" }.
Engine: exceljs. Formulas come through as their calculated result, not the formula itself.
Limits: 30 requests/min per IP. Up to 20MB. 1 call = 1 credit.

Example

curl -X POST "https://api.cofferdock.com/excel-to-json" \
  -H "x-api-key: YOUR_KEY" \
  -H "Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" \
  --data-binary @data.xlsx

Response

{ "success": true, "data": [{"name":"Ana","age":30}],
    "meta": { "sheet": "Sheet1", "sheets": ["Sheet1"], "rows": 1, "used": 12, "remaining": 488 } }

What you get back

data (the array) and meta.sheets (the names of every sheet in the workbook, in case you want a different one).