ChatExcel

What it is

A Python MCP server for Excel work, built on a two-engine architecture: pandas for analysis and a Go service using excelize for the file handling. It covers thirty-one tools spanning reading, writing, verification, charts, formula evaluation and data-quality cleanup.

What you get

• Read a workbook without guessing at it — read_metadata, read_excel_metadata, excel_read_enhanced and excel_info_enhanced, with encoding detection and structure analysis
• Get the read parameters right before reading — suggest_excel_read_parameters_tool, detect_excel_file_structure_tool and create_excel_read_template_tool, which is what saves you from a header row landing in the data
• Run your own code against a sheet — run_excel_code and run_code execute pandas inside a sandbox with a module blacklist, rather than limiting you to fixed operations
• Write back — excel_write_enhanced with formatting and styles, and batch_process_excel_files for a folder at a time
• Interactive charts as HTML — bar_chart_to_html, pie_chart_to_html, line_chart_to_html and excel_chart_enhanced
• Check the data — verify_data_integrity, validate_data_quality, comprehensive_data_verification_tool and batch_data_verification_tool
• Clean it — enhanced_data_quality_check, clean_excel_data, convert_character_formats, extract_cell_content_advanced, extract_multi_condition_data and merge_multiple_tables
• Excel formulas as first-class objects — parse_formula, compile_workbook, execute_formula, validate_formula and analyze_dependencies, so you can find out what a cell depends on rather than reading the formula bar
• excel_performance_comparison, for when you need to know which engine to use on a large file

Requirements

Python 3.8 or newer, run from a clone of this repository in its own virtualenv, with your client launching server.py. The dependency list is large — pandas, numpy, openpyxl, matplotlib, plotly, duckdb and more — so expect a substantial environment rather than a small binary, and a self-check command ships with it. Local files only; no account and no key. Code execution runs sandboxed with a module blacklist, but it is still code execution against your machine, so treat what you paste in accordingly.

Setup effort

Build from source — git clone https://github.com/Lillard01/chatExcel-mcp.git

Tools you get

31 tools named in the project's documentation.

Requires

Python 3.8+

Where it runs

The documented client runs the server on your machine.