Excel to JSON

POST /api/xlsx-to-json

Read an Excel sheet (.xlsx or .xls) into a JSON array of objects. Pick a sheet by name or index. Header row maps to object keys.

Reads an Excel workbook (.xlsx or legacy .xls) and returns one sheet as a JSON array of objects. The first row is the header; each subsequent row becomes an object keyed by header name. Options: - `sheet` (default 0): which sheet to read (0-based index or sheet name). - `useHeader` (default true): treat the first row as the header. With `false`, rows become arrays of cell values. - `coerceTypes` (default true): emit numbers and booleans as their JSON-typed values; with `false`, every cell is a string.

Inputs

Name	Type	Default	Description
workbook*	file	—	Excel workbook bytes (XLSX, XLSB, XLS, or ODS).
sheet	string	—	Sheet name (case-sensitive) or 1-indexed sheet number as a string. Defaults to the first sheet.
header	enum (auto \| none)	"auto"	`auto` (default) treats the first row as headers and emits {col: value} objects; `none` emits every row as a plain array.
rawValues	boolean	false	When true, return raw cell values; when false (default), dates are formatted as ISO strings.

Response

Modes: json. Cache: yes (24h TTL).

Code samples

Built from the first-sheet example.

# Download or substitute the example input:
#   curl -O https://xtract.bot/examples/excel-to-csv/sample.xlsx
WORKBOOK=$(base64 -w0 < sample.xlsx)

curl -X POST https://api.xtract.bot/api/xlsx-to-json \
  -H "Content-Type: application/json" \
  -H "Accept: application/json" \
  -H "X-Account-Id: $XTRACT_ACCOUNT_ID" \
  -H "X-Api-Key: $XTRACT_API_KEY" \
  -d '{
  "workbook": "'"$WORKBOOK"'"
}'