How to Create Spreadsheets with Copilot
Generate Excel files in your IDE with Copilot and ToolRouter. Create spreadsheets from code or structured data.
Tool
Copilot connects spreadsheet generation directly to your development work — export test data as a real Excel file, generate a structured report from database output, or create a configuration template without leaving the editor.
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
Steps
Once connected (see setup above), use the Excel Tools tool:
- In Copilot Chat: "Create an Excel file from this data: [paste structured data]"
- Copilot generates the spreadsheet and returns a download URL
- Ask: "Write code to fetch this URL and save the file locally"
- Integrate the generation step into your build or export pipeline
Example Prompt
Try this with Copilot using the Excel Tools tool
Take this JSON array of user records and create an Excel spreadsheet with columns for id, name, email, and signup date: [paste JSON].
Tips
- Paste JSON or CSV data directly and Copilot maps it to Excel columns automatically
- Ask Copilot to generate the download and save code alongside the spreadsheet creation
- Useful for creating test fixtures or sample data files for QA