Column Info
The /info endpoint returns a per-column statistical summary of the sheet. It is useful for quickly inspecting the shape of your data without pulling every row.
Request
- cURL
- JavaScript
- Python
curl 'https://api.sheetbest.com/sheets/YOUR_SHEET_ID/info'
fetch('https://api.sheetbest.com/sheets/YOUR_SHEET_ID/info');
import requests
requests.get('https://api.sheetbest.com/sheets/YOUR_SHEET_ID/info')
Returned fields
For each column, the response includes:
| Field | Description |
|---|---|
count | Number of entries in the column |
mean | Mean / average value |
std | Standard deviation |
min | Minimum value |
25% | 25th percentile |
50% | 50th percentile (median) |
75% | 75th percentile |
max | Maximum value |
For one-off aggregations (sum, max, mean, ...) over all rows, see aggregations.