Spreadsheet Processing

Use spreadsheet settings for Excel workbooks where the visual workbook structure matters. This is especially useful for financial models, loss runs, claims exports, underwriting workbooks, and operational reports exported from ERP or BI systems. Platform companion sample: Complex Table Document

Spreadsheet extraction in the Platform showing workbook tabs and markdown output

The most important settings are:

Setting	Use when
`include_hidden_rows`	Hidden rows contain data your workflow must audit.
`include_hidden_cols`	Hidden columns contain calculations, IDs, or source fields.
`include_hidden_sheets`	The workbook uses hidden support tabs that should be parsed.
`use_raw_values`	Downstream systems need exact numeric values instead of display-rounded text.
`only_data_rows`	The workbook has many empty trailing rows because of formatting or prior exports.
`only_data_cols`	The workbook has many empty trailing columns for the same reason.
`include_cell_formatting`	Table cells need captured formatting or formula metadata.
`cell_data_mode`	Use `inline` for full arrays or `external` for per-table JSONL artifacts on very large workbooks.

{
  "file_url": "https://your-storage.example.com/acme-financial-review.xlsx",
  "spreadsheet": {
    "only_data_rows": true,
    "only_data_cols": true,
    "use_raw_values": true
  }
}

With cell_data_mode: "external", each bounding_boxes.Tables[].cell_data value is an object instead of an array:

{
  "is_url": true,
  "url": "https://api.runpulse.com/results/JOB_ID/cell-data/tbl-1.jsonl",
  "format": "jsonl",
  "count": 18420,
  "filename": "tbl-1.jsonl"
}

Fetch url with the same x-api-key used for extraction. Each JSONL line is one complete cell object. Here are compact previews from the ACME financial review workbook used for this section:

Executive summary sheet preview from the ACME workbook

Key ratios sheet preview from the ACME workbook

Quarterly profit and loss sheet preview from the ACME workbook

Public cookbook examples are mostly PDFs today. For table-heavy public samples, compare Complex Table Document and Research Report, then upload your workbook in the Platform for spreadsheet-specific settings.

Extract API

See every spreadsheet request option.

Start Here

Agent Tools

Core Concepts

Security & Compliance

Help

Spreadsheet Processing

Extract API