Zovo Spreadsheet Merge MCP
MCP server that joins two CSV or Excel files on a key column, cleaning keys for spaces, case, leading zeros, and Excel number formats. It supports left, inner, and full joins, detects keys automatically, and can stack up to 24 monthly exports with drifting columns into one table.
Endpoint and access
No sign-in to connect and list tools. Individual tools may still need a vendor account, credentials, or permissions; check the documented prerequisites.
MCP endpoint (Streamable HTTP)
https://sheet-join.zovo.one/mcpWhat you can do with it
- Merge orders.csv with customers.xlsx on customer ID
- Combine 12 monthly exports into one sheet with changing column names
- VLOOKUP two spreadsheets where some IDs have leading zeros
Source and maintenance
Community listingRegistry 1.0.1
Protocol and capabilities
- Server
- sheet-join 1.0.1
- MCP protocol
- 2025-06-18
- Tools
- 2 advertised
- Resources
- 1 advertised
- Resource templates
- 1 advertised
- Prompts
- Not advertised
Server-advertised capabilities
{
"tools": {
"listChanged": true
},
"resources": {
"listChanged": true
}
}Server-provided instructions
Untrusted server output shown for inspection. It is not Koskamo guidance and is excluded from knowledge search.
Tools
2 advertised
join_spreadsheets — Join two spreadsheets
Advertised read-only
Use this when the user wants to merge, match or VLOOKUP two spreadsheets on a shared ID column: "vlookup two spreadsheets", "merge two excel files by customer ID", "match orders to customers", "why are some rows not matching", "find which IDs are missing from the other file". Attach both files (CSV, TSV or .xlsx; or one workbook with two sheets) or paste both tables. Left join by default (all left rows kept); inner and full joins are available. Auto-detects the key column and explains why (override with left_key/right_key, or give a composite key). Key clean-ups are applied in order and each is counted: spaces, case, look-alike characters, Excel number formats (12345.0, 1.2345E+05), separators, leading zeros (C00123 = C123), letter prefix used by one file only; turn any off with skip_normalizations. Reports unmatched rows on both sides with a likely reason and closest key, duplicate keys with fan-out counts, and returns an Excel workbook (Merged, Unmatched left, Unmatched right, Duplicates, Summary) plus a merged CSV. Does not do mail merge (letters, labels, emails), does not compare two versions of one file cell by cell, and does not edit the original files.
join_spreadsheets input schema
{
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"properties": {
"left_key": {
"anyOf": [
{
"type": "string",
"maxLength": 120
},
{
"type": "array",
"items": {
"type": "string",
"maxLength": 120
},
"maxItems": 4,
"minItems": 1
}
],
"description": "Key column name(s) in the left file; leave out to auto-detect. Use a list for a composite key, e.g. \"customer_id\" or [\"First Name\",\"Last Name\"]."
},
"join_type": {
"enum": [
"left",
"inner",
"full"
],
"type": "string",
"description": "left (default, like VLOOKUP): keep every left row and add matching right columns. inner: only rows found in both. full: everything from both files, matched where possible. Example: left."
},
"left_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 main file whose rows you keep (CSV, TSV or .xlsx), e.g. orders.csv. A workbook with two sheets can be passed alone: sheet 1 is joined to sheet 2."
},
"right_key": {
"anyOf": [
{
"type": "string",
"maxLength": 120
},
{
"type": "array",
"items": {
"type": "string",
"maxLength": 120
},
"maxItems": 4,
"minItems": 1
}
],
"description": "Key column name(s) in the right file; leave out to auto-detect. Use a list for a composite key, e.g. \"Customer ID\" or [\"First Name\",\"Last Name\"]."
},
"duplicates": {
"enum": [
"all",
"first"
],
"type": "string",
"description": "When a key appears more than once in the right file: all (default) keeps every match and warns about the extra rows; first keeps only the first match, like VLOOKUP. Example: first."
},
"left_sheet": {
"type": "string",
"maxLength": 100,
"description": "Sheet name in the left workbook, e.g. Orders. Default: the first sheet with data."
},
"left_table": {
"type": "string",
"maxLength": 400000,
"description": "Only when no file is attached: the left (main) table pasted as CSV or tab-separated text with a header row, e.g. \"order_id,customer_id,amount\\nSO-1,C123,40.00\"."
},
"right_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 lookup file whose columns are added (CSV, TSV or .xlsx), e.g. customers.xlsx."
},
"right_sheet": {
"type": "string",
"maxLength": 100,
"description": "Sheet name in the right workbook, e.g. Customers. Default: the first sheet with data (or the second sheet when both tables are in one workbook)."
},
"right_table": {
"type": "string",
"maxLength": 400000,
"description": "Only when no file is attached: the right (lookup) table pasted as CSV or tab-separated text with a header row, e.g. \"customer_id,name\\nC00123,Acme Supply\"."
},
"left_header_row": {
"type": "integer",
"maximum": 1000,
"minimum": 1,
"description": "Only if the headings were detected wrongly: the row number of the left file's header (counting non-blank rows in a CSV, sheet rows in Excel), e.g. 4."
},
"right_header_row": {
"type": "integer",
"maximum": 1000,
"minimum": 1,
"description": "Only if the headings were detected wrongly: the row number of the right file's header, e.g. 3."
},
"skip_normalizations": {
"type": "array",
"items": {
"enum": [
"trim",
"case",
"unicode",
"excel",
"separators",
"zeros",
"prefix"
],
"type": "string"
},
"maxItems": 7,
"description": "Key clean-ups to turn OFF when IDs that differ only that way are really different, e.g. [\"case\"] for case-sensitive IDs or [\"zeros\"] when 0123 and 123 are different codes. Options: trim, case, unicode, excel, separators, zeros, prefix."
}
}
}join_spreadsheets output schema
{
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"required": [
"left",
"right",
"key_choice",
"join_type",
"match",
"normalizations",
"turned_off",
"would_match_if_on",
"prefix_rule",
"unmatched_reasons",
"unmatched_preview",
"duplicates",
"excluded",
"warnings",
"downloads",
"note"
],
"properties": {
"left": {
"type": "object",
"required": [
"file",
"rows",
"key",
"excluded_rows"
],
"properties": {
"key": {
"type": "array",
"items": {
"type": "string"
}
},
"file": {
"type": "string"
},
"rows": {
"type": "number"
},
"excluded_rows": {
"type": "number"
}
},
"additionalProperties": false
},
"note": {
"type": "string"
},
"match": {
"type": "object",
"required": [
"left_matched",
"left_unmatched",
"match_rate_pct",
"right_used",
"right_unused",
"merged_rows",
"ambiguous",
"blank_keys"
],
"properties": {
"ambiguous": {
"type": "number"
},
"blank_keys": {
"type": "number"
},
"right_used": {
"type": "number"
},
"merged_rows": {
"type": "number"
},
"left_matched": {
"type": "number"
},
"right_unused": {
"type": "number"
},
"left_unmatched": {
"type": "number"
},
"match_rate_pct": {
"type": "number"
}
},
"additionalProperties": false
},
"right": {
"type": "object",
"required": [
"file",
"rows",
"key",
"excluded_rows"
],
"properties": {
"key": {
"type": "array",
"items": {
"type": "string"
}
},
"file": {
"type": "string"
},
"rows": {
"type": "number"
},
"excluded_rows": {
"type": "number"
}
},
"additionalProperties": false
},
"excluded": {
"type": "array",
"items": {
"type": "string"
}
},
"warnings": {
"type": "array",
"items": {
"type": "string"
}
},
"downloads": {
"type": "object",
"required": [
"xlsx",
"csv"
],
"properties": {
"csv": {
"type": "string"
},
"xlsx": {
"type": "string"
}
},
"additionalProperties": false
},
"join_type": {
"type": "string"
},
"duplicates": {
"type": "object",
"required": [
"right_keys",
"left_rows_fanned_out",
"extra_rows",
"many_to_many_keys",
"capped",
"top"
],
"properties": {
"top": {
"type": "array",
"items": {
"type": "object",
"required": [
"key",
"rows",
"extra_rows"
],
"properties": {
"key": {
"type": "string"
},
"rows": {
"type": "number"
},
"extra_rows": {
"type": "number"
}
},
"additionalProperties": false
}
},
"capped": {
"type": "boolean"
},
"extra_rows": {
"type": "number"
},
"right_keys": {
"type": "number"
},
"many_to_many_keys": {
"type": "number"
},
"left_rows_fanned_out": {
"type": "number"
}
},
"additionalProperties": false
},
"key_choice": {
"type": "object",
"required": [
"how",
"explanation",
"alternatives"
],
"properties": {
"how": {
"type": "string"
},
"explanation": {
"type": "string"
},
"alternatives": {
"type": "array",
"items": {
"type": "string"
}
}
},
"additionalProperties": false
},
"turned_off": {
"type": "array",
"items": {
"type": "string"
}
},
"prefix_rule": {
"type": [
"string",
"null"
]
},
"normalizations": {
"type": "array",
"items": {
"type": "object",
"required": [
"step",
"label",
"rows",
"examples"
],
"properties": {
"rows": {
"type": "number"
},
"step": {
"type": "string"
},
"label": {
"type": "string"
},
"examples": {
"type": "array",
"items": {
"type": "string"
}
}
},
"additionalProperties": false
}
},
"unmatched_preview": {
"type": "array",
"items": {
"type": "object",
"required": [
"row",
"key",
"reason",
"suggestion"
],
"properties": {
"key": {
"type": "string"
},
"row": {
"type": "number"
},
"reason": {
"type": "string"
},
"suggestion": {
"type": [
"string",
"null"
]
}
},
"additionalProperties": false
}
},
"unmatched_reasons": {
"type": "array",
"items": {
"type": "object",
"required": [
"reason",
"count"
],
"properties": {
"count": {
"type": "number"
},
"reason": {
"type": "string"
}
},
"additionalProperties": false
}
},
"would_match_if_on": {
"type": "array",
"items": {
"type": "object",
"required": [
"step",
"rows"
],
"properties": {
"rows": {
"type": "number"
},
"step": {
"type": "string"
}
},
"additionalProperties": false
}
}
},
"additionalProperties": false
}join_spreadsheets annotations
{
"title": "Join two spreadsheets",
"readOnlyHint": true,
"openWorldHint": false,
"destructiveHint": false
}combine_spreadsheets — Combine spreadsheets
Advertised read-only
Use this when the user wants to stack or append many spreadsheets into one: "combine multiple csv files into one", "merge 12 monthly excel files", "combine excel files with different column names", "append these exports into one sheet", "combine all sheets into one". Takes 1 to 24 CSV, TSV or .xlsx files (or pasted tables). Aligns columns by identical name, then same name with different case or spacing, then a synonym table (Amt = Amount, Txn Date = Date, Memo = Description), then fuzzy spelling matches that are listed for confirmation; a specific column is not folded into a more general one (Spouse First Name stays separate from First Name). Adds a Source file column, decides day/month order once per file, reads EU number formats, removes total rows and repeated headers (listed), and reports each column decision. Returns an Excel workbook (Combined, Column mapping, Files, Excluded rows, Summary) and a CSV. Does not join files side by side on an ID (use join_spreadsheets) and does not do mail merge.
combine_spreadsheets input schema
{
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"properties": {
"files": {
"type": "array",
"items": {
"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."
}
}
},
"maxItems": 24,
"minItems": 1,
"description": "The spreadsheets to stack, 1 to 24 CSV, TSV or .xlsx files in order, e.g. jan.csv, feb.csv, mar.csv. One workbook alone stacks all of its sheets."
},
"tables": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"csv"
],
"properties": {
"csv": {
"type": "string",
"maxLength": 200000,
"description": "The table as CSV or tab-separated text with a header row, e.g. \"Date,Amount\\n01/05/2025,12.50\"."
},
"name": {
"type": "string",
"maxLength": 80,
"description": "A label for this table, e.g. January."
}
}
},
"maxItems": 24,
"minItems": 1,
"description": "Only when no files are attached: pasted tables to stack, e.g. [{\"name\":\"Jan\",\"csv\":\"Date,Amt\\n1/5/2025,12.50\"}]."
},
"all_sheets": {
"type": "boolean",
"description": "Stack every sheet of each workbook instead of only the first sheet with data. Default: true when a single workbook is given, otherwise false."
},
"column_map": {
"type": "object",
"description": "Your column decisions: source header -> output column, e.g. {\"Amt\":\"Amount\",\"Txn Date\":\"Date\"}. Overrides automatic matching.",
"propertyNames": {
"type": "string",
"maxLength": 80
},
"additionalProperties": {
"type": "string",
"maxLength": 80
}
},
"date_order": {
"enum": [
"auto",
"MDY",
"DMY"
],
"type": "string",
"description": "Day/month order for numeric dates: auto (default) decides once per file from the data and says when it had to assume US month/day; MDY or DMY forces it for all files. Example: DMY."
},
"header_row": {
"type": "integer",
"maximum": 1000,
"minimum": 1,
"description": "Only if the headings were detected wrongly: the header row number used for EVERY file (counting non-blank rows in a CSV, sheet rows in Excel), e.g. 4."
},
"unify_case": {
"type": "boolean",
"description": "Default true: in short category-style columns, spellings that differ only by case (Revenue vs revenue) become the spelling seen first (first file wins); each change is listed. false keeps values as typed."
},
"remove_duplicate_rows": {
"type": "boolean",
"description": "Default false: rows identical in every column are counted and reported but kept. true drops the repeats (e.g. overlapping monthly exports)."
}
}
}combine_spreadsheets output schema
{
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"required": [
"tables",
"rows",
"columns",
"files",
"mapping_changes",
"mapping_changes_total",
"needs_confirmation",
"not_merged",
"value_fixes",
"excluded",
"duplicates",
"warnings",
"preview",
"downloads",
"note"
],
"properties": {
"note": {
"type": "string"
},
"rows": {
"type": "number"
},
"files": {
"type": "array",
"items": {
"type": "object",
"required": [
"file",
"rows",
"excluded",
"date_order",
"new_columns"
],
"properties": {
"file": {
"type": "string"
},
"rows": {
"type": "number"
},
"excluded": {
"type": "number"
},
"date_order": {
"type": [
"string",
"null"
]
},
"new_columns": {
"type": "array",
"items": {
"type": "string"
}
}
},
"additionalProperties": false
}
},
"tables": {
"type": "number"
},
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type",
"files"
],
"properties": {
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"files": {
"type": "number"
}
},
"additionalProperties": false
}
},
"preview": {
"type": "object",
"required": [
"header",
"rows"
],
"properties": {
"rows": {
"type": "array",
"items": {
"type": "array",
"items": {
"type": "string"
}
}
},
"header": {
"type": "array",
"items": {
"type": "string"
}
}
},
"additionalProperties": false
},
"excluded": {
"type": "object",
"required": [
"rows",
"examples"
],
"properties": {
"rows": {
"type": "number"
},
"examples": {
"type": "array",
"items": {
"type": "string"
}
}
},
"additionalProperties": false
},
"warnings": {
"type": "array",
"items": {
"type": "string"
}
},
"downloads": {
"type": "object",
"required": [
"xlsx",
"csv"
],
"properties": {
"csv": {
"type": "string"
},
"xlsx": {
"type": "string"
}
},
"additionalProperties": false
},
"duplicates": {
"type": "object",
"required": [
"rows",
"across_files",
"removed"
],
"properties": {
"rows": {
"type": "number"
},
"removed": {
"type": "number"
},
"across_files": {
"type": "number"
}
},
"additionalProperties": false
},
"not_merged": {
"type": "array",
"items": {
"type": "string"
}
},
"value_fixes": {
"type": "array",
"items": {
"type": "string"
}
},
"mapping_changes": {
"type": "array",
"items": {
"type": "object",
"required": [
"file",
"from",
"to",
"how"
],
"properties": {
"to": {
"type": "string"
},
"how": {
"type": "string"
},
"file": {
"type": "string"
},
"from": {
"type": "string"
}
},
"additionalProperties": false
}
},
"needs_confirmation": {
"type": "array",
"items": {
"type": "object",
"required": [
"file",
"from",
"to"
],
"properties": {
"to": {
"type": "string"
},
"file": {
"type": "string"
},
"from": {
"type": "string"
}
},
"additionalProperties": false
}
},
"mapping_changes_total": {
"type": "number"
}
},
"additionalProperties": false
}combine_spreadsheets annotations
{
"title": "Combine spreadsheets",
"readOnlyHint": true,
"openWorldHint": false,
"destructiveHint": false
}Prompts
Not advertised
Resources
1 advertised
sheet-join-widget — Zovo Spreadsheet Merge view
Interactive view for Zovo Spreadsheet Merge.
sheet-join-widget URI
ui://widget/sheet-join-v2-1.0.1-c7bf88ea575a0922b5744561f86914dfc2d74ee60e32640a25a2cb024aa2cc81.htmlsheet-join-widget-legacy — Zovo Spreadsheet Merge view (previous versions)
sheet-join-widget-legacy URI template
ui://widget/sheet-join-{version}.html30-day availability
Aggregated from read-only remote checks; this is not a tool-execution or security guarantee.
- Successful checks
- 1 of 1 (100%)
- Average latency
- 567 ms
- 95th percentile latency
- 567 ms
Maintenance history
Public check and source-refresh events. Editorial and ownership records remain private.
- · probe · passed · 567 ms · metadata changed · 2 tool(s), 1 resource(s), 1 resource template(s)
Connect from your client
Each snippet registers the same endpoint; pick the client you use.
Claude Code
Claude Code configuration
claude mcp add --transport http zovo-spreadsheet-merge-mcp https://sheet-join.zovo.one/mcpCodex
Codex configuration
codex mcp add zovo-spreadsheet-merge-mcp --url https://sheet-join.zovo.one/mcpCursor
Cursor configuration
{
"mcpServers": {
"zovo-spreadsheet-merge-mcp": {
"url": "https://sheet-join.zovo.one/mcp"
}
}
}Cline
Cline configuration
{
"mcpServers": {
"zovo-spreadsheet-merge-mcp": {
"type": "streamableHttp",
"url": "https://sheet-join.zovo.one/mcp",
"disabled": false
}
}
}VS Code
VS Code configuration
{
"servers": {
"zovo-spreadsheet-merge-mcp": {
"type": "http",
"url": "https://sheet-join.zovo.one/mcp"
}
}
}Gemini CLI
Gemini CLI configuration
gemini mcp add --transport http zovo-spreadsheet-merge-mcp https://sheet-join.zovo.one/mcpClaude Desktop
Claude Desktop configuration
{
"mcpServers": {
"zovo-spreadsheet-merge-mcp": {
"url": "https://sheet-join.zovo.one/mcp"
}
}
}Windsurf
Windsurf configuration
{
"mcpServers": {
"zovo-spreadsheet-merge-mcp": {
"serverUrl": "https://sheet-join.zovo.one/mcp"
}
}
}Let your agent find its tools
Find servers like Zovo Spreadsheet Merge MCP from your agent. Add Koskamo once to search the index for endpoints, access requirements, and client setup. Public discovery needs no key.