Excel Workbook MCP server

This is a small helper that lets your AI read and write Excel files for you. It can take an existing .xlsx or .xlsm workbook and hand back code, XML or JSON that rebuilds it, and it can also build a new workbook from XML or JSON you already have. It is handy if you work with spreadsheets and want your AI to inspect them, convert them, or generate them without you touching Excel.

What this MCP server does

You ask your AI something like "read this spreadsheet and tell me what is in it" or "turn this workbook into JSON". Your AI passes the request to this helper. The helper opens the file on your computer, reads its sheets and cells, and works out the structure. It sends the result back to your AI, which shows it to you in the chat. You can also go the other way: give your AI some XML or JSON, and the helper builds a real .xlsx file from it and saves it where you say.

Click to zoom

What you can do with it

• Read an existing .xlsx or .xlsm file and list its sheets and cells
• Create a new Excel workbook from a simple list of sheets, rows and cells
• Turn an existing workbook into a runnable F# script that rebuilds it
• Turn an existing workbook into a runnable C# file that rebuilds it
• Convert a workbook to XML or JSON, useful for tracking changes in version control
• Build a new .xlsx directly from XML or JSON you already have
• Fetch the XML or JSON schema so you can see the exact shape expected

Try asking your AI

• “Read budget.xlsx and show me every sheet and cell”
• “Turn report.xlsx into JSON and save it as report.json”
• “Create a new workbook called sales.xlsx with one sheet named January and a few rows of numbers”
• “Take report.xml and build report.xlsx from it”

What it gives back to you

You get back text in the chat: a list of sheets and cells, a block of F#, C# or XML or JSON, or a short confirmation that a file was saved. When you ask it to read a workbook, you see the cell values laid out by sheet and row. When you ask it to generate code or data, you see the full text, which you can copy or save. When it builds a file, it tells you the path it wrote to.

Before you start

Who it's for

Anyone who works with Excel files and wants their AI to read, convert or generate them without writing code, especially analysts, finance and operations people.