Inspect a sheet
inspect_sheetRead-onlyIdempotent
Use this when the user asks what sheets or columns a spreadsheet has, how many rows it has, or how many pages it would print before making a PDF. Takes the same file or CSV text, sheet, columns and layout options as sheet_to_pdf and returns the sheets (with hidden ones marked), the header row, row and column counts, empty and widest columns, formula cells without a saved result, a 5-row preview and the page estimate for the chosen layout. Does not make a file and does not change the sheet.
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "inspect_sheet"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file | No | The sheet to print: a CSV, TSV or Excel .xlsx file, e.g. inventory.xlsx or contacts.csv. | |
| paper | No | Paper size, e.g. a4. Default letter. | |
| sheet | No | For .xlsx: the sheet name to print, e.g. "Q3 Sales". Default: the first visible sheet. | |
| title | No | Optional title above the table on page 1, up to 120 characters, e.g. "Inventory, November 2026". | |
| columns | No | Print only these columns, in this order, by header name or column letter, e.g. ["Name", "Email", "Total"]. Default: all columns. | |
| csv_text | No | Instead of a file: the table as CSV text with a header row, e.g. "Name,Qty\nApples,3\nPears,5". Use either file or csv_text. | |
| delimiter | No | For CSV text: the separator, e.g. semicolon. Default: detected from the file. | |
| fit_width | No | true (default): when columns are too wide, the font gets smaller (down to 7 pt) before cells wrap. false: keep font_size and wrap cell text. | |
| font_size | No | Font size in points from 7 to 12, e.g. 9 (default). | |
| has_header | No | true (default): the first non-empty row is the header row (one-cell title rows above it are printed as the title). false: columns are named Column A, Column B, ... | |
| header_row | No | The sheet row (or CSV line) number that holds the header, e.g. 3 when rows 1-2 hold a title. Rows above it are left out. Default: detected. | |
| orientation | No | Page orientation, e.g. landscape. auto (default) picks portrait when the columns fit, else landscape. | |
| row_numbers | No | true adds a # column with row numbers 1, 2, 3. Default false. | |
| page_numbers | No | true (default) prints Page 1 of N in each page footer. | |
| include_hidden | No | For .xlsx: true also prints hidden rows and columns. Default false (as Excel prints). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file | Yes | ||
| kind | Yes | ||
| notes | Yes | ||
| sheet | Yes | ||
| header | Yes | ||
| sheets | Yes | ||
| columns | Yes | ||
| preview | Yes | ||
| encoding | No | ||
| estimate | Yes | ||
| data_rows | Yes | ||
| delimiter | No | ||
| header_note | Yes | ||
| hidden_rows | Yes | ||
| header_count | No | ||
| empty_columns | Yes | ||
| preview_count | No | ||
| hidden_columns | Yes | ||
| widest_columns | Yes | ||
| formula_cells_without_value | Yes |