← DrezTek Home
DrezTek Spreadsheet v1.0 · Stable

DrezTek Spreadsheet

A portable JSON format any AI assistant can generate so a person can import a real workbook — sheets, rows, formulas, formatting — into Kanso Sheets.

Status — Stable Imports into — Kanso Sheets Generated by — Any AI assistant with file output

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.

Two ways to use this page: hand an agent this page's URL directly, or use the Copy button in Section 5 to grab a self-contained prompt — useful for agents (like Claude) that won't treat a URL as an authoritative instruction on their own.
Scope: this is an interchange format, not a full spreadsheet-app export. It covers values, formulas, and the handful of formatting properties (bold, italic, alignment, background color, number format) needed for a clean first import. Kanso-specific features — dropdown cells, checkboxes, images, merged cells, pinned aggregate pills — are Kanso's own and aren't part of this spec; a sheet imported from this format is a normal Kanso sheet you can extend with those afterward.

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

FieldRequiredDescription
versionyes"1.0"
kindyesAlways "dreztek-spreadsheet"
exportedAtnoISO-8601 timestamp
workbookyesWorkbook metadata (see below)
sheetsyesArray of sheets, at least one

workbook

FieldRequiredDescription
titleyesShort display name for the workbook
descriptionnoOne-line description, importers may ignore

Each sheet

FieldRequiredDescription
titleyesTab name shown in Kanso
frozenRowsnoNumber of top rows to freeze; default 0
columnWidthsnoSparse map of zero-based column index (string key) → pixel width
rowsyesArray 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" } }
FieldRequiredDescription
valueyes (in object form)String, number, boolean, or null. A boolean becomes a Kanso checkbox cell. A string beginning with = is a formula.
formatnoOptional 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).

SupportedExample
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

FieldValues
boldboolean
italicboolean
alignleft | center | right
backgroundColorAny CSS color string, e.g. #fef3c7
numberFormatdefault | 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.

Kanso import: Sheets → toolbar → Import. Kanso export: Sheets → toolbar → Export (choose DrezTek Spreadsheet JSON, or CSV for a single sheet).