Preparing Your Sheet
How BlazeSheets maps spreadsheet rows into JSON records.
BlazeSheets uses the first row of a worksheet as field names. Every row below becomes a JSON object keyed by those headers.
Header rules
- Put unique, stable column names in row 1.
- Prefer simple identifiers (
name,email,score) — they become JSON keys. - Empty header cells are skipped or produce awkward keys; fill every column you intend to expose.
Data rows
There are no strict type limits. Numbers, text, dates, booleans, and empty cells are all accepted. Values are returned as strings by default unless you use castNumbers on read.
Row numbers
Public update and delete endpoints address rows by a 1-based data row number, counting only data rows after the header.
| Spreadsheet row | Meaning | API rowNumber |
|---|---|---|
| 1 | Header | — |
| 2 | First data row | 1 |
| 3 | Second data row | 2 |
Worksheets
A workbook can have multiple tabs. Select a tab at request time with $sheet. When omitted, BlazeSheets uses the first worksheet.