API Reference

Structured Sheets

Copy Markdown

Open in Claude

Open in ChatGPT

Open in Cursor

---

Copy Markdown

View as Markdown

Tables

Convert uploaded spreadsheets into structured data. Creates relational tables from messy spreadsheet data.

List tables in structured sheet

client.StructuredSheets.Tables.List(ctx, structuredSheetID, query) (*CursorIDPage[TableResponse], error)

GET/v1/structured-sheets/{structured_sheet_id}/tables

Retrieve a table

client.StructuredSheets.Tables.Get(ctx, tableID, query) (*TableResponse, error)

GET/v1/structured-sheets/{structured_sheet_id}/tables/{table_id}

Download table data

client.StructuredSheets.Tables.Download(ctx, tableID, params) (*Response, error)

GET/v1/structured-sheets/{structured_sheet_id}/tables/{table_id}/download

ModelsExpand Collapse

type TableResponse struct{…}

Response representing a table extracted from a structured sheet.

This is returned from GET (retrieve) and list table endpoints. Table names use a composite format: {normalized_sheet_name}__{table_name}.

ID string

The unique identifier for this table.

CreatedAt Time

The timestamp when this table was created.

formatdate-time

Name string

Composite table name: {normalized_sheet_name}__{table_name}. Uses lowercase snake_case. Aggregation tables end with '__aggregations'. Two special metadata tables exist per structured sheet: '__deeptable_workbook_metadata' (workbook provenance info) and '__deeptable_table_overview' (summary of all tables). Example: 'staffing__head_count' or 'staffing__head_count__aggregations'.

maxLength255

Object Table

The object type, which is always 'table'.

SheetName string

The original Excel sheet name this table came from.

maxLength100

StructuredSheetID string

The ID of the structured sheet this table belongs to.

Type TableResponseType

The type of table (relational, aggregation, tableless, or metadata).

One of the following:

const TableResponseTypeRelational TableResponseType = "relational"

const TableResponseTypeAggregation TableResponseType = "aggregation"

const TableResponseTypeTableless TableResponseType = "tableless"

const TableResponseTypeMetadata TableResponseType = "metadata"