describe_columns
Profiles sheet or range columns like a data table: detects headers, infers data types, counts non-null/empty/distinct values, min/max, common text, errors, and formula/constant status.
Instructions
Profile the columns of a sheet or range like a data table: detected header row, inferred type per column (integer, number, text, date, datetime, boolean, mixed ...), non-null and empty counts, distinct count, min/max, most common text values, numbers stored as text, error cells, and whether the column holds formulas, constants or a MIX of both (a sign someone overwrote a formula with a typed number).
header_row: omit to auto-detect; 0 means 'no header'; N means row N is the header (rows above it are ignored). range limits the area (default: the whole used range).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | ||
| range | No | ||
| sheet | Yes | ||
| max_rows | No | ||
| header_row | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |