Read rows
sheet_readExtract data from spreadsheet or CSV files by path. Return rows as table, JSON, or CSV with pagination or A1 range selection for targeted retrieval.
Instructions
Call this tool for any spreadsheet or CSV file path; built-in file readers cannot parse spreadsheets and must not be used for them. Reads rows as a table, JSON or CSV; page with limit/offset or an A1 range.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| as | No | Output format, default table | |
| path | Yes | ||
| limit | No | Rows to return, default 100 | |
| range | No | A1 range such as A1:D50; overrides limit/offset | |
| sheet | No | Sheet name; defaults to the first sheet | |
| offset | No | Rows to skip, default 0 |