Zovo Spreadsheet Compare is an MCP server published by io.github.theluckystrike, hosted at sheet-compare.zovo.one. When last checked on 2026-11-21 it was working: it answers and lists its tools. It declares 2 tools, including compare_spreadsheets, summarize_changes.
Compare two spreadsheets
958 connections through 4 shared values. Tap any node.
Use this when the user has two versions of the same spreadsheet (CSV or Excel: price list, inventory, roster, budget, product catalog, CRM export) and wants to "compare two excel files", "compare two spreadsheets", "find the differences between two csv files", "what changed between these files" or "list what changed". Matches rows by a key column it detects (or key_columns), lists all added, removed and changed rows with each changed cell old -> new, numeric change and percent, plus renamed/moved columns and key changes, and returns an Excel workbook (Summary, Changed, Cell changes, Added, Removed, annotated new version) and a changes CSV. Does not merge or join two different tables (e.g. customers + orders), does not compare Word or PDF documents, and does not edit either file.
| Parameter | Type | Description |
|---|---|---|
| new_file | object | The NEWER version (CSV, TSV or Excel .xlsx), e.g. pricelist_2026Q4.xlsx or roster-october.csv. |
| old_file | object | The OLDER version (CSV, TSV or Excel .xlsx), e.g. pricelist_2026Q3.xlsx or roster-september.csv. |
None yet. Changes appear after a server's second daily check.
Squares are this server's values; dots are other servers sharing them. A shared address or publisher is a lead, not proof of a common operator.
Inferred from the host name and headers: what a server runs on, not who runs it.
| new_sheet | string | Sheet (tab) to read from the new workbook, e.g. Prices Q4. |
| new_table | string | Instead of new_file: the newer version pasted as CSV/TSV text with a header row, e.g. "SKU,Price\nA1,10.50\nC3,7.00". |
| old_sheet | string | Sheet (tab) to read from the old workbook, e.g. Prices Q3. Default: the sheet with the same name as in the new workbook, else the first sheet with data. |
| old_table | string | Instead of old_file: the older version pasted as CSV/TSV text with a header row, e.g. "SKU,Price\nA1,10.00\nB2,5.00". |
| column_map | object | Old column name -> new column name for renamed columns, e.g. {"Unit Price": "Price (USD)"}. Turns off automatic rename detection. |
| ignore_case | boolean | Treat ABC and abc as equal, e.g. true. Default false. |
| key_columns | array | Column(s) that identify a row, to override the automatic key, e.g. ["SKU"] or ["Store", "Product code"]. |
| header_row_new | integer | Row number of the column headings in the new file, e.g. 3. |
| header_row_old | integer | Row number of the column headings in the old file when it is not detected, e.g. 3 when two title rows come first. |
| ignore_columns | array | Columns to leave out of the comparison, e.g. ["Last updated", "Notes"]. |
| normalize_dates | boolean | Compare dates by calendar day, so 2026-03-05, 3/5/2026 and an Excel date serial are equal, e.g. true (default). |
| trim_whitespace | boolean | Ignore leading/trailing and repeated spaces, e.g. true (default). |
| numeric_tolerance | number | Numbers that differ by this much or less count as equal, e.g. 0.01 to ignore rounding by a cent. Default 0. |
| detect_key_changes | boolean | Report a removed row and an added row whose other values are identical as one key change (e.g. a SKU renumbered), e.g. true (default). |
| compare_row_numbers | boolean | Compare a running row-number column (#, Row, No.: 1, 2, 3...) like any other column, e.g. true. Default false: it shifts whenever a row is inserted, so it is skipped with a note. |
| compare_numbers_as_values | boolean | Compare numbers by value so "1,200.00" equals 1200, e.g. true (default). Codes with leading zeros (00123) stay text. |
{
"name": "compare_spreadsheets",
"title": "Compare spreadsheets",
"description": "Use this when the user has two versions of the same spreadsheet (CSV or Excel: price list, inventory, roster, budget, product catalog, CRM export) and wants to \"compare two excel files\", \"compare two spreadsheets\", \"find the differences between two csv files\", \"what changed between these files\" or \"list what changed\". Matches rows by a key column it detects (or key_columns), lists all added, removed and changed rows with each changed cell old -> new, numeric change and percent, plus renamed/moved columns and key changes, and returns an Excel workbook (Summary, Changed, Cell changes, Added, Removed, annotated new version) and a changes CSV. Does not merge or join two different tables (e.g. customers + orders), does not compare Word or PDF documents, and does not edit either file.",
"inputSchema": {
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"properties": {
"new_file": {
"type": "object",
"required": [
"download_url",
"file_id"
],
"properties": {
"file_id": {
"type": "string",
"description": "ChatGPT file id, e.g. file_abc123."
},
"file_name": {
"type": "string",
"description": "Original file name if known, e.g. statement.pdf."
},
"mime_type": {
"type": "string",
"description": "Media type if known, e.g. application/pdf."
},
"download_url": {
"type": "string",
"description": "Temporary download link for the file, supplied by ChatGPT."
}
},
"description": "The NEWER version (CSV, TSV or Excel .xlsx), e.g. pricelist_2026Q4.xlsx or roster-october.csv."
},
"old_file": {
"type": "object",
"required": [
"download_url",
"file_id"
],
"properties": {
"file_id": {
"type": "string",
"description": "ChatGPT file id, e.g. file_abc123."
},
"file_name": {
"type": "string",
"description": "Original file name if known, e.g. statement.pdf."
},
"mime_type": {
"type": "string",
"description": "Media type if known, e.g. application/pdf."
},
"download_url": {
"type": "string",
"description": "Temporary download link for the file, supplied by ChatGPT."
}
},
"description": "The OLDER version (CSV, TSV or Excel .xlsx), e.g. pricelist_2026Q3.xlsx or roster-september.csv."
},
"new_sheet": {
"type": "string",
"maxLength": 100,
"description": "Sheet (tab) to read from the new workbook, e.g. Prices Q4."
},
"new_table": {
"type": "string",
"maxLength": 200000,
"description": "Instead of new_file: the newer version pasted as CSV/TSV text with a header row, e.g. \"SKU,Price\\nA1,10.50\\nC3,7.00\"."
},
"old_sheet": {
"type": "string",
"maxLength": 100,
"description": "Sheet (tab) to read from the old workbook, e.g. Prices Q3. Default: the sheet with the same name as in the new workbook, else the first sheet with data."
},
"old_table": {
"type": "string",
"maxLength": 200000,
"description": "Instead of old_file: the older version pasted as CSV/TSV text with a header row, e.g. \"SKU,Price\\nA1,10.00\\nB2,5.00\"."
},
"column_map": {
"type": "object",
"description": "Old column name -> new column name for renamed columns, e.g. {\"Unit Price\": \"Price (USD)\"}. Turns off automatic rename detection.",
"propertyNames": {
"type": "string",
"maxLength": 100
},
"additionalProperties": {
"type": "string",
"maxLength": 100
}
},
"ignore_case": {
"type": "boolean",
"description": "Treat ABC and abc as equal, e.g. true. Default false."
},
"key_columns": {
"type": "array",
"items": {
"type": "string",
"maxLength": 100
},
"maxItems": 5,
"description": "Column(s) that identify a row, to override the automatic key, e.g. [\"SKU\"] or [\"Store\", \"Product code\"]."
},
"header_row_new": {
"type": "integer",
"maximum": 1000,
"minimum": 1,
"description": "Row number of the column headings in the new file, e.g. 3."
},
"header_row_old": {
"type": "integer",
"maximum": 1000,
"minimum": 1,
"description": "Row number of the column headings in the old file when it is not detected, e.g. 3 when two title rows come first."
},
"ignore_columns": {
"type": "array",
"items": {
"type": "string",
"maxLength": 100
},
"maxItems": 50,
"description": "Columns to leave out of the comparison, e.g. [\"Last updated\", \"Notes\"]."
},
"normalize_dates": {
"type": "boolean",
"description": "Compare dates by calendar day, so 2026-03-05, 3/5/2026 and an Excel date serial are equal, e.g. true (default)."
},
"trim_whitespace": {
"type": "boolean",
"description": "Ignore leading/trailing and repeated spaces, e.g. true (default)."
},
"numeric_tolerance": {
"type": "number",
"maximum": 1000000000,
"minimum": 0,
"description": "Numbers that differ by this much or less count as equal, e.g. 0.01 to ignore rounding by a cent. Default 0."
},
"detect_key_changes": {
"type": "boolean",
"description": "Report a removed row and an added row whose other values are identical as one key change (e.g. a SKU renumbered), e.g. true (default)."
},
"compare_row_numbers": {
"type": "boolean",
"description": "Compare a running row-number column (#, Row, No.: 1, 2, 3...) like any other column, e.g. true. Default false: it shifts whenever a row is inserted, so it is skipped with a note."
},
"compare_numbers_as_values": {
"type": "boolean",
"description": "Compare numbers by value so \"1,200.00\" equals 1200, e.g. true (default). Codes with leading zeros (00123) stay text."
}
}
},
"outputSchema": {
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"required": [
"files",
"key",
"counts",
"columns",
"by_column",
"biggest_changes",
"changes_preview",
"added_preview",
"removed_preview",
"key_changes_preview",
"excluded_rows",
"notes",
"downloads",
"complete_list"
],
"properties": {
"key": {
"type": "object",
"required": [
"mode",
"columns",
"explanation"
],
"properties": {
"mode": {
"enum": [
"key",
"content"
],
"type": "string"
},
"columns": {
"type": "array",
"items": {
"type": "string"
}
},
"explanation": {
"type": "string"
},
"repeated_keys": {
"type": "array",
"items": {
"type": "string"
}
}
},
"additionalProperties": false
},
"files": {
"type": "object",
"required": [
"old",
"new"
],
"properties": {
"new": {
"type": "object",
"required": [
"name",
"sheet",
"rows",
"header_row"
],
"properties": {
"name": {
"type": "string"
},
"rows": {
"type": "number"
},
"sheet": {
"type": [
"string",
"null"
]
},
"header_row": {
"type": "number"
}
},
"additionalProperties": false
},
"old": {
"type": "object",
"required": [
"name",
"sheet",
"rows",
"header_row"
],
"properties": {
"name": {
"type": "string"
},
"rows": {
"type": "number"
},
"sheet": {
"type": [
"string",
"null"
]
},
"header_row": {
"type": "number"
}
},
"additionalProperties": false
}
},
"additionalProperties": false
},
"notes": {
"type": "array",
"items": {
"type": "string"
}
},
"counts": {
"type": "object",
"required": [
"changed_rows",
"changed_cells",
"added_rows",
"removed_rows",
"key_changes",
"unchanged_rows",
"old_rows",
"new_rows"
],
"properties": {
"new_rows": {
"type": "number"
},
"old_rows": {
"type": "number"
},
"added_rows": {
"type": "number"
},
"key_changes": {
"type": "number"
},
"changed_rows": {
"type": "number"
},
"removed_rows": {
"type": "number"
},
"changed_cells": {
"type": "number"
},
"unchanged_rows": {
"type": "number"
}
},
"additionalProperties": false
},
"columns": {
"type": "object",
"required": [
"compared",
"added",
"removed",
"renamed",
"moved",
"ignored"
],
"properties": {
"more": {
"type": "object",
"propertyNames": {
"type": "string"
},
"additionalProperties": {
"type": "number"
}
},
"added": {
"type": "array",
"items": {
"type": "string"
}
},
"moved": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"from",
"to"
],
"properties": {
"to": {
"type": "string"
},
"from": {
"type": "string"
},
"name": {
"type": "string"
}
},
"additionalProperties": false
}
},
"ignored": {
"type": "array",
"items": {
"type": "string"
}
},
"removed": {
"type": "array",
"items": {
"type": "string"
}
},
"renamed": {
"type": "array",
"items": {
"type": "object",
"required": [
"from",
"to",
"agreement_pct"
],
"properties": {
"to": {
"type": "string"
},
"from": {
"type": "string"
},
"agreement_pct": {
"type": [
"number",
"null"
]
}
},
"additionalProperties": false
}
},
"compared": {
"type": "number"
}
},
"additionalProperties": false
},
"by_column": {
"type": "array",
"items": {
"type": "object",
"required": [
"column",
"changed",
"increases",
"decreases",
"total_delta",
"avg_pct",
"max_increase",
"max_decrease"
],
"properties": {
"column": {
"type": "string"
},
"avg_pct": {
"type": [
"number",
"null"
]
},
"changed": {
"type": "number"
},
"decreases": {
"type": "number"
},
"increases": {
"type": "number"
},
"total_delta": {
"type": [
"number",
"null"
]
},
"max_decrease": {
"anyOf": [
{
"type": "object",
"required": [
"key",
"old",
"new",
"delta",
"pct"
],
"properties": {
"key": {
"type": "string"
},
"new": {
"type": "string"
},
"old": {
"type": "string"
},
"pct": {
"type": [
"number",
"null"
]
},
"delta": {
"type": "number"
}
},
"additionalProperties": false
},
{
"type": "null"
}
]
},
"max_increase": {
"anyOf": [
{
"type": "object",
"required": [
"key",
"old",
"new",
"delta",
"pct"
],
"properties": {
"key": {
"type": "string"
},
"new": {
"type": "string"
},
"old": {
"type": "string"
},
"pct": {
"type": [
"number",
"null"
]
},
"delta": {
"type": "number"
}
},
"additionalProperties": false
},
{
"type": "null"
}
]
}
},
"additionalProperties": false
}
},
"downloads": {
"type": "object",
"required": [
"xlsx",
"csv"
],
"properties": {
"csv": {
"type": "string"
},
"xlsx": {
"type": "string"
}
},
"additionalProperties": false
},
"added_preview": {
"type": "array",
"items": {
"type": "string"
}
},
"complete_list": {
"type": "string"
},
"excluded_rows": {
"type": "array",
"items": {
"type": "object",
"required": [
"file",
"row",
"reason",
"label"
],
"properties": {
"row": {
"type": "number"
},
"file": {
"type": "string"
},
"label": {
"type": "string"
},
"reason": {
"type": "string"
}
},
"additionalProperties": false
}
},
"biggest_changes": {
"type": "array",
"items": {
"type": "object",
"required": [
"key",
"old",
"new",
"delta",
"pct",
"column"
],
"properties": {
"key": {
"type": "string"
},
"new": {
"type": "string"
},
"old": {
"type": "string"
},
"pct": {
"type": [
"number",
"null"
]
},
"delta": {
"type": "number"
},
"column": {
"type": "string"
}
},
"additionalProperties": false
}
},
"changes_preview": {
"type": "array",
"items": {
"type": "object",
"required": [
"key",
"old_row",
"new_row",
"cells"
],
"properties": {
"key": {
"type": "string"
},
"cells": {
"type": "array",
"items": {
"type": "object",
"required": [
"column",
"old",
"new",
"delta",
"pct"
],
"properties": {
"new": {
"type": "string"
},
"old": {
"type": "string"
},
"pct": {
"type": [
"number",
"null"
]
},
"unit": {
"type": "string",
"const": "pp",
"description": "pp: delta is in percentage points (percent columns)"
},
"delta": {
"type": [
"number",
"null"
]
},
"column": {
"type": "string"
}
},
"additionalProperties": false
}
},
"new_row": {
"type": "number"
},
"old_row": {
"type": "number"
}
},
"additionalProperties": false
}
},
"removed_preview": {
"type": "array",
"items": {
"type": "string"
}
},
"key_changes_preview": {
"type": "array",
"items": {
"type": "object",
"required": [
"from",
"to"
],
"properties": {
"to": {
"type": "string"
},
"from": {
"type": "string"
}
},
"additionalProperties": false
}
}
},
"additionalProperties": false
},
"annotations": {
"title": "Compare spreadsheets",
"readOnlyHint": true,
"openWorldHint": false,
"destructiveHint": false
}
}Use this when the user has two versions of a spreadsheet and wants a summary rather than a full list: "how many prices went up", "which columns changed the most", "biggest changes between these two files", "average price increase". Returns counts (changed, added, removed rows), per-column statistics (cells changed, increases, decreases, total and average percent change, largest increase and decrease) and the biggest single changes, with the same Excel and CSV downloads. Use compare_spreadsheets for the row-by-row list. Does not forecast or explain why values changed.
| Parameter | Type | Description |
|---|---|---|
| new_file | object | The NEWER version (CSV, TSV or Excel .xlsx), e.g. pricelist_2026Q4.xlsx or roster-october.csv. |
| old_file | object | The OLDER version (CSV, TSV or Excel .xlsx), e.g. pricelist_2026Q3.xlsx or roster-september.csv. |
| new_sheet | string | Sheet (tab) to read from the new workbook, e.g. Prices Q4. |
| new_table | string | Instead of new_file: the newer version pasted as CSV/TSV text with a header row, e.g. "SKU,Price\nA1,10.50\nC3,7.00". |
| old_sheet | string | Sheet (tab) to read from the old workbook, e.g. Prices Q3. Default: the sheet with the same name as in the new workbook, else the first sheet with data. |
| old_table | string | Instead of old_file: the older version pasted as CSV/TSV text with a header row, e.g. "SKU,Price\nA1,10.00\nB2,5.00". |
| column_map | object | Old column name -> new column name for renamed columns, e.g. {"Unit Price": "Price (USD)"}. Turns off automatic rename detection. |
| ignore_case | boolean | Treat ABC and abc as equal, e.g. true. Default false. |
| key_columns | array | Column(s) that identify a row, to override the automatic key, e.g. ["SKU"] or ["Store", "Product code"]. |
| header_row_new | integer | Row number of the column headings in the new file, e.g. 3. |
| header_row_old | integer | Row number of the column headings in the old file when it is not detected, e.g. 3 when two title rows come first. |
| ignore_columns | array | Columns to leave out of the comparison, e.g. ["Last updated", "Notes"]. |
| normalize_dates | boolean | Compare dates by calendar day, so 2026-03-05, 3/5/2026 and an Excel date serial are equal, e.g. true (default). |
| trim_whitespace | boolean | Ignore leading/trailing and repeated spaces, e.g. true (default). |
| numeric_tolerance | number | Numbers that differ by this much or less count as equal, e.g. 0.01 to ignore rounding by a cent. Default 0. |
| detect_key_changes | boolean | Report a removed row and an added row whose other values are identical as one key change (e.g. a SKU renumbered), e.g. true (default). |
| compare_row_numbers | boolean | Compare a running row-number column (#, Row, No.: 1, 2, 3...) like any other column, e.g. true. Default false: it shifts whenever a row is inserted, so it is skipped with a note. |
| compare_numbers_as_values | boolean | Compare numbers by value so "1,200.00" equals 1200, e.g. true (default). Codes with leading zeros (00123) stay text. |
{
"name": "summarize_changes",
"title": "Summarize changes",
"description": "Use this when the user has two versions of a spreadsheet and wants a summary rather than a full list: \"how many prices went up\", \"which columns changed the most\", \"biggest changes between these two files\", \"average price increase\". Returns counts (changed, added, removed rows), per-column statistics (cells changed, increases, decreases, total and average percent change, largest increase and decrease) and the biggest single changes, with the same Excel and CSV downloads. Use compare_spreadsheets for the row-by-row list. Does not forecast or explain why values changed.",
"inputSchema": {
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"properties": {
"new_file": {
"type": "object",
"required": [
"download_url",
"file_id"
],
"properties": {
"file_id": {
"type": "string",
"description": "ChatGPT file id, e.g. file_abc123."
},
"file_name": {
"type": "string",
"description": "Original file name if known, e.g. statement.pdf."
},
"mime_type": {
"type": "string",
"description": "Media type if known, e.g. application/pdf."
},
"download_url": {
"type": "string",
"description": "Temporary download link for the file, supplied by ChatGPT."
}
},
"description": "The NEWER version (CSV, TSV or Excel .xlsx), e.g. pricelist_2026Q4.xlsx or roster-october.csv."
},
"old_file": {
"type": "object",
"required": [
"download_url",
"file_id"
],
"properties": {
"file_id": {
"type": "string",
"description": "ChatGPT file id, e.g. file_abc123."
},
"file_name": {
"type": "string",
"description": "Original file name if known, e.g. statement.pdf."
},
"mime_type": {
"type": "string",
"description": "Media type if known, e.g. application/pdf."
},
"download_url": {
"type": "string",
"description": "Temporary download link for the file, supplied by ChatGPT."
}
},
"description": "The OLDER version (CSV, TSV or Excel .xlsx), e.g. pricelist_2026Q3.xlsx or roster-september.csv."
},
"new_sheet": {
"type": "string",
"maxLength": 100,
"description": "Sheet (tab) to read from the new workbook, e.g. Prices Q4."
},
"new_table": {
"type": "string",
"maxLength": 200000,
"description": "Instead of new_file: the newer version pasted as CSV/TSV text with a header row, e.g. \"SKU,Price\\nA1,10.50\\nC3,7.00\"."
},
"old_sheet": {
"type": "string",
"maxLength": 100,
"description": "Sheet (tab) to read from the old workbook, e.g. Prices Q3. Default: the sheet with the same name as in the new workbook, else the first sheet with data."
},
"old_table": {
"type": "string",
"maxLength": 200000,
"description": "Instead of old_file: the older version pasted as CSV/TSV text with a header row, e.g. \"SKU,Price\\nA1,10.00\\nB2,5.00\"."
},
"column_map": {
"type": "object",
"description": "Old column name -> new column name for renamed columns, e.g. {\"Unit Price\": \"Price (USD)\"}. Turns off automatic rename detection.",
"propertyNames": {
"type": "string",
"maxLength": 100
},
"additionalProperties": {
"type": "string",
"maxLength": 100
}
},
"ignore_case": {
"type": "boolean",
"description": "Treat ABC and abc as equal, e.g. true. Default false."
},
"key_columns": {
"type": "array",
"items": {
"type": "string",
"maxLength": 100
},
"maxItems": 5,
"description": "Column(s) that identify a row, to override the automatic key, e.g. [\"SKU\"] or [\"Store\", \"Product code\"]."
},
"header_row_new": {
"type": "integer",
"maximum": 1000,
"minimum": 1,
"description": "Row number of the column headings in the new file, e.g. 3."
},
"header_row_old": {
"type": "integer",
"maximum": 1000,
"minimum": 1,
"description": "Row number of the column headings in the old file when it is not detected, e.g. 3 when two title rows come first."
},
"ignore_columns": {
"type": "array",
"items": {
"type": "string",
"maxLength": 100
},
"maxItems": 50,
"description": "Columns to leave out of the comparison, e.g. [\"Last updated\", \"Notes\"]."
},
"normalize_dates": {
"type": "boolean",
"description": "Compare dates by calendar day, so 2026-03-05, 3/5/2026 and an Excel date serial are equal, e.g. true (default)."
},
"trim_whitespace": {
"type": "boolean",
"description": "Ignore leading/trailing and repeated spaces, e.g. true (default)."
},
"numeric_tolerance": {
"type": "number",
"maximum": 1000000000,
"minimum": 0,
"description": "Numbers that differ by this much or less count as equal, e.g. 0.01 to ignore rounding by a cent. Default 0."
},
"detect_key_changes": {
"type": "boolean",
"description": "Report a removed row and an added row whose other values are identical as one key change (e.g. a SKU renumbered), e.g. true (default)."
},
"compare_row_numbers": {
"type": "boolean",
"description": "Compare a running row-number column (#, Row, No.: 1, 2, 3...) like any other column, e.g. true. Default false: it shifts whenever a row is inserted, so it is skipped with a note."
},
"compare_numbers_as_values": {
"type": "boolean",
"description": "Compare numbers by value so \"1,200.00\" equals 1200, e.g. true (default). Codes with leading zeros (00123) stay text."
}
}
},
"outputSchema": {
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"required": [
"files",
"key",
"counts",
"columns",
"by_column",
"biggest_changes",
"changes_preview",
"added_preview",
"removed_preview",
"key_changes_preview",
"excluded_rows",
"notes",
"downloads",
"complete_list"
],
"properties": {
"key": {
"type": "object",
"required": [
"mode",
"columns",
"explanation"
],
"properties": {
"mode": {
"enum": [
"key",
"content"
],
"type": "string"
},
"columns": {
"type": "array",
"items": {
"type": "string"
}
},
"explanation": {
"type": "string"
},
"repeated_keys": {
"type": "array",
"items": {
"type": "string"
}
}
},
"additionalProperties": false
},
"files": {
"type": "object",
"required": [
"old",
"new"
],
"properties": {
"new": {
"type": "object",
"required": [
"name",
"sheet",
"rows",
"header_row"
],
"properties": {
"name": {
"type": "string"
},
"rows": {
"type": "number"
},
"sheet": {
"type": [
"string",
"null"
]
},
"header_row": {
"type": "number"
}
},
"additionalProperties": false
},
"old": {
"type": "object",
"required": [
"name",
"sheet",
"rows",
"header_row"
],
"properties": {
"name": {
"type": "string"
},
"rows": {
"type": "number"
},
"sheet": {
"type": [
"string",
"null"
]
},
"header_row": {
"type": "number"
}
},
"additionalProperties": false
}
},
"additionalProperties": false
},
"notes": {
"type": "array",
"items": {
"type": "string"
}
},
"counts": {
"type": "object",
"required": [
"changed_rows",
"changed_cells",
"added_rows",
"removed_rows",
"key_changes",
"unchanged_rows",
"old_rows",
"new_rows"
],
"properties": {
"new_rows": {
"type": "number"
},
"old_rows": {
"type": "number"
},
"added_rows": {
"type": "number"
},
"key_changes": {
"type": "number"
},
"changed_rows": {
"type": "number"
},
"removed_rows": {
"type": "number"
},
"changed_cells": {
"type": "number"
},
"unchanged_rows": {
"type": "number"
}
},
"additionalProperties": false
},
"columns": {
"type": "object",
"required": [
"compared",
"added",
"removed",
"renamed",
"moved",
"ignored"
],
"properties": {
"more": {
"type": "object",
"propertyNames": {
"type": "string"
},
"additionalProperties": {
"type": "number"
}
},
"added": {
"type": "array",
"items": {
"type": "string"
}
},
"moved": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"from",
"to"
],
"properties": {
"to": {
"type": "string"
},
"from": {
"type": "string"
},
"name": {
"type": "string"
}
},
"additionalProperties": false
}
},
"ignored": {
"type": "array",
"items": {
"type": "string"
}
},
"removed": {
"type": "array",
"items": {
"type": "string"
}
},
"renamed": {
"type": "array",
"items": {
"type": "object",
"required": [
"from",
"to",
"agreement_pct"
],
"properties": {
"to": {
"type": "string"
},
"from": {
"type": "string"
},
"agreement_pct": {
"type": [
"number",
"null"
]
}
},
"additionalProperties": false
}
},
"compared": {
"type": "number"
}
},
"additionalProperties": false
},
"by_column": {
"type": "array",
"items": {
"type": "object",
"required": [
"column",
"changed",
"increases",
"decreases",
"total_delta",
"avg_pct",
"max_increase",
"max_decrease"
],
"properties": {
"column": {
"type": "string"
},
"avg_pct": {
"type": [
"number",
"null"
]
},
"changed": {
"type": "number"
},
"decreases": {
"type": "number"
},
"increases": {
"type": "number"
},
"total_delta": {
"type": [
"number",
"null"
]
},
"max_decrease": {
"anyOf": [
{
"type": "object",
"required": [
"key",
"old",
"new",
"delta",
"pct"
],
"properties": {
"key": {
"type": "string"
},
"new": {
"type": "string"
},
"old": {
"type": "string"
},
"pct": {
"type": [
"number",
"null"
]
},
"delta": {
"type": "number"
}
},
"additionalProperties": false
},
{
"type": "null"
}
]
},
"max_increase": {
"anyOf": [
{
"type": "object",
"required": [
"key",
"old",
"new",
"delta",
"pct"
],
"properties": {
"key": {
"type": "string"
},
"new": {
"type": "string"
},
"old": {
"type": "string"
},
"pct": {
"type": [
"number",
"null"
]
},
"delta": {
"type": "number"
}
},
"additionalProperties": false
},
{
"type": "null"
}
]
}
},
"additionalProperties": false
}
},
"downloads": {
"type": "object",
"required": [
"xlsx",
"csv"
],
"properties": {
"csv": {
"type": "string"
},
"xlsx": {
"type": "string"
}
},
"additionalProperties": false
},
"added_preview": {
"type": "array",
"items": {
"type": "string"
}
},
"complete_list": {
"type": "string"
},
"excluded_rows": {
"type": "array",
"items": {
"type": "object",
"required": [
"file",
"row",
"reason",
"label"
],
"properties": {
"row": {
"type": "number"
},
"file": {
"type": "string"
},
"label": {
"type": "string"
},
"reason": {
"type": "string"
}
},
"additionalProperties": false
}
},
"biggest_changes": {
"type": "array",
"items": {
"type": "object",
"required": [
"key",
"old",
"new",
"delta",
"pct",
"column"
],
"properties": {
"key": {
"type": "string"
},
"new": {
"type": "string"
},
"old": {
"type": "string"
},
"pct": {
"type": [
"number",
"null"
]
},
"delta": {
"type": "number"
},
"column": {
"type": "string"
}
},
"additionalProperties": false
}
},
"changes_preview": {
"type": "array",
"items": {
"type": "object",
"required": [
"key",
"old_row",
"new_row",
"cells"
],
"properties": {
"key": {
"type": "string"
},
"cells": {
"type": "array",
"items": {
"type": "object",
"required": [
"column",
"old",
"new",
"delta",
"pct"
],
"properties": {
"new": {
"type": "string"
},
"old": {
"type": "string"
},
"pct": {
"type": [
"number",
"null"
]
},
"unit": {
"type": "string",
"const": "pp",
"description": "pp: delta is in percentage points (percent columns)"
},
"delta": {
"type": [
"number",
"null"
]
},
"column": {
"type": "string"
}
},
"additionalProperties": false
}
},
"new_row": {
"type": "number"
},
"old_row": {
"type": "number"
}
},
"additionalProperties": false
}
},
"removed_preview": {
"type": "array",
"items": {
"type": "string"
}
},
"key_changes_preview": {
"type": "array",
"items": {
"type": "object",
"required": [
"from",
"to"
],
"properties": {
"to": {
"type": "string"
},
"from": {
"type": "string"
}
},
"additionalProperties": false
}
}
},
"additionalProperties": false
},
"annotations": {
"title": "Summarize changes",
"readOnlyHint": true,
"openWorldHint": false,
"destructiveHint": false
}
}Compares two versions of a spreadsheet. Use compare_spreadsheets to list all added, removed and changed rows; use summarize_changes for counts and the biggest changes by column. Give the user the download links: the full change set is in the files.
Names, descriptions and schemas were written by the server and are shown as data.
Shared addresses on big platforms (Cloudflare, Vercel and the like) put unrelated servers together; those are marked shared_infrastructure. A match is a pivot, not a link between operators.