Connect Excel to AI: Let Claude and Cursor Read Spreadsheets, Formulas, and Pivot Tables

Why Connect Excel to AI?

Microsoft Excel is where business data lives. Financial models, project trackers, inventory sheets, reporting dashboards, budget forecasts. When you need a number from a spreadsheet mid-task, you open Excel Online, find the workbook, navigate to the right sheet, locate the cell. That round trip adds up across dozens of lookups per day.

With an MCP server pointed at Excel Online, AI agents can read your spreadsheet data directly. Pull values, check formulas, read pivot tables without leaving your terminal.

What AI Agents Can Do With Excel Access

Once connected, Claude, Cursor, or Codex can:

• Read cell values — "What's the total revenue in cell G45 of the Q2 forecast?"
• Check formulas — "What formula is driving the margin calculation in the pricing sheet?"
• Read pivot tables — "What are the top 5 products by revenue in the sales pivot?"
• Browse workbooks — "List all sheets in the Operations tracker workbook"
• Pull ranges — "Give me all values from B2:B50 in the inventory sheet"
• Check named ranges — "What's the current value of the 'target_arr' named range?"

How It Works

1. Open DataFaucet and enter your Excel Online URL (from Microsoft 365)
2. Browse the spreadsheet — click through sheets, tables, pivot tables
3. DataFaucet captures the read operations as MCP tools
4. Deploy — your AI agents now have structured access to query Excel data

You're browsing Excel Online's web UI, not sharing your Microsoft account credentials. DataFaucet captures the HTTP interactions. Your Microsoft 365 session stays in your browser.

Example Queries

"What's the current ARR number in the finance model?"
"Pull all customer names from column A of the accounts sheet"
"What formula is in cell D12 of the pricing calculator?"
"What does the regional breakdown pivot table show for Q2?"
"List all sheets in the project-tracker.xlsx workbook"

When This Saves Time

• Financial modeling — reference live spreadsheet values while writing analysis
• Reporting — pull specific metrics without opening Excel
• Data validation — check that code outputs match expected spreadsheet values
• Planning — ask about budget and forecast data mid-conversation

Security Model

DataFaucet connects through Excel Online's web interface. Access is scoped to whatever workbooks your Microsoft 365 account can open. If a workbook is shared read-only, the MCP server only gets read access. No Microsoft credentials are stored separately.

Getting Started

Open Excel Online for the workbook you want AI to access. Copy the URL from your browser. Paste it into DataFaucet, browse through sheets and tables, deploy. Your agents can now query spreadsheet data from your terminal.

Create your Excel MCP server →