Catch hidden private data in a spreadsheet before you send it
A filter that hides rows doesn't remove them. The AI lists every hidden row and whose details are in it.
Published . Steps as of November 2026.
How do I check a spreadsheet for hidden data before I send it?
Attach the spreadsheet to ChatGPT or Claude and ask it to list hidden sheets, filtered rows, comments and personal data before you send. If you only share files now and then, run the check on the one going out. If you send client spreadsheets every week, keep the prompt saved and run it on each file. Either way, make the fixes yourself and save a fresh copy, since a filter hides rows without deleting them.
A sketch of what you'll get back.
Your prompt
Fill in your details. Skip any you like.
ChatGPT and Claude open with your prompt already typed in. It's copied too, just in case.
The prompt that gets copied
I'm about to send the attached spreadsheet to [WHO GETS IT, e.g. my client's finance team]. They should only see [WHAT THEY SHOULD SEE, e.g. their own invoice lines]. Before I send it, check the whole file, not just what shows on screen: 1. List every sheet, including hidden or very hidden ones, with a one-line description of what's on each. 2. Find any rows or columns that are hidden or filtered out, and tell me what's in them. 3. Flag personal or private data anywhere in the file: names, emails, phone numbers, addresses, account numbers, pay or prices meant for someone else. 4. List comments, notes, linked files and the file author or company name in the properties. 5. Tell me which of these the recipient shouldn't see, and give me the exact steps to remove them in Excel or Google Sheets. Show the results as a checklist, most serious problem first. Don't change the file yourself.
Upload a spreadsheet before you email it and ask the AI to list every hidden sheet, filtered row, comment and piece of personal data. You get a plain list of what to remove first.
Step by step
- Open ChatGPT or Claude and attach the spreadsheet you're about to send.
- Paste the prompt below and fill in who's getting the file.
- Remove or fix everything on the list, then save a fresh copy to send.
What you'll get
A ranked checklist of hidden sheets, filtered rows, comments and personal data in the file, plus the steps to strip out what the recipient shouldn't see.
- Made for
- Small business owners, Consultants, Everyone
- Works in
- ChatGPT, Claude