CSV & Excel MCP Server

Ask Claude or Cursor about your spreadsheets and get answers computed with SQL on your computer, not guessed from a pasted sample.

CSV & Excel MCP Server cover

What it does

Let Claude, Cursor or any MCP client answer questions about your CSV, TSV and Excel (.xlsx) files with real SQL instead of guessing from a pasted sample. Files are loaded into an in-memory SQLite database (one table per file or sheet), read-only, on your computer. Python standard library only: no pandas, no uploads, no API keys.

What you get

The screenshot is real output from the kit’s own commands. Tested from a fresh download of this exact zip: ./run_tests.sh ran 7 tests OK on Python 3.13 and 3.10.

Real terminal output from CSV & Excel MCP Server: demo and passing tests

Tools

ToolWhat it does
list_filesCSV/TSV/.xlsx files in the allowed folders
describe_filetable name, row count, columns with inferred types (INTEGER/REAL/TEXT), empty and distinct counts, samples, first rows; encoding and delimiter for CSVs; one table per workbook sheet
queryone read-only SQLite SELECT/WITH query across any loaded files: JOIN, GROUP BY, window functions, CTEs; up to 5,000 rows back
column_statsempty/distinct counts, min/max/mean/median/sum, text lengths, values with extra spaces, top 10 values
list_tableswhat's loaded so far

Handles UTF-8 (with or without BOM) and Windows-1252 files, comma/semicolon/tab/pipe delimiters, duplicate or blank headers, ragged rows and leading-zero codes such as ZIPs (kept as text). Files reload automatically when they change.

Install

Claude Code

claude mcp add csv-data -- python3 /absolute/path/to/csv-mcp-server/server.py --root /absolute/path/to/your/data

Or install the folder as a Claude Code plugin: .claude-plugin/plugin.json, .mcp.json (runs ${CLAUDE_PLUGIN_ROOT}/server.py --root ${CLAUDE_PROJECT_DIR}, so it sees your project folder) and a skill (skills/csv-data/SKILL.md) that tells Claude how to explore, query and double-check data.

Cursor: copy examples/configs/cursor-mcp.json into .cursor/mcp.json (project) or ~/.cursor/mcp.json and fix the paths. Claude Desktop: merge examples/configs/claude_desktop_config.json into your claude_desktop_config.json.

Allowed folders: each --root argument, else CSV_MCP_ROOTS (separated by : on macOS/Linux, ; on Windows), else CLAUDE_PROJECT_DIR, else the working directory.

Then ask: "Which customers spent the most last quarter?", "Join orders.csv to the Stock sheet and list SKUs below their reorder point", "Are there duplicate order IDs or empty amounts?"

Safety

  • Read-only: only SELECT/WITH/VALUES statements, one at a time; SQLite's authorizer denies writes, ATTACH, PRAGMA and extension loading; queries stop after 10 seconds.
  • Paths are confined to the allowed folders (.. and symlinks that lead outside are refused); files over 200 MB are refused (CSV_MCP_MAX_MB to change).
  • Your files are never modified or sent anywhere; results carry a note that cell values are untrusted data.

Demo and tests

./demo.sh runs a small MCP client against examples/data (orders, a Windows-1252 semicolon customers file and a two-sheet workbook). ./run_tests.sh runs 7 tests, including a full MCP stdio session.

Honest limits

  • .xlsx only (not legacy .xls or .ods); dates come through as Excel serial numbers and formulas as the value Excel last saved (files written by scripts that never opened in Excel may have none).
  • Everything is loaded into memory; best for files up to a few hundred MB.
  • MCP protocol versions 2025-11-25, 2025-06-18, 2025-03-26 and 2024-11-05 (tools only).

Also see the SEO Audit MCP Server and the MCP Config Validator. License: LICENSE.txt.

Format and license

Zip, 24 KB, v1.0, 20 files. You may use and modify this kit for your own work and for clients you serve, including paid client work. Not affiliated with or endorsed by Anthropic, Microsoft or Cursor (Anysphere).

FAQ

Can it change my files?
No, it's read-only: only SELECT queries, and files are never written.
Does it upload my data?
No, everything runs on your computer; only the query results go to your AI client.
Does it read .xls?
No, .xlsx only; save old workbooks as .xlsx or CSV.
How do I get the files?
Right after payment, Stripe’s confirmation page shows your download link.
Refunds?
Email hello@youraitools.co within 14 days if it doesn’t work and we can’t fix it.
Can I pay with crypto?
Yes. Pay the same price in USDC or USDT on Base, Ethereum, Arbitrum, Optimism, Polygon or Solana from the "Pay with crypto" button, with no account or KYC. We check the payment on-chain and show your download links as soon as it confirms.

Get CSV & Excel MCP Server

Read-only MCP server for CSV, TSV and Excel: describe columns, SQL joins across files and sheets, column stats. No uploads, no dependencies. $19 once.

Pairs well with

Download$19

Claude Code Plugin Marketplace Template

Start a Claude Code plugin marketplace: marketplace.json, 3 example plugins, team auto-install settings, CI and an offline checker. $19 once.

View Claude Code Plugin Marketplace Template
Download$39

Cursor Rules All-Stacks Bundle

86 Cursor rules for Next.js 16, Laravel 13, FastAPI, SvelteKit 3, Expo SDK 58, Django, Rails 8 and Supabase. Detects each repo's stack. $39 ($108 value).

View Cursor Rules All-Stacks Bundle
Download$29

GitHub Issue Triage MCP Server

MCP server that triages GitHub issues: scored queue, no-reply and stale lists, duplicate pairs, similar-issue search, label suggestions. Read-only. $29.

View GitHub Issue Triage MCP Server

Related