Updated 17 November 2026.
1. Make a copy
Work on a copy of your file, never the original.
2. Delete the columns you don't need
To find themes or trends, you rarely need names, emails, phone numbers, addresses, dates of birth or customer IDs. Delete those columns completely rather than hiding them, because hidden columns are still in the file.
3. Search inside comments
People write personal details into free text: "call me on…", "my email is…", order numbers and names. In Excel or Google Sheets, use Find (Ctrl+F or Cmd+F) to search the comment column for @ (emails), 07 and +44 (UK mobiles), and words like "my name", "call me" and "order". Replace what you find with [removed].
4. Check other identifying details
A job title plus a small town, or a rare medical condition, can identify someone even without a name. If a detail isn't needed for your question, remove it.
5. Check before you send
Scroll through a sample of rows before pasting the data anywhere. No method is perfect.
The faster way
Naina does steps 2 to 4 automatically on your device: it leaves out columns of names, emails and addresses, and hides emails, phone numbers, postcodes, card and bank details and the names people sign off with. Then it shows you what will be sent before you press go.
Questions
Is hiding a column enough?
No. Hidden columns are still in the file. Delete them.
What about free tools that remove personal data?
Check where they process your file. A tool that uploads it to a server is still sharing it.
Does removing names make data anonymous?
Not always. Other details can still identify people, so remove anything you don't need.
Try Naına
A private AI analyst for your spreadsheets, customer comments and documents, with personal details hidden on your device first. £19.99 a month, cancel any time.