Forum Discussion
gzimmerman
May 04, 2026Copper Contributor
CoPilot Agent for copying and renaming Excel spreadsheets
Hi- Does CoPilot have the functionality to build copying and renaming Excel spreadsheets into an agent? I want to design an agent to take an excel file and copy the contents into another spreadsheet...
Aggarwalatul
Microsoft
Jun 19, 2026Its possible, but typically through a combination of Copilot Studio, Power Automate, and Excel/SharePoint connectors rather than Copilot alone. You can build an agent that accepts a user request, locates an Excel file stored in a Teams channel, creates a copy, renames it based on your naming convention, and optionally copies data into another spreadsheet. The agent would trigger a workflow that performs the file operations and data movement automatically. For straightforward file copy/rename tasks, Power Automate may be the simplest approach, while a Copilot Studio agent can provide a conversational interface for users to initiate the process and supply parameters such as file name, destination, or date range.