Convert API JSON response to Excel

Value kind	in JSON	in EXCEL
Int	`1234 (number)`	`1234 (a real numeric cell)`
Bigint	`9007199254740993`	`9007199254740993 (exact only while the cell stays text)`
Decimal	`1234.56 (number)`	`1234.56 (numeric cell, format controls the displayed decimals)`
Float	`1.234e10 (number)`	`1.234E+10 (numeric cell)`
Text	`"text" (string)`	`text cell; leading zeros survive only if the column is text`
Long text	`"multi-line\ntext" (escaped newline inside a string)`	`text cell; wraps inside the cell rather than the row`
Date	`"2026-09-18" (string)`	`a serial number plus a date cell format`
Datetime	`"2026-09-18T14:30:00Z" (string)`	`a serial number plus a date-time cell format`
Binary	`"base64:..." (string)`	`not representable as data`
Boolean	`true / false (boolean)`	`TRUE / FALSE (a real boolean cell)`
JSON	`nested object or array, kept as structure`	`a text cell; the quotes are part of the value`

Both JSON and EXCEL are file formats, so what differs below is how each one chooses to represent a value.

Property	in JSON	in EXCEL
identifiers	`Double quotes; backslash escapes`	`Not applicable; a cell holds exactly one value`
dates	`No date type: dates arrive as strings and the reader must p...`	`Stored as a serial number; only the cell format makes it lo...`
binary	`Not supported natively - base64 inside a string`	`Only as text or an embedded object, not as a data column`
separator	`Braces and commas`	`Cells, not delimiters`
encoding	`UTF-8 by definition`	`UTF-8 internally, declared in the package`
typing	`string, number, boolean, null, object, array - no date type`	`Real cell types: text, number, date, boolean, error`
shape	`Nested objects and arrays`	`Multiple sheets, each a flat grid`
ceiling	`Whole document is usually parsed into memory`	`1,048,576 rows x 16,384 columns per sheet; 255 sheets per w...`

Data File Converter without the manual work

For batch jobs, large files and scheduling use the Data File Converter converter — an offline desktop app for Windows, Linux and macOS. Free trial.