read_spreadsheet
Read Excel (.xlsx, .xlsm, .xls) or CSV files, list sheet names first, then extract a chosen sheet with an A1 range and output as markdown, CSV, or JSON.
Instructions
Read an Excel (.xlsx / .xlsm / .xls) or CSV file. Two-step pattern: (1) call WITHOUT sheet to list sheet names, (2) call again with sheet to read that sheet. Optional A1-style range (e.g. "A1:D50") and format ('markdown' default, or 'csv' / 'json'). headerRow=true (default) treats row 1 as keys when format='json'.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| url | No | ||
| data | No | ||
| path | No | ||
| range | No | Optional A1 range like "A1:D50". | |
| sheet | No | Sheet name or zero-based index. Omit to just list sheets. | |
| format | No | Output format. Default: markdown. | |
| maxRows | No | Cap on rows returned (default: 1000, max: 50000). | |
| mimeType | No | ||
| headerRow | No | For json: treat row 1 as headers (default: true). |