$git clone https://github.com/negokaz/excel-mcp-serverA Model Context Protocol (MCP) server that reads and writes MS Excel data.
| 1 | # Excel MCP Server |
| 2 | |
| 3 | <img src="https://github.com/negokaz/excel-mcp-server/blob/main/docs/img/icon-800.png?raw=true" width="128"> |
| 4 | |
| 5 | <a href="https://glama.ai/mcp/servers/@negokaz/excel-mcp-server"> |
| 6 | <img width="380" height="200" src="https://glama.ai/mcp/servers/@negokaz/excel-mcp-server/badge" alt="Excel Server MCP server" /> |
| 7 | </a> |
| 8 | |
| 9 | [](https://www.npmjs.com/package/@negokaz/excel-mcp-server) |
| 10 | [](https://smithery.ai/server/@negokaz/excel-mcp-server) |
| 11 | |
| 12 | A Model Context Protocol (MCP) server that reads and writes MS Excel data. |
| 13 | |
| 14 | ## Features |
| 15 | |
| 16 | - Read/Write text values |
| 17 | - Read/Write formulas |
| 18 | - Create new sheets |
| 19 | |
| 20 | **🪟Windows only:** |
| 21 | - Live editing |
| 22 | - Capture screen image from a sheet |
| 23 | |
| 24 | For more details, see the [tools](#tools) section. |
| 25 | |
| 26 | ## Requirements |
| 27 | |
| 28 | - Node.js 20.x or later |
| 29 | |
| 30 | ## Supported file formats |
| 31 | |
| 32 | - xlsx (Excel book) |
| 33 | - xlsm (Excel macro-enabled book) |
| 34 | - xltx (Excel template) |
| 35 | - xltm (Excel macro-enabled template) |
| 36 | |
| 37 | ## Installation |
| 38 | |
| 39 | ### Installing via NPM |
| 40 | |
| 41 | excel-mcp-server is automatically installed by adding the following configuration to the MCP servers configuration. |
| 42 | |
| 43 | For Windows: |
| 44 | ```json |
| 45 | { |
| 46 | "mcpServers": { |
| 47 | "excel": { |
| 48 | "command": "cmd", |
| 49 | "args": ["/c", "npx", "--yes", "@negokaz/excel-mcp-server"], |
| 50 | "env": { |
| 51 | "EXCEL_MCP_PAGING_CELLS_LIMIT": "4000" |
| 52 | } |
| 53 | } |
| 54 | } |
| 55 | } |
| 56 | ``` |
| 57 | |
| 58 | For other platforms: |
| 59 | ```json |
| 60 | { |
| 61 | "mcpServers": { |
| 62 | "excel": { |
| 63 | "command": "npx", |
| 64 | "args": ["--yes", "@negokaz/excel-mcp-server"], |
| 65 | "env": { |
| 66 | "EXCEL_MCP_PAGING_CELLS_LIMIT": "4000" |
| 67 | } |
| 68 | } |
| 69 | } |
| 70 | } |
| 71 | ``` |
| 72 | |
| 73 | ### Installing via Smithery |
| 74 | |
| 75 | To install Excel MCP Server for Claude Desktop automatically via [Smithery](https://smithery.ai/server/@negokaz/excel-mcp-server): |
| 76 | |
| 77 | ```bash |
| 78 | npx -y @smithery/cli install @negokaz/excel-mcp-server --client claude |
| 79 | ``` |
| 80 | |
| 81 | <h2 id="tools">Tools</h2> |
| 82 | |
| 83 | ### `excel_describe_sheets` |
| 84 | |
| 85 | List all sheet information of specified Excel file. |
| 86 | |
| 87 | **Arguments:** |
| 88 | - `fileAbsolutePath` |
| 89 | - Absolute path to the Excel file |
| 90 | |
| 91 | ### `excel_read_sheet` |
| 92 | |
| 93 | Read values from Excel sheet with pagination. |
| 94 | |
| 95 | **Arguments:** |
| 96 | - `fileAbsolutePath` |
| 97 | - Absolute path to the Excel file |
| 98 | - `sheetName` |
| 99 | - Sheet name in the Excel file |
| 100 | - `range` |
| 101 | - Range of cells to read in the Excel sheet (e.g., "A1:C10"). [default: first paging range] |
| 102 | - `showFormula` |
| 103 | - Show formula instead of value [default: false] |
| 104 | - `showStyle` |
| 105 | - Show style information for cells [default: false] |
| 106 | |
| 107 | ### `excel_screen_capture` |
| 108 | |
| 109 | **[Windows only]** Take a screenshot of the Excel sheet with pagination. |
| 110 | |
| 111 | **Arguments:** |
| 112 | - `fileAbsolutePath` |
| 113 | - Absolute path to the Excel file |
| 114 | - `sheetName` |
| 115 | - Sheet name in the Excel file |
| 116 | - `range` |
| 117 | - Range of cells to read in the Excel sheet (e.g., "A1:C10"). [default: first paging range] |
| 118 | |
| 119 | ### `excel_write_to_sheet` |
| 120 | |
| 121 | Write values to the Excel sheet. |
| 122 | |
| 123 | **Arguments:** |
| 124 | - `fileAbsolutePath` |
| 125 | - Absolute path to the Excel file |
| 126 | - `sheetName` |
| 127 | - Sheet name in the Excel file |
| 128 | - `newSheet` |
| 129 | - Create a new sheet if true, otherwise write to the existing sheet |
| 130 | - `range` |
| 131 | - Range of cells to read in the Excel sheet (e.g., "A1:C10"). |
| 132 | - `values` |
| 133 | - Values to write to the Excel sheet. If the value is a formula, it should start with "=" |
| 134 | |
| 135 | ### `excel_create_table` |
| 136 | |
| 137 | Create a table in the Excel sheet |
| 138 | |
| 139 | **Arguments:** |
| 140 | - `fileAbsolutePath` |
| 141 | - Absolute path to the Excel file |
| 142 | - `sheetName` |
| 143 | - Sheet name where the table is created |
| 144 | - `range` |
| 145 | - Range to be a table (e.g., "A1:C10") |
| 146 | - `tableName` |
| 147 | - Table name to be created |
| 148 | |
| 149 | ### `excel_copy_sheet` |
| 150 | |
| 151 | Copy existing sheet to a new sheet |
| 152 | |
| 153 | **Arguments:** |
| 154 | - `fileAbsolutePath` |
| 155 | - Absolute path to the Excel file |
| 156 | - `srcSheetName` |
| 157 | - Source sheet name in the Excel file |
| 158 | - `dstSheetName` |
| 159 | - Sheet name to be copied |
| 160 | |
| 161 | ### `excel_format_range` |
| 162 | |
| 163 | Format cells in the |