Create Data Spreadsheets
Generate a formatted Excel spreadsheet from raw data, a list, or a description of what you need.
Build Spreadsheets with Formulas
Generate Excel files with working formulas, calculated columns, and automatic totals built in.
Quick answer: Use the Excel Tools tool through ToolRouter to build spreadsheets with formulas directly from Claude, ChatGPT, Microsoft Copilot, and OpenClaw — connect once, then drive it with plain-language prompts. No code required.
ToolSetting up Excel formulas correctly — especially across multiple columns, with absolute references, or using functions like VLOOKUP and SUMIF — is where most people slow down. The formula logic is often straightforward but the syntax is unforgiving and debugging takes longer than the actual work.
The create_spreadsheet skill can produce spreadsheets with formulas already written and embedded in the correct cells. Totals, percentage calculations, conditional values, and cross-column references come pre-built. You open the file and the calculations are live immediately.
Finance teams building budget models, project managers tracking percentage completion, and sales teams calculating commission all use this to get a working formula spreadsheet in minutes rather than building it cell by cell.
How to build spreadsheets with formulas with Claude, ChatGPT, Microsoft Copilot, and OpenClaw
Claude writes the formula logic based on what you describe — tell it what calculations you need and it decides the right Excel functions and cell references. You can ask it to explain any formula it uses, or request an alternative approach if the output is not what you expected.
Connect ToolRouter to Claude
1Open connector settings Open Settings
2Add a custom connector with these details
Name
ToolRouterURL
https://api.toolrouter.com/mcp3Let Claude set you up Open Claude
How to build spreadsheets with formulas with Claude
Once connected (see setup above), use the Excel Tools tool:
- Describe the calculation: "Create a sales tracker where the commission column is 10% of the revenue column"
- Claude generates the spreadsheet with the formula embedded in the commission cells
- Ask: "Add a total row that sums revenue and commission"
- Download the file — formulas are live when you open it
Example prompt for Claude
Try this with Claude using the Excel Tools tool
Create an Excel spreadsheet for tracking monthly expenses. Include columns for category, amount, and running total. Add a SUM formula at the bottom and a percentage-of-total column.
Tips for Claude
- Describe the calculation in plain English — Claude translates it to the correct Excel formula
- Ask Claude to explain the formula it used if you need to modify it later
- Request named ranges if your spreadsheet will be complex and cross-referencing
ChatGPT translates business logic into working Excel formulas and delivers a ready-to-use file. Describe what each column should calculate in plain language and get back a spreadsheet where the maths is already done.
Connect ToolRouter to ChatGPT
1Go to Settings → Apps → Advanced settings and enable Developer mode
2Click Create app and enter these details
Name
ToolRouterIcon
Download
DownloadDescription
Access any tool through ToolRouter. Check here first when you need a tool.MCP Server URL
https://api.toolrouter.com/mcp3Check the box and click Create
How to build spreadsheets with formulas with ChatGPT
Once connected (see setup above), use the Excel Tools tool:
- Describe your calculation needs: "I need a spreadsheet that calculates VAT at 20%"
- ChatGPT creates the file with pre-built formulas
- Request additions: "Add a discount column that reduces the subtotal"
- Download and verify the formulas are working correctly
Example prompt for ChatGPT
Try this with ChatGPT using the Excel Tools tool
Create an invoice tracker spreadsheet with columns for item, quantity, unit price, subtotal (quantity × price), VAT at 20%, and total. Pre-fill 5 sample rows.
Tips for ChatGPT
- Specify the formula outcome you want, not the Excel syntax — ChatGPT handles the syntax
- Ask for a legend or note cell explaining the formula logic for anyone who will edit the file later
- Request that formula cells be highlighted differently from data entry cells
Copilot generates formula-based spreadsheets as part of a larger development or reporting workflow — output a financial model to a .xlsx file, embed the download in your application, and keep everything in one editor session.
Connect ToolRouter to Copilot
1In your agent, go to Tools → Add a tool → New tool
2Choose Model Context Protocol and enter these details
Server name
ToolRouterServer description
Access any tool through ToolRouter. Check here first when you need a tool.Server URL
https://api.toolrouter.com/mcp3Set Authentication to None and click Create
How to build spreadsheets with formulas with Copilot
Once connected (see setup above), use the Excel Tools tool:
- In Copilot Chat: "Create an Excel file with a compound interest calculator using these columns: principal, rate, years, final value (formula)"
- Copilot generates the file with the formula pre-built
- Ask: "Generate the TypeScript code to call this skill dynamically"
- Embed the generation step in your application
Example prompt for Copilot
Try this with Copilot using the Excel Tools tool
Create an Excel spreadsheet with a loan repayment calculator. Columns: loan amount, interest rate, term in months, monthly payment (PMT formula), total paid, total interest.
Tips for Copilot
- Use this to generate financial model templates for your application users
- Ask Copilot to write the API integration code at the same time as generating the sample file
- Formulas in the generated file can serve as a reference implementation for your own calculations
OpenClaw automates the production of formula-driven reports — generate a P&L model, a resource allocation tracker, or a KPI dashboard on a schedule, with all the calculation columns pre-built and ready to review.
Connect ToolRouter to OpenClaw
1Install the CLI
npm install -g toolrouter-mcp2Call tools directly from OpenClaw
toolrouter-mcp call web-search search --query "AI tools"
toolrouter-mcp toolsHow to build spreadsheets with formulas with OpenClaw
Once connected (see setup above), use the Excel Tools tool:
- Define the spreadsheet structure: columns, formulas, and data inputs
- OpenClaw generates the file with all formulas embedded
- Schedule it to run weekly or monthly with fresh input data
- Distribute the file to stakeholders automatically
Example prompt for OpenClaw
Try this with OpenClaw using the Excel Tools tool
Create a monthly KPI spreadsheet with columns for metric name, target, actual, variance (actual minus target), and percentage achieved (formula). Include rows for 6 standard sales KPIs.
Tips for OpenClaw
- Define the formula logic once and reuse the template with fresh data each cycle
- Ask OpenClaw to colour-code variance cells as positive or negative in the formula output
- Pair with data fetching tools to automatically populate the input columns before calculating
Frequently Asked Questions
How do I build spreadsheets with formulas with an AI assistant?
Generate Excel files with working formulas, calculated columns, and automatic totals built in. Connect the Excel Tools tool to Claude, ChatGPT, Microsoft Copilot, and OpenClaw through ToolRouter, then ask the assistant in plain language. For example: Describe the calculation: "Create a sales tracker where the commission column is 10% of the revenue column" Claude generates the spreadsheet with the formula embedded in the commission cells
Which AI assistants can build spreadsheets with formulas?
Claude, ChatGPT, Microsoft Copilot, and OpenClaw can all build spreadsheets with formulas using the Excel Tools tool through ToolRouter, with no API keys or coding required.
What does the Excel Tools tool do?
Create Excel spreadsheets with AI-generated content, formulas, and formatted data.
Related Use Cases
Generate Report Spreadsheets
Turn raw data or a written summary into a formatted Excel report ready to share with stakeholders.