Guide · Excel · Google Sheets

How to remove personal data from a spreadsheet before using AI

Five minutes of tidying can stop personal data leaving your business.

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.

Read next