Excel MCP server

This is a small helper that lets your AI assistant work with Excel files directly. You ask in plain words, and it builds the spreadsheet, fills in the cells, adds the formatting and charts. It is handy for anyone who spends time making reports, trackers or summaries in Excel.

What this MCP server does

You tell your AI what you want, for example a sales report with a chart. The AI passes that request to this helper program. The helper then creates or opens the Excel file in a folder you allowed, writes the cells, adds formatting, tables or charts, and saves the file. When it is done, it tells you what it changed, and you open the file in Excel as usual.

Click to zoom

What you can do with it

• Create a new workbook with sheets, headers and data
• Read cells, formulas and dates from an existing file
• Format fonts, colours, borders, column widths and frozen rows
• Add tables, charts and summary tables
• Set up dropdown lists and number limits for data entry
• Add conditional formatting so cells change colour by rule
• Find cells by their content and read VBA macro code from .xlsm files

Try asking your AI

• “Create a workbook called budget.xlsx with a sheet for each month and a total row”
• “Read the sales figures from report.xlsx and tell me the top five products”
• “Add a bar chart of monthly revenue to the Summary sheet”
• “Format the header row in bold with a grey background and freeze it”

What it gives back to you

You get answers in the chat, like a list of cells, a summary of what is in a sheet, or a confirmation that a file was created or changed. It can also hand you the finished workbook file itself. The changes are saved into the Excel file, so you can open it and see them.

Before you start

Who it's for

Anyone who works with spreadsheets, like analysts, admin staff, project managers and small business owners who want reports built for them.