Copilot in Excel and personal data
What Microsoft commits to, and when to anonymize first
Copilot in Excel can summarise a sheet, suggest formulas and spot trends. If the sheet lists customers or employees, it is fair to ask where that data goes. For work accounts, Microsoft makes clear commitments. They don't cover every situation.
What Microsoft commits to for work accounts
From Microsoft's page on data, privacy and security for Microsoft Copilot (Microsoft 365 Copilot is now named Microsoft Copilot):
- Prompts, responses and data accessed through Microsoft Graph aren't used to train the foundation models.
- Prompts and responses are stored as your Copilot activity history, under the same contractual commitments as your organisation's other Microsoft 365 content.
- Copilot only shows data that the user already has permission to see.
- For EU customers, Copilot is an EU Data Boundary service, with one stated exception: models from Anthropic, which admins can enable, are currently outside it.
When to anonymize anyway
- Personal accounts and other AI tools. Those commitments are for organisations' Microsoft 365. Copilot with a personal Microsoft account, ChatGPT, Gemini and others have their own terms. See anonymizing data before ChatGPT.
- The question doesn't need the people. Data minimisation (GDPR Article 5) applies to AI as much as anything else. "Which region grew fastest?" doesn't need customer names.
- The result will be shared. Copilot's summaries, tables and charts can quote names and details from the sheet, and go wherever you send them.
- Your policy says so. Many organisations restrict which data may be used with AI features, whatever the vendor promises.
Keep the analysis, lose the people
Replace names and emails with consistent fakes or hashes, so totals per customer still add up; turn dates of birth into years and salaries into bands; drop free-text notes. The Scrubsheet add-in does this inside Excel and writes an anonymized copy of the sheet. Move that copy to a new workbook (right-click its tab, Move or Copy, (new book)) and use Copilot there, so the original stays out of the conversation.
This guide explains the rules as we understand them; it is not legal advice. Whether a particular dataset is anonymous depends on its content and on who receives it.
Try it on your own file. The Scrubsheet browser tool anonymizes Excel and CSV files in your browser, free and without uploading anything. In Excel, use the Scrubsheet add-in.
Anonymize a spreadsheet