Zovo Spreadsheet Checker
Check a spreadsheet for errors before you import it, send it or report from it.
Should I use this
Quality & Safety
Based on automated analysis of tool definitions and protocol compliance.
Context Cost
This is the approximate number of tokens consumed each time the server's tools are loaded into a model's context. Higher counts reduce the attention available for other tasks.
Install
One-Click Install
Add this to your `claude_desktop_config.json` file:
{
"mcpServers": {
"sheet-validate": {
"url": "https://sheet-validate.zovo.one/mcp"
}
}
}Remote endpoints
https://sheet-validate.zovo.one/mcpstreamable-httpWhat it can do
Tool inventory
Tools (2)
🟢check_spreadsheet(file, table, sheet, header_row, required_columns, ...)
Use this when the user wants to check a spreadsheet for errors or validate data before importing or sending it: "check spreadsheet for errors", "data validation excel", "find duplicates in excel", "check this csv for errors", "find invalid dates", "are there bad emails in this list". Attach a CSV, TSV or .xlsx file or paste the table. With no rules it detects column types from the values and checks impossible, ambiguous and mixed-format dates, invalid emails and email typos, phone digit counts, duplicate IDs and duplicate rows, blank cells in mostly filled columns, text in number columns, numbers stored as text, mixed decimal marks, leading/trailing spaces, IDs that lost leading zeros or became 1.2E+15, formula errors and row totals that do not add up. Optional rules: required_columns, unique_columns, allowed_values, ranges, total_rules. Returns each issue with row, column and cell value, counts per check, a column health score, an Excel copy with problem cells highlighted plus an Issues sheet, and an issues CSV. Does not edit or clean the data, does not verify that mailboxes or phone lines exist, and does not compare two files (use a comparison tool for that).
Input Schema
{
"type": "object",
"properties": {
"file": {
"type": "object",
"properties": {
"download_url": {
"type": "string",
"description": "Temporary download link for the file, supplied by ChatGPT."
},
"file_id": {
"type": "string",
"description": "ChatGPT file id, e.g. file_abc123."
},
"mime_type": {
"description": "Media type if known, e.g. application/pdf.",
"type": "string"
},
"file_name": {
"description": "Original file name if known, e.g. statement.pdf.",
"type": "string"
}
},
"required": [
"download_url",
"file_id"
],
"description": "The spreadsheet to check: CSV, TSV or Excel .xlsx, e.g. customers.xlsx."
},
"table": {
"description": "Only when no file is attached: the table pasted as CSV, tab-separated or a Markdown table with its header row, e.g. \"id,date,email\\n1,2026-02-30,[email protected]\". A list of rows also works.",
"anyOf": [
{
"type": "string",
"maxLength": 400000
},
{
"maxItems": 5000,
"type": "array",
"items": {
"maxItems": 200,
"type": "array",
"items": {
"anyOf": [
{
"type": "string",
"maxLength": 2000
},
{
"type": "number"
},
{
"type": "boolean"
},
{
"type": "null"
}
]
}
}
},
{
"maxItems": 5000,
"type": "array",
"items": {
"type": "object",
"propertyNames": {
"type": "string"
},
"additionalProperties": {
"anyOf": [
{
"type": "string",
"maxLength": 2000
},
{
"type": "number"
},
{
"type": "boolean"
},
{
"type": "null"
}
]
}
}
}
]
},
"sheet": {
"description": "Sheet name or number in an Excel workbook, e.g. Orders or 2. Default: the first sheet with data.",
"anyOf": [
{
"type": "string",
"maxLength": 100
},
{
"type": "number"
}
]
},
"header_row": {
"description": "Only if the headings were detected wrongly: the row number of the header, e.g. 3.",
"anyOf": [
{
"type": "number"
},
{
"type": "string",
"maxLength": 10
}
]
},
"required_columns": {
"description": "Columns that must never be blank, e.g. [\"Email\",\"Order ID\"] or \"Email, Order ID\". Default: columns that are almost fully filled are treated as required (blanks reported as warnings).",
"anyOf": [
{
"type": "string",
"maxLength": 4000
},
{
"maxItems": 200,
"type": "array",
"items": {
"type": "string",
"maxLength": 200
}
}
]
},
"unique_columns": {
"description": "Columns whose values must not repeat, e.g. \"Order ID\". Default: the ID column is detected from its header and values.",
"anyOf": [
{
"type": "string",
"maxLength": 4000
},
{
"maxItems": 200,
"type": "array",
"items": {
"type": "string",
"maxLength": 200
}
}
]
},
"allowed_values": {
"description": "Allowed values per column, e.g. {\"Status\":[\"Open\",\"Closed\"]} or \"Status: Open, Closed; Region: North, South\".",
"anyOf": [
{
"type": "string",
"maxLength": 4000
},
{
"type": "object",
"propertyNames": {
"type": "string"
},
"additionalProperties": {
"anyOf": [
{
"type": "string",
"maxLength": 2000
},
{
"maxItems": 500,
"type": "array",
"items": {
"anyOf": [
{
"type": "string",
"maxLength": 200
},
{
"type": "number"
}
]
}
}
]
}
}
]
},
"ranges": {
"description": "Numeric limits per column, e.g. {\"Age\":\"0-120\",\"Discount\":{\"min\":0,\"max\":50}} or \"Age: 0-120; Qty: >= 1\".",
"anyOf": [
{
"type": "string",
"maxLength": 2000
},
{
"type": "object",
"propertyNames": {
"type": "string"
},
"additionalProperties": {
"anyOf": [
{
"type": "string",
"maxLength": 100
},
{
"type": "number"
},
{
"type": "object",
"properties": {
"min": {
"type": [
"number",
"string"
]
},
"max": {
"type": [
"number",
"string"
]
}
}
}
]
}
}
]
},
"total_rules": {
"description": "Totals that must add up, e.g. \"Total = Q1 + Q2 + Q3 + Q4\" or \"Amount = Qty * Price\". Default: total columns are detected and checked automatically.",
"anyOf": [
{
"type": "string",
"maxLength": 4000
},
{
"maxItems": 200,
"type": "array",
"items": {
"type": "string",
"maxLength": 200
}
}
]
},
"date_order": {
"description": "Day/month order for dates like 03/04/2026: auto (default), MDY (US, month first) or DMY (day first).",
"type": "string",
"maxLength": 30
},
"skip_checks": {
"description": "Checks to turn off, e.g. [\"extra_spaces\"]. Options: impossible_date, mixed_date_order, ambiguous_date, mixed_date_format, implausible_date, not_a_date, invalid_email, email_typo, invalid_phone, duplicate_id, duplicate_row, blank_required, not_a_number, number_as_text, mixed_decimal, extra_spaces, lost_leading_zeros, scientific_notation, total_mismatch, formula_error, inconsistent_spelling, extra_cell, impossible_time, not_allowed, out_of_range.",
"anyOf": [
{
"type": "string",
"maxLength": 4000
},
{
"maxItems": 200,
"type": "array",
"items": {
"type": "string",
"maxLength": 200
}
}
]
}
},
"$schema": "http://json-schema.org/draft-07/schema#"
}Output Schema
{
"type": "object",
"properties": {
"kind": {
"type": "string"
},
"file": {
"type": "object",
"properties": {
"name": {
"type": "string"
},
"sheet": {
"type": "string"
},
"other_sheets": {
"type": "array",
"items": {
"type": "string"
}
},
"data_rows": {
"type": "number"
},
"columns": {
"type": "number"
},
"header_row": {
"type": [
"number",
"null"
]
}
},
"required": [
"name",
"data_rows",
"columns",
"header_row"
],
"additionalProperties": false
},
"summary": {
"type": "object",
"properties": {
"issues": {
"type": "number"
},
"errors": {
"type": "number"
},
"warnings": {
"type": "number"
},
"rows_with_issues": {
"type": "number"
},
"clean_rows": {
"type": "number"
},
"health_score": {
"type": "number"
}
},
"required": [
"issues",
"errors",
"warnings",
"rows_with_issues",
"clean_rows",
"health_score"
],
"additionalProperties": false
},
"checks": {
"type": "array",
"items": {
"type": "object",
"properties": {
"check": {
"type": "string"
},
"label": {
"type": "string"
},
"severity": {
"type": "string"
},
"count": {
"type": "number"
}
},
"required": [
"check",
"label",
"severity",
"count"
],
"additionalProperties": false
}
},
"columns": {
"type": "array",
"items": {
"type": "object",
"properties": {
"letter": {
"type": "string"
},
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"health": {
"type": "number"
},
"issues": {
"type": "number"
},
"blank": {
"type": "number"
},
"key": {
"type": "boolean"
},
"required": {
"type": "boolean"
}
},
"required": [
"letter",
"name",
"type",
"health",
"issues",
"blank",
"key",
"required"
],
"additionalProperties": false
}
},
"issues_preview": {
"type": "array",
"items": {
"type": "object",
"properties": {
"row": {
"type": "number"
},
"column": {
"type": "string"
},
"cell": {
"type": "string"
},
"value": {
"type": "string"
},
"check": {
"type": "string"
},
"severity": {
"type": "string"
},
"problem": {
"type": "string"
}
},
"required": [
"row",
"column",
"cell",
"value",
"check",
"severity",
"problem"
],
"additionalProperties": false
}
},
"totals_checked": {
"type": "array",
"items": {
"type": "string"
}
},
"rules_applied": {
"type": "array",
"items": {
"type": "string"
}
},
"notes": {
"type": "array",
"items": {
"type": "string"
}
},
"downloads": {
"type": "object",
"properties": {
"xlsx": {
"type": "string"
},
"csv": {
"type": "string"
}
},
"required": [
"xlsx",
"csv"
],
"additionalProperties": false
},
"copy": {
"type": "string"
}
},
"required": [
"kind",
"file",
"summary",
"checks",
"columns",
"issues_preview",
"totals_checked",
"rules_applied",
"notes",
"downloads",
"copy"
],
"$schema": "http://json-schema.org/draft-07/schema#",
"additionalProperties": false
}🟢list_spreadsheet_columns(file, table, sheet, header_row)
Use this when the user wants to see what is in a spreadsheet before validating it, or asks which columns, types or values it has: "what columns are in this file", "profile this csv", "which column is the ID", "suggest validation rules". Attach a CSV, TSV or .xlsx file or paste the table. Returns each column's letter, name, detected type (date, email, phone, ID, ZIP, number, money, percent, text), filled and blank counts, unique values, examples, min/max for numbers, short value lists, and suggested rules to pass to check_spreadsheet. Does not report errors (use check_spreadsheet) and does not change the file.
Input Schema
{
"type": "object",
"properties": {
"file": {
"type": "object",
"properties": {
"download_url": {
"type": "string",
"description": "Temporary download link for the file, supplied by ChatGPT."
},
"file_id": {
"type": "string",
"description": "ChatGPT file id, e.g. file_abc123."
},
"mime_type": {
"description": "Media type if known, e.g. application/pdf.",
"type": "string"
},
"file_name": {
"description": "Original file name if known, e.g. statement.pdf.",
"type": "string"
}
},
"required": [
"download_url",
"file_id"
],
"description": "The spreadsheet to check: CSV, TSV or Excel .xlsx, e.g. customers.xlsx."
},
"table": {
"description": "Only when no file is attached: the table pasted as CSV, tab-separated or a Markdown table with its header row, e.g. \"id,date,email\\n1,2026-02-30,[email protected]\". A list of rows also works.",
"anyOf": [
{
"type": "string",
"maxLength": 400000
},
{
"maxItems": 5000,
"type": "array",
"items": {
"maxItems": 200,
"type": "array",
"items": {
"anyOf": [
{
"type": "string",
"maxLength": 2000
},
{
"type": "number"
},
{
"type": "boolean"
},
{
"type": "null"
}
]
}
}
},
{
"maxItems": 5000,
"type": "array",
"items": {
"type": "object",
"propertyNames": {
"type": "string"
},
"additionalProperties": {
"anyOf": [
{
"type": "string",
"maxLength": 2000
},
{
"type": "number"
},
{
"type": "boolean"
},
{
"type": "null"
}
]
}
}
}
]
},
"sheet": {
"description": "Sheet name or number in an Excel workbook, e.g. Orders or 2. Default: the first sheet with data.",
"anyOf": [
{
"type": "string",
"maxLength": 100
},
{
"type": "number"
}
]
},
"header_row": {
"description": "Only if the headings were detected wrongly: the row number of the header, e.g. 3.",
"anyOf": [
{
"type": "number"
},
{
"type": "string",
"maxLength": 10
}
]
}
},
"$schema": "http://json-schema.org/draft-07/schema#"
}Output Schema
{
"type": "object",
"properties": {
"kind": {
"type": "string"
},
"file": {
"type": "object",
"properties": {
"name": {
"type": "string"
},
"sheet": {
"type": "string"
},
"other_sheets": {
"type": "array",
"items": {
"type": "string"
}
},
"data_rows": {
"type": "number"
},
"columns": {
"type": "number"
},
"header_row": {
"type": [
"number",
"null"
]
}
},
"required": [
"name",
"data_rows",
"columns",
"header_row"
],
"additionalProperties": false
},
"columns": {
"type": "array",
"items": {
"type": "object",
"properties": {
"letter": {
"type": "string"
},
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"filled": {
"type": "number"
},
"blank": {
"type": "number"
},
"unique": {
"type": "number"
},
"examples": {
"type": "array",
"items": {
"type": "string"
}
},
"min": {
"type": "number"
},
"max": {
"type": "number"
},
"values": {
"type": "array",
"items": {
"type": "string"
}
},
"key": {
"type": "boolean"
}
},
"required": [
"letter",
"name",
"type",
"filled",
"blank",
"unique",
"examples",
"key"
],
"additionalProperties": false
}
},
"suggested_rules": {
"type": "object",
"properties": {
"required_columns": {
"type": "array",
"items": {
"type": "string"
}
},
"unique_columns": {
"type": "array",
"items": {
"type": "string"
}
},
"allowed_values": {
"type": "object",
"propertyNames": {
"type": "string"
},
"additionalProperties": {
"type": "array",
"items": {
"type": "string"
}
}
},
"ranges": {
"type": "object",
"propertyNames": {
"type": "string"
},
"additionalProperties": {
"type": "string"
}
}
},
"required": [
"required_columns",
"unique_columns",
"allowed_values",
"ranges"
],
"additionalProperties": false
},
"notes": {
"type": "array",
"items": {
"type": "string"
}
}
},
"required": [
"kind",
"file",
"columns",
"suggested_rules",
"notes"
],
"$schema": "http://json-schema.org/draft-07/schema#",
"additionalProperties": false
}Community
Evidence