Skip to main content
Glama

Zovo Spreadsheet Compare

Server Details

Compare two spreadsheets

If you are the author of this connector, you can claim ownership by verifying the domain or GitHub account it belongs to. Claimed connector authors can inspect health checks, view analytics, and manage their listing.
Status
Healthy
Last Tested
Transport
Streamable HTTP · MCP 2025-11-25
URL

TDQS

Score is being calculated.

Available Tools

2 tools
compare_spreadsheetsCompare spreadsheets
Read-only
Inspect

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.

ParametersJSON Schema
NameRequiredDescriptionDefault
new_fileNoThe NEWER version (CSV, TSV or Excel .xlsx), e.g. pricelist_2026Q4.xlsx or roster-october.csv.
old_fileNoThe OLDER version (CSV, TSV or Excel .xlsx), e.g. pricelist_2026Q3.xlsx or roster-september.csv.
new_sheetNoSheet (tab) to read from the new workbook, e.g. Prices Q4.
new_tableNoInstead 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_sheetNoSheet (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_tableNoInstead 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_mapNoOld column name -> new column name for renamed columns, e.g. {"Unit Price": "Price (USD)"}. Turns off automatic rename detection.
ignore_caseNoTreat ABC and abc as equal, e.g. true. Default false.
key_columnsNoColumn(s) that identify a row, to override the automatic key, e.g. ["SKU"] or ["Store", "Product code"].
header_row_newNoRow number of the column headings in the new file, e.g. 3.
header_row_oldNoRow number of the column headings in the old file when it is not detected, e.g. 3 when two title rows come first.
ignore_columnsNoColumns to leave out of the comparison, e.g. ["Last updated", "Notes"].
normalize_datesNoCompare dates by calendar day, so 2026-03-05, 3/5/2026 and an Excel date serial are equal, e.g. true (default).
trim_whitespaceNoIgnore leading/trailing and repeated spaces, e.g. true (default).
numeric_toleranceNoNumbers that differ by this much or less count as equal, e.g. 0.01 to ignore rounding by a cent. Default 0.
detect_key_changesNoReport 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_numbersNoCompare 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_valuesNoCompare numbers by value so "1,200.00" equals 1200, e.g. true (default). Codes with leading zeros (00123) stay text.

Output Schema

ParametersJSON Schema
NameRequiredDescription
keyYes
filesYes
notesYes
countsYes
columnsYes
by_columnYes
downloadsYes
added_previewYes
complete_listYes
excluded_rowsYes
biggest_changesYes
changes_previewYes
removed_previewYes
key_changes_previewYes
summarize_changesSummarize changes
Read-only
Inspect

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.

ParametersJSON Schema
NameRequiredDescriptionDefault
new_fileNoThe NEWER version (CSV, TSV or Excel .xlsx), e.g. pricelist_2026Q4.xlsx or roster-october.csv.
old_fileNoThe OLDER version (CSV, TSV or Excel .xlsx), e.g. pricelist_2026Q3.xlsx or roster-september.csv.
new_sheetNoSheet (tab) to read from the new workbook, e.g. Prices Q4.
new_tableNoInstead 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_sheetNoSheet (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_tableNoInstead 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_mapNoOld column name -> new column name for renamed columns, e.g. {"Unit Price": "Price (USD)"}. Turns off automatic rename detection.
ignore_caseNoTreat ABC and abc as equal, e.g. true. Default false.
key_columnsNoColumn(s) that identify a row, to override the automatic key, e.g. ["SKU"] or ["Store", "Product code"].
header_row_newNoRow number of the column headings in the new file, e.g. 3.
header_row_oldNoRow number of the column headings in the old file when it is not detected, e.g. 3 when two title rows come first.
ignore_columnsNoColumns to leave out of the comparison, e.g. ["Last updated", "Notes"].
normalize_datesNoCompare dates by calendar day, so 2026-03-05, 3/5/2026 and an Excel date serial are equal, e.g. true (default).
trim_whitespaceNoIgnore leading/trailing and repeated spaces, e.g. true (default).
numeric_toleranceNoNumbers that differ by this much or less count as equal, e.g. 0.01 to ignore rounding by a cent. Default 0.
detect_key_changesNoReport 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_numbersNoCompare 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_valuesNoCompare numbers by value so "1,200.00" equals 1200, e.g. true (default). Codes with leading zeros (00123) stay text.

Output Schema

ParametersJSON Schema
NameRequiredDescription
keyYes
filesYes
notesYes
countsYes
columnsYes
by_columnYes
downloadsYes
added_previewYes
complete_listYes
excluded_rowsYes
biggest_changesYes
changes_previewYes
removed_previewYes
key_changes_previewYes

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

  1. 2 tool updates
    • First observedcompare_spreadsheets
    • First observedsummarize_changes

Related MCP Connectors

Related MCP Servers

  • A
    license
    A
    quality
    A
    maintenance
    50 tools and 400 functions for working with Excel/.xlsx spreadsheets — read/write, recalculate formulas, diff, repair broken references, and audit. Built for AI agents.
    50
    3,303 npm
    6
    MIT
  • F
    license
    A
    quality
    D
    maintenance
    模糊匹配两份表格中的公司名称和日期,输出已匹配、待复核和未匹配三种结果,便于数据对账。
    1
    -
  • A
    license
    Not graded
    quality
    B
    maintenance
    Enables agents to diff inventory snapshots from CSV files or live Shopify stores, surfacing SKU mismatches, oversell risks, blank-vs-zero issues, barcode conflicts, and sync health, with data processed locally.
    17 npm
    MIT
Try in Browser

Glama MCP Gateway

Add one secure layer between your agents and this server.

Resources