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):

When to anonymize anyway

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

More guides