01 Purpose & scope
Why this exists, and what it does and doesn't cover.
Kanso's Sheets tool can hold real workbooks — budgets, trackers, material lists, schedules — but until now the only way in was typing it by hand. This format lets an AI assistant (ChatGPT, Claude, Gemini, or anything else that can write a file) turn an attachment, a table, or plain-language context into a downloadable JSON file that imports straight into a Kanso sheet, formulas and formatting included.
The machine-readable kind field is always the literal string "dreztek-spreadsheet", regardless of what a person calls it out loud when asking an agent for one.
02 Structure
The minimal shape every file needs.
{
"version": "1.0",
"kind": "dreztek-spreadsheet",
"workbook": { "title": "Job materials budget" },
"sheets": [
{
"title": "Materials",
"frozenRows": 1,
"rows": [
["Item", "Unit cost", "Qty", "Total"],
["Lumber", 240.5, 12, "=B2*C2"],
["Nails (box)", 14.25, 3, "=B3*C3"]
]
}
]
}
Save as a .json file and import via Sheets → toolbar → Import in Kanso. Each entry in sheets becomes one Kanso sheet tab; each entry in rows becomes one grid row, left-to-right in column order (row 0 → row A1, B1, C1…).
03 Field reference
Every field an importer recognizes, root through cell.
Root
| Field | Required | Description |
|---|---|---|
| version | yes | "1.0" |
| kind | yes | Always "dreztek-spreadsheet" |
| exportedAt | no | ISO-8601 timestamp |
| workbook | yes | Workbook metadata (see below) |
| sheets | yes | Array of sheets, at least one |
workbook
| Field | Required | Description |
|---|---|---|
| title | yes | Short display name for the workbook |
| description | no | One-line description, importers may ignore |
Each sheet
| Field | Required | Description |
|---|---|---|
| title | yes | Tab name shown in Kanso |
| frozenRows | no | Number of top rows to freeze; default 0 |
| columnWidths | no | Sparse map of zero-based column index (string key) → pixel width |
| rows | yes | Array of rows; each row is an array of cells (see below) |
Each cell
A cell is either a raw value — a string, number, boolean, or null — or a cell object when formatting is needed:
{ "value": 240.5, "format": { "numberFormat": "currency" } }
| Field | Required | Description |
|---|---|---|
| value | yes (in object form) | String, number, boolean, or null. A boolean becomes a Kanso checkbox cell. A string beginning with = is a formula. |
| format | no | Optional formatting object — see Section 4 |
Rows must be rectangular — pad shorter rows with empty string cells ("") so every row in a sheet has the same length. Never add a $schema field to an output file.
04 Formulas & formatting
What Kanso's formula engine actually supports, so generated formulas don't render #ERROR!.
Formulas
Formulas use standard A1 notation (column letter + row number, both 1-based — the same convention as Excel or Google Sheets: cell A1 is row 0, column 0 of the rows array).
| Supported | Example |
|---|---|
| Arithmetic | =B2*C2, =(B2+B3)/2 |
| SUM | =SUM(D2:D9) |
| AVERAGE | =AVERAGE(D2:D9) |
| SUMIF | =SUMIF(A2:A9,"Lumber",D2:D9) |
| COUNTIF | =COUNTIF(A2:A9,"Lumber") |
| COUNTA | =COUNTA(A2:A9) |
| IF / AND / OR / NOT | =IF(C2>10,"bulk","retail") |
No other functions are supported — anything else renders as #ERROR! in Kanso. Stick to this list.
format
| Field | Values |
|---|---|
| bold | boolean |
| italic | boolean |
| align | left | center | right |
| backgroundColor | Any CSS color string, e.g. #fef3c7 |
| numberFormat | default | currency | percentage | decimal |
For percentage, store the human percentage number (20 for 20%), not the fraction (0.2) — Kanso displays it as a percentage and divides by 100 internally for formula math.
05 Ask an agent
Copy this into ChatGPT, Claude, Gemini, or any assistant, alongside whatever data you want turned into a spreadsheet.
Create a downloadable JSON file I can import into Kanso (Sheets → Import).
Deliver a .json file attachment — do not only paste JSON in the chat.
Filename: dreztek-{workbook-name}-{date}.json
Required structure (DrezTek Spreadsheet v1.0):
{
"version": "1.0",
"kind": "dreztek-spreadsheet",
"workbook": { "title": "Short workbook name" },
"sheets": [
{
"title": "Sheet1",
"rows": [
["Column A header", "Column B header"],
["value", 123]
]
}
]
}
Rules:
- A cell is either a raw value (string, number, boolean, null) or an object
{ "value": ..., "format": { ... } } when formatting is needed.
- A string value starting with "=" is a formula in A1 notation.
- Supported formulas ONLY: arithmetic (+ - * /), SUM, AVERAGE, SUMIF, COUNTIF,
COUNTA, IF, AND, OR, NOT. Do not invent other functions.
- format fields: bold, italic, align (left|center|right), backgroundColor,
numberFormat (default|currency|percentage|decimal).
- For numberFormat "percentage", store the percentage number (20), not the
fraction (0.2).
- Every row in a sheet must be the same length — pad short rows with "".
- Use the first row for column headers when the data has an obvious header
row, and bold it.
- Prefer formulas over pre-computed totals when the source data implies a
calculation (e.g. line-item totals, a grand total row).
- Split genuinely distinct tables into separate sheets rather than stacking
them in one grid.
- Do not add a $schema field.
- Derive rows and sheets from my attachment or context.
Reference example: https://naroid.com/schemas/dreztek-spreadsheet-v1.example.json
06 Implementation & links
The hosted files behind this page.
| File | URL |
|---|---|
| JSON Schema (Naro) | naroid.com/schemas/dreztek-spreadsheet-v1.schema.json |
| Example (Naro) | naroid.com/schemas/dreztek-spreadsheet-v1.example.json |
| Agent guide (machine-readable) | naroid.com/agent/spreadsheet.json |
Kanso import: Sheets → toolbar → Import. Kanso export: Sheets → toolbar → Export (choose DrezTek Spreadsheet JSON, or CSV for a single sheet).