How to remove personal data from an Excel file
Document Inspector, and the data it leaves behind
Search for "remove personal information from Excel" and you find Excel's Document Inspector. It is worth running, but it solves a different problem: it removes data about the file, not the personal data in it.
What Document Inspector removes
In Excel, choose File › Info › Check for Issues › Inspect Document. According to Microsoft's documentation, it looks for:
- comments and annotations;
- document properties and personal information, such as the author's name;
- headers and footers;
- hidden rows, columns and worksheets;
- custom XML data and invisible content.
Work on a copy: Microsoft warns that removed content can't always be restored with Undo, and that removing hidden rows, columns or sheets with data can change the results of your formulas.
What it doesn't touch: the values in your cells
A customer list still contains every name, email address and phone number after Document Inspector has run. If the people in the sheet are the problem, and not just the author, you have to replace those values:
- Remove the columns the recipient doesn't need. The safest data is data you don't send.
- Replace the rest. Fake names and emails, masked phone numbers, birth years instead of dates, hashed customer IDs. See how to anonymize an Excel file.
- Look beyond the visible sheet. PivotTables usually keep a copy of their source data in the file, and formulas can point at sheets you didn't mean to share. If you share a OneDrive or SharePoint link instead of a copy, people may be able to open earlier versions from its version history.
- Then run Document Inspector on the copy you're going to send.
The quick way
The Scrubsheet browser tool reads the sheet you choose, replaces the personal data column by column, and downloads a new file with only the cell values: no comments, hidden sheets, PivotTable caches or author properties come along. In Excel, the add-in writes the anonymized copy to a new sheet. To send just that sheet, right-click its tab, choose Move or Copy, and pick (new book).
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