__pycache__/

*.py[cod]

build/

dist/

src/*.egg-info/

.venv/

.vscode/

.idea/

.cursor/

.pytest_cache/

.ruff_cache/

.mypy_cache/

htmlcov/

tests/

extras/

dist/

excel_files/

__pycache__/

.notes/

logs/

output/

excel_files/

</p>

[](https://pypi.org/project/excel-mcp-server/)

[](https://opensource.org/licenses/MIT)

[](https://cursor.com/install-mcp?name=excel-mcp-server&config=eyJjb21tYW5kIjoidXZ4IGV4Y2VsLW1jcC1zZXJ2ZXIgc3RkaW8ifQ%3D%3D)

A Model Context Protocol (MCP) server that lets you manipulate Excel files without needing Microsoft Excel installed. Create, read, and modify Excel workbooks with your AI agent.

- 📊 Create and modify Excel workbooks

- 📝 Read and write data

- 🎨 Apply formatting and styles

- 📈 Create charts and visualizations

- 📊 Generate pivot tables

- 🔄 Manage worksheets and ranges

- 🔌 Dual transport support: stdio and SSE

- Python 3.10 or higher

- 📊**Excel Operations**: Create, read, update workbooks and worksheets

- 📈**Data Manipulation**: Formulas, formatting, charts, pivot tables, and Excel tables

- 🔍**Data Validation**: Built-in validation for ranges, formulas, and data integrity

- 🎨**Formatting**: Font styling, colors, borders, alignment, and conditional formatting

- 📋**Table Operations**: Create and manage Excel tables with custom styling

- 📊**Chart Creation**: Generate various chart types (line, bar, pie, scatter, etc.)

- 🔄**Pivot Tables**: Create dynamic pivot tables for data analysis

- 🔧**Sheet Management**: Copy, rename, delete worksheets with ease

- 🔌**Triple transport support**: stdio, SSE (deprecated), and streamable HTTP

- 🌐**Remote & Local**: Works both locally and as a remote service

The server supportstwo transportmodes: stdio and SSE.

The server supportsthree transportmethods:

Stdio transport is ideal for direct integration with tools like Cursor Desktop or local development, which can manipulate local files:

uvx excel-mcp-server stdio

{

"mcpServers": {

"excel": {

"command":"uvx",

"args": ["excel-mcp-server","stdio"]

}

}

}

uvx excel-mcp-server sse

[](https://cursor.com/install-mcp?name=excel-mcp-server&config=eyJjb21tYW5kIjoidXZ4IGV4Y2VsLW1jcC1zZXJ2ZXIgc3RkaW8ifQ%3D%3D)

1. Add this configuration to your client, choosing the appropriate transport method for your needs:

**Stdio transport connection** (for local integration):

**SSE transport connection**:

{

"mcpServers": {

"excel-stdio": {

"command":"uvx",

"args": ["excel-mcp-server","stdio"]

"excel": {

"url":"http://localhost:8000/sse",

}

}

}

**SSE transport connection**:

uvx excel-mcp-server streamable-http

**Streamable HTTP transport connection**:

{

"mcpServers": {

"excel": {

"url":"http://localhost:8000/sse",

"url":"http://localhost:8000/mcp",

"transport":"streamable-http"

}

}

}

2. The Excel tools will be available through your AI assistant.

When running the server with the**SSEprotocol**, you**must set the`EXCEL_FILES_PATH` environment variable on the server side**. This variable tells the server where to read and write Excel files.

When running the server with the**SSEor Streamable HTTP protocols**, you**must set the`EXCEL_FILES_PATH` environment variable on the server side**. This variable tells the server where to read and write Excel files.

- If not set, it defaults to`./excel_files`.

You can also set the`FASTMCP_PORT` environment variable to control the port the server listens on (default is`8000` if not set).

- Example (Windows PowerShell):

- Example (Linux/macOS):

EXCEL_FILES_PATH=/path/to/excel_files FASTMCP_PORT=8080 uvx excel-mcp-serversse

EXCEL_FILES_PATH=/path/to/excel_files FASTMCP_PORT=8007 uvx excel-mcp-serverstreamable-http

MIT License - see[LICENSE](LICENSE) for details.

MIT License - see[LICENSE](LICENSE) for details.

[project]

name ="excel-mcp-server"

version ="0.1.4"

version ="0.1.5"

description ="Excel MCP Server for manipulating Excel files"

readme ="README.md"

requires-python =">=3.10"

dependencies = [

"mcp[cli]>=1.6.0",

"openpyxl>=3.1.2",

"mcp[cli]>=1.10.1",

"openpyxl>=3.1.5",

]

[[project.authors]]

name ="haris"

from .serverimportrun_sse,run_stdio

from .serverimportrun_sse,run_stdio,run_streamable_http

app=typer.Typer(help="Excel MCP Server")

finally:

print("Service stopped.")

defstreamable_http():

print("Excel MCP Server - Streamable HTTP mode")

print("---------------------------------------")

print("Press Ctrl+C to exit")

try:

asyncio.run(run_streamable_http())

exceptKeyboardInterrupt:

print("\nShutting down server...")

exceptExceptionase:

print(f"\nError:{e}")

traceback.print_exc()

finally:

print("Service stopped.")

defstdio():

print("Excel MCP Server - Stdio mode")

print("-----------------------------")

print("Press Ctrl+C to exit")

try:

run_stdio()

exceptKeyboardInterrupt:

fromtypingimportAny,Dict

fromtypingimportAny,Dict,List,Optional

filepath:Path|str,

sheet_name:str,

start_cell:str="A1",

end_cell:str|None=None,

end_cell:Optional[str]=None,

preview_only:bool=False

)->list[dict[str,Any]]:

)->List[Dict[str,Any]]:

try:

wb=load_workbook(filepath,read_only=False)

defwrite_data(

filepath:str,

sheet_name:str|None,

data:list[list]|None,

sheet_name:Optional[str],

data:Optional[List[List]],

start_cell:str="A1",

)->dict[str,str]:

)->Dict[str,str]:

ifnotsheet_name:

sheet_name=wb.active.title

active_sheet=wb.active

ifactive_sheetisNone:

raiseDataError("No active sheet found in workbook")

sheet_name=active_sheet.title

elifsheet_namenotinwb.sheetnames:

wb.create_sheet(sheet_name)

def_write_data_to_worksheet(

worksheet:Worksheet,

data:list[list],

data:List[List],

start_cell:str="A1",

)->None:

filepath:Path|str,

sheet_name:str,

start_cell:str="A1",

end_cell:str|None=None,

end_cell:Optional[str]=None,

include_validation:bool=True

)->Dict[str,Any]:

fromtypingimportAny,Dict

fromtypingimportAny,Dict,Optional

fromopenpyxl.stylesimport (

PatternFill,Border,Side,Alignment,Protection,Font,

filepath:str,

sheet_name:str,

start_cell:str,

end_cell:str=None,

end_cell:Optional[str]=None,

bold:bool=False,

italic:bool=False,

underline:bool=False,

font_size:int=None,

font_color:str=None,

bg_color:str=None,

border_style:str=None,

border_color:str=None,

number_format:str=None,

alignment:str=None,

font_size:Optional[int]=None,

font_color:Optional[str]=None,

bg_color:Optional[str]=None,

border_style:Optional[str]=None,

border_color:Optional[str]=None,

number_format:Optional[str]=None,

alignment:Optional[str]=None,

wrap_text:bool=False,

merge_cells:bool=False,

protection:Dict[str,Any]=None,

conditional_format:Dict[str,Any]=None

protection:Optional[Dict[str,Any]]=None,

conditional_format:Optional[Dict[str,Any]]=None

)->Dict[str,Any]: