How to Generate Report Spreadsheets with Copilot
Generate formatted Excel reports with Copilot and ToolRouter. Create spreadsheets from structured data in your IDE.
Tool
Copilot turns application output into shareable Excel reports without leaving the editor — convert API response data, database query results, or log files into a formatted .xlsx report in one step.
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:
- Paste structured data: "Create an Excel report from this JSON: [paste JSON]"
- Copilot maps the fields to columns and generates the file
- Ask: "Add TypeScript code to call this skill and save the output"
- Integrate the export step into your application
Example Prompt
Try this with Copilot using the Excel Tools tool
Convert this JSON array of 20 orders into an Excel report with columns for order ID, customer, product, quantity, and total. Return the download URL.
Tips
- Use this to add an "Export to Excel" feature to your application without a library
- Pass database query output directly to generate reports on demand
- Ask Copilot to generate both the skill call and the file download handler in one step