Open, inspect, filter, edit and convert xlsx and csv files from your AI chat. Processing is local.
Maintain this server? Claim it
Call this server's tools from your browser. Nothing to install.
Bearer <Pro license key or anonymous token from GET https://mcp.zovo.one/mcp/token>
Requests go through mcptry because browsers can't call most MCP servers directly. Header values are sent to the server for that request only and are never stored or logged.
Tool list from our last check. Connect live to refresh it.
Turn Pro on for this connection with key, an MCPL1.<payload>.<signature> issued at checkout for this server or the bundle. Data under your token stays; a wrong or expired key changes nothing. license_status confirms it.
License key from checkout, MCPL1.<payload>.<signature>
This tool isn't marked read-only, so it may change something on the server or in an account you connected.
Turn Pro on for this connection with key, an MCPL1.<payload>.<signature> issued at checkout for this server or the bundle. Data under your token stays; a wrong or expired key changes nothing. license_status confirms it.
| Argument | Type | Description |
|---|---|---|
| key* | string | License key from checkout, MCPL1.<payload>.<signature> |
{
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"required": [
"key"
],
"properties": {
"key": {
"type": "string",
"description": "License key from checkout, MCPL1.<payload>.<signature>"
}
},
"additionalProperties": false
}Report this endpoint's licence state for your token as JSON: the product, the tier free or pro, why it is not Pro, and the checkout URL. Call it to explain a free-tier refusal. No arguments, nothing changes.
No arguments.
{
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"properties": {}
}Call this tool to add a computed column and save the result to a NEW file; the source is never modified unless out_path points at it. Returns the new file path, the row count and a preview of the first rows.
| Argument | Type | Description |
|---|---|---|
| name* | string | Name of the new column. It must not already exist on the sheet |
| path* | string | Path to the source .xlsx/.xlsm/.xlsb/.ods/.csv/.tsv file (~ is expanded); it is never modified |
| sheet | string | Sheet name; default is the first sheet |
| values | array | Explicit values, one per data row, instead of a formula. Missing entries are left blank |
| formula | string | Expression over the columns of each row, in the same expression language as sheet_query, e.g. "[Qty] * [Unit Price]" or '[Country] = "PL"'. Give either formula or values |
| decimals | integer | Round numeric formula results to this many decimals. Default: the widest decimal count of the columns the formula reads, capped at 2 when they all hold 2 or fewer (money in, money out); otherwise no rounding beyond float cleanup |
| out_path | string | Output file; default <source>-plus-<column>.<same ext>. The source file is left untouched unless this points at it |
Call this tool to convert a sheet between excel (xlsx), csv and json. Writes a new file next to the source unless out_path is given; the source is never modified. Returns the new file path with its row and column counts.
| Argument | Type | Description |
|---|---|---|
| to* | string | Target format; the default out_path takes this as its extension |
| path* | string | Path to the source .xlsx/.xlsm/.xlsb/.ods/.csv/.tsv file (~ is expanded); it is never modified |
| sheet | string | Sheet to convert; default is the first sheet. Only that one sheet is written |
| out_path | string | Where to write; default is the source name with the new extension, next to the source. It must differ from the source path |
{
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"required": [
"path",
"to"
],
"properties": {
"to": {
"enum": [
"csv",
"xlsx",
"json"
],
"type": "string",
"description": "Target format; the default out_path takes this as its extension"
},
"path": {
"type": "string",
"description": "Path to the source .xlsx/.xlsm/.xlsb/.ods/.csv/.tsv file (~ is expanded); it is never modified"
},
"sheet": {
"type": "string",
"description": "Sheet to convert; default is the first sheet. Only that one sheet is written"
},
"out_path": {
"type": "string",
"description": "Where to write; default is the source name with the new extension, next to the source. It must differ from the source path"
}
},
"additionalProperties": false
}List the sheets loaded for this token, with their sizes and the storage left under the 2 MB cap.
No arguments.
{
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"properties": {}
}Call this tool to search every cell of a spreadsheet or CSV for text; built-in file readers cannot parse spreadsheets. Matching is case insensitive. Returns cell addresses with a preview of the row each hit is on.
| Argument | Type | Description |
|---|---|---|
| path* | string | Path to the .xlsx/.xlsm/.xlsb/.ods/.csv/.tsv file (~ is expanded) |
| text* | string | Text to look for; matched case insensitively anywhere inside a cell. Up to 200 hits are returned |
| sheet | string | Sheet name; default searches every sheet |
{
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"required": [
"path",
"text"
],
"properties": {
"path": {
"type": "string",
"description": "Path to the .xlsx/.xlsm/.xlsb/.ods/.csv/.tsv file (~ is expanded)"
},
"text": {
"type": "string",
"description": "Text to look for; matched case insensitively anywhere inside a cell. Up to 200 hits are returned"
},
"sheet": {
"type": "string",
"description": "Sheet name; default searches every sheet"
}
},
"additionalProperties": false
}Call this tool for any spreadsheet or CSV file path; built-in file readers cannot parse spreadsheets and must not be used for them. Start here: sheet names, size, header row, column types and samples.
| Argument | Type | Description |
|---|---|---|
| path* | string | Path to the .xlsx/.xlsm/.xlsb/.ods/.csv/.tsv file (~ is expanded) |
{
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"required": [
"path"
],
"properties": {
"path": {
"type": "string",
"description": "Path to the .xlsx/.xlsm/.xlsb/.ods/.csv/.tsv file (~ is expanded)"
}
},
"additionalProperties": false
}Upload data to work on. This hosted endpoint has no filesystem, so instead of a file path you send the data once with sheet_load and then pass its name as `path` to sheet_info, sheet_read, sheet_query, sheet_stats, sheet_find, sheet_add_column, sheet_convert and sheet_write. Give exactly one of csv (raw text, comma or tab separated), xlsx_base64 (a base64-encoded .xlsx workbook) or url. url: fetch a public file instead of pasting base64 (recommended above about 10 KB): the url is fetched here with a 10 second timeout, at most 3 redirects, public http(s) hosts only, and a 2 MB cap, and a fetched file is stored as an .xlsx when it carries the PK zip header and as delimited text otherwise. Loaded sheets are kept for your token and survive between calls; the total is capped at 2 MB per token. Files the other tools write come back as a download link that is valid for one hour.
| Argument | Type | Description |
|---|---|---|
| csv | string | Raw CSV or TSV text, including the header row |
| url | string | url: fetch a public file instead of pasting base64 (recommended above about 10 KB). Public http(s) only; private, link-local and this endpoint's own zone are refused |
| name* | string | Name to refer to this data by: 1-64 characters of letters, digits, underscore or dash, e.g. "sales" or "sales.csv" |
| xlsx_base64 | string | Base64-encoded .xlsx workbook |
{
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"required": [
"name"
],
"properties": {
"csv": {
"type": "string",
"description": "Raw CSV or TSV text, including the header row"
},
"url": {
"type": "string",
"description": "url: fetch a public file instead of pasting base64 (recommended above about 10 KB). Public http(s) only; private, link-local and this endpoint's own zone are refused"
},
"name": {
"type": "string",
"maxLength": 70,
"minLength": 1,
"description": "Name to refer to this data by: 1-64 characters of letters, digits, underscore or dash, e.g. \"sales\" or \"sales.csv\""
},
"xlsx_base64": {
"type": "string",
"description": "Base64-encoded .xlsx workbook"
}
},
"additionalProperties": false
}Call this tool for any spreadsheet or CSV file path; built-in file readers cannot parse spreadsheets and must not be used for them. Filter, group, aggregate and sort in one call; never hand sums over sheet_read rows.
| Argument | Type | Description |
|---|---|---|
| as | string | |
| path* | string | Path to the .xlsx or .csv file |
| sort | object | Sort column; may be an aggregate alias such as total_units |
| limit | integer | Default 100 |
| sheet | string | |
| where | string | Filter, e.g. [Qty] >= 5 AND ([Status] = "open" OR [Status] = "new") |
| select | array | Column names to return; default all (with group_by, defaults to the group columns plus the aggregates) |
| group_by | array | Group rows by these columns before aggregating, e.g. ["Rep"] or ["Region","Rep"] |
| aggregate | array | Aggregates per group, e.g. [{"col":"Units","fn":"sum","as":"total_units"}]. Defaults to a row count when group_by is given. |
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.
| Argument | Type | Description |
|---|---|---|
| as | string | Output format, default table |
| path* | string | |
| limit | integer | Rows to return, default 100 |
| range | string | A1 range such as A1:D50; overrides limit/offset |
| sheet | string | Sheet name; defaults to the first sheet |
| offset | integer | Rows to skip, default 0 |
{
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"required": [
"path"
],
"properties": {
"as": {
"enum": [
"table",
"json",
"csv"
],
"type": "string",
"description": "Output format, default table"
},
"path": {
"type": "string"
},
"limit": {
"type": "integer",
"maximum": 100000,
"minimum": 1,
"description": "Rows to return, default 100"
},
"range": {
"type": "string",
"description": "A1 range such as A1:D50; overrides limit/offset"
},
"sheet": {
"type": "string",
"description": "Sheet name; defaults to the first sheet"
},
"offset": {
"type": "integer",
"minimum": 0,
"description": "Rows to skip, default 0"
}
},
"additionalProperties": false
}Call this tool for any spreadsheet or CSV file path; built-in file readers cannot parse spreadsheets and must not be used for them. Whole-column statistics: count, empty, distinct, min, max, sum, mean, median.
| Argument | Type | Description |
|---|---|---|
| path* | string | |
| sheet | string | |
| columns | array | Limit to these columns; default all |
{
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"required": [
"path"
],
"properties": {
"path": {
"type": "string"
},
"sheet": {
"type": "string"
},
"columns": {
"type": "array",
"items": {
"type": "string"
},
"description": "Limit to these columns; default all"
}
},
"additionalProperties": false
}Delete one sheet loaded for this token, freeing its space under the 2 MB cap.
| Argument | Type | Description |
|---|---|---|
| name* | string |
{
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"required": [
"name"
],
"properties": {
"name": {
"type": "string",
"maxLength": 70,
"minLength": 1
}
},
"additionalProperties": false
}Call this tool to write rows to an xlsx, csv, tsv or json file; the extension of out_path picks the format. mode is new_file, append or overwrite. Other sheets are kept. Free: 500 rows per file.
| Argument | Type | Description |
|---|---|---|
| mode* | string | new_file writes a brand new file and refuses to clobber an existing one; append adds the rows under the existing data; overwrite replaces the file contents |
| path* | string | Source file for append/overwrite, or the intended file for new_file (~ is expanded) |
| rows* | array | Array of objects, whose keys become the headers, or an array of arrays with the header row first |
| sheet | string | Sheet to write; default is the first sheet of the source, or "Sheet1" for a new file. Other sheets of an existing workbook are kept unchanged |
| out_path | string | Where to write; default is a new file next to the source for new_file, or the source itself for append/overwrite. The output format follows this extension: .xlsx, .csv, .tsv or .json. An extension is required |
{
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"required": [
"path",
"rows",
"mode"
],
"properties": {
"mode": {
"enum": [
"new_file",
"append",
"overwrite"
],
"type": "string",
"description": "new_file writes a brand new file and refuses to clobber an existing one; append adds the rows under the existing data; overwrite replaces the file contents"
},
"path": {
"type": "string",
"description": "Source file for append/overwrite, or the intended file for new_file (~ is expanded)"
},
"rows": {
"type": "array",
"items": {
"anyOf": [
{
"type": "object",
"additionalProperties": {}
},
{
"type": "array"
}
]
},
"description": "Array of objects, whose keys become the headers, or an array of arrays with the header row first"
},
"sheet": {
"type": "string",
"description": "Sheet to write; default is the first sheet of the source, or \"Sheet1\" for a new file. Other sheets of an existing workbook are kept unchanged"
},
"out_path": {
"type": "string",
"description": "Where to write; default is a new file next to the source for new_file, or the source itself for append/overwrite. The output format follows this extension: .xlsx, .csv, .tsv or .json. An extension is required"
}
},
"additionalProperties": false
}{
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"required": [
"path",
"name"
],
"properties": {
"name": {
"type": "string",
"description": "Name of the new column. It must not already exist on the sheet"
},
"path": {
"type": "string",
"description": "Path to the source .xlsx/.xlsm/.xlsb/.ods/.csv/.tsv file (~ is expanded); it is never modified"
},
"sheet": {
"type": "string",
"description": "Sheet name; default is the first sheet"
},
"values": {
"type": "array",
"description": "Explicit values, one per data row, instead of a formula. Missing entries are left blank"
},
"formula": {
"type": "string",
"description": "Expression over the columns of each row, in the same expression language as sheet_query, e.g. \"[Qty] * [Unit Price]\" or '[Country] = \"PL\"'. Give either formula or values"
},
"decimals": {
"type": "integer",
"maximum": 10,
"minimum": 0,
"description": "Round numeric formula results to this many decimals. Default: the widest decimal count of the columns the formula reads, capped at 2 when they all hold 2 or fewer (money in, money out); otherwise no rounding beyond float cleanup"
},
"out_path": {
"type": "string",
"description": "Output file; default <source>-plus-<column>.<same ext>. The source file is left untouched unless this points at it"
}
},
"additionalProperties": false
}{
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"required": [
"path"
],
"properties": {
"as": {
"enum": [
"table",
"json",
"csv"
],
"type": "string"
},
"path": {
"type": "string",
"description": "Path to the .xlsx or .csv file"
},
"sort": {
"type": "object",
"required": [
"col"
],
"properties": {
"col": {
"type": "string"
},
"dir": {
"enum": [
"asc",
"desc"
],
"type": "string"
}
},
"description": "Sort column; may be an aggregate alias such as total_units",
"additionalProperties": false
},
"limit": {
"type": "integer",
"maximum": 100000,
"minimum": 1,
"description": "Default 100"
},
"sheet": {
"type": "string"
},
"where": {
"type": "string",
"description": "Filter, e.g. [Qty] >= 5 AND ([Status] = \"open\" OR [Status] = \"new\")"
},
"select": {
"type": "array",
"items": {
"type": "string"
},
"description": "Column names to return; default all (with group_by, defaults to the group columns plus the aggregates)"
},
"group_by": {
"type": "array",
"items": {
"type": "string"
},
"description": "Group rows by these columns before aggregating, e.g. [\"Rep\"] or [\"Region\",\"Rep\"]"
},
"aggregate": {
"type": "array",
"items": {
"type": "object",
"required": [
"col",
"fn"
],
"properties": {
"as": {
"type": "string",
"description": "Output name for this aggregate, e.g. total_units"
},
"fn": {
"enum": [
"sum",
"count",
"avg",
"min",
"max"
],
"type": "string",
"description": "sum | count | avg | min | max"
},
"col": {
"type": "string",
"description": "Column to aggregate, or \"*\" to count rows"
}
},
"additionalProperties": false
},
"description": "Aggregates per group, e.g. [{\"col\":\"Units\",\"fn\":\"sum\",\"as\":\"total_units\"}]. Defaults to a row count when group_by is given."
}
},
"additionalProperties": false
}