excel-cli — GitHub Copilot plugin: work with Excel from terminal
The agent creates and edits Microsoft Excel workbooks — formulas, Power Query, PivotTables, charts, and VBA — by running excelcli commands in the terminal.
MIT ★ 2 updated 2026-10-23
copilot plugin install excel-cli@awesome-copilotWhat excel-cli does
The plugin provides 424 operations across 33 categories: creating workbooks, editing ranges and tables, refreshing Power Query queries, running DAX queries against the Data Model, building PivotTables and charts, running VBA, and managing connections. The agent calls excelcli, which controls the actual Excel application — all calculations and workbook features are handled by Excel itself.
Requires Windows with Excel 2016 or later, Node.js 18 or later, and an interactive desktop session. M and DAX code stays on your computer unless you enable --format-m-code or --format-dax flags — they send code to powerqueryformatter.com and daxformatter.com.
The plugin is available in two marketplaces: Awesome Copilot (built into Copilot) and the direct repository sbroenne/mcp-server-excel-plugins. Install from one only — both copies together will conflict.
What it helps with
- Create an Excel workbook with a table, formulas and formatting
- Refresh Power Query queries and save the result
- Build a PivotTable and chart from data
- Run a DAX query against the Data Model
- Execute a VBA macro from a workbook
Example prompts for the agent
- Create a sales tracker with Date, Product, Quantity, Price and Total columns
- Refresh the Power Query queries in
sales.xlsxand save it - Build a PivotTable showing revenue by region and add a chart
How to install excel-cli
Command from the source
copilot plugin install excel-cli@awesome-copilotStep by step, with commands for each platform: Claude Code plugins: marketplaces, installing, and building your own
Questions about excel-cli
How to install excel-cli in GitHub Copilot?
Run copilot plugin install excel-cli@awesome-copilot in PowerShell. The plugin is ready to use; no separate CLI installation needed.
What does excel-cli do?
Gives the agent 424 commands to create and edit Microsoft Excel workbooks: formulas, Power Query, PivotTables, charts, and VBA. Works through the actual Excel application.
What are excel-cli requirements?
Windows with Excel 2016 or later, Node.js 18 or later, and an active desktop session. PowerShell 5.1 is not supported — you need version 7.4 or later if running through bin\start-cli.ps1.
Source text
excel-cli · MIT
# Excel CLI Plugin **Let your coding agent create and update Microsoft Excel workbooks from the terminal.** Your agent runs `excelcli` commands and reads built-in help when needed. ExcelMcp operates the actual Excel application, so Excel handles calculations and workbook features. ## Requirements - GitHub Copilot CLI or Claude Code - Windows with desktop Excel 2016 or later - Node.js 18 or later with `npx` - PowerShell 7.4 or later (`pwsh`) when using `bin\start-cli.ps1`; Windows PowerShell 5.1 is not supported ExcelMcp runs in an interactive desktop session. ## What you can ask your agent to do | Request | Result | | --- | --- | | "Create a sales tracker with Date, Product, Quantity, Unit Price, and Total columns." | A workbook with a table and formulas. | | "Create a PivotTable showing revenue by region, then add a chart." | A summary and chart built in Excel. | | "Refresh the Power Query queries in this workbook and save it." | Updated query results saved in the workbook. | | "Put this data into a worksheet and format the totals." | Formatted data ready to read. | ## Features The CLI provides 33 feature command categories with 424 operations. - **Workbooks and data:** create, open, save, and close workbooks; edit ranges, tables, and formulas. - **Analysis:** refresh Power Query, query the Data Model with DAX, and build PivotTables and slicers. - **Reports:** create and format charts, worksheets, and conditional formatting. - **Automation:** manage connections, run VBA, and automate Excel windows. - **Protected workbooks:** detect IRM/AIP protection and open Excel visibly for sign-in. - **Sessions:** keep a workbook open across commands so the agent can work step by step. See the [complete feature reference](https://excelmcpserver.dev/features/). ## Privacy M and DAX code stays on your computer by default. If you set `--format-m-code` or `--format-dax` to `true`, the corresponding code is sent to powerqueryformatter.com or daxformatter.com. Only turn it on when you want to send code to those services. ## Support - [Documentation](https://excelmcpserver.dev/) - [Issues](https://github.com/sbroenne/mcp-server-excel/issues) - MIT License ## Install Install from [Awesome Copilot](https://github.com/github/awesome-copilot), the default marketplace in current Copilot clients: ```powershell copilot plugin install excel-cli@awesome-copilot ``` Or use the direct marketplace: ```powershell copilot plugin marketplace add sbroenne/mcp-server-excel-plugins copilot plugin install excel-cli@mcp-server-excel-plugins ``` Choose one marketplace for this plugin; do not install both copies. For Claude Code, use the direct marketplace: ```powershell claude plugin marketplace add sbroenne/mcp-server-excel-plugins claude plugin install excel-cli@mcp-server-excel-plugins ``` The plugin launches `excelcli` automatically; no separate installation or PATH change is needed. To use the CLI without this plugin, follow the [CLI installation guide](https://excelmcpserver.dev/installation-cli/).
© Stefan Brönner · MIT · sbroenne/mcp-server-excel-plugins