Comments and free text
"Call Mr. Carter back at (555) 013-2847": notes columns and cell comments often contain names and numbers.
Excel and CSV anonymization
Anonymize Excel and CSV data without breaking your spreadsheets
NymData detects and anonymizes PII in every sheet, cell comments included.
Only the sensitive cells change: columns, tabs and formulas stay in place.
The anonymized file works just like the original, and processing stays on your servers.
Before: personal data highlighted in red
| Customer | Phone | Amount | |
|---|---|---|---|
| Sarah Mitchell | [email protected] | (555) 014-6621 | $1,250 |
| John Carter | [email protected] | (555) 013-2847 | $980 |
| Sarah Mitchell | [email protected] | (555) 014-6621 | $430 |
Identities visible to anyone who opens the file
After: constant identifier, amounts preserved
| Customer | Phone | Amount | |
|---|---|---|---|
| PERSON_7b94f21c | [EMAIL] | [PHONE] | $1,250 |
| PERSON_3e1a9d02 | [EMAIL] | [PHONE] | $980 |
| PERSON_7b94f21c | [EMAIL] | [PHONE] | $430 |
Same customer, same identifier: totals per customer still work
- Every sheet and cell comment
- Columns and formulas preserved
- CSV delimiter respected
- Source file never modified
How do you anonymize an Excel file that contains personal data?
You need to look for PII across the whole workbook, not just in the name column.
It also sits in other columns, other tabs, cell comments and the file properties.
With NymData, you select a file or a folder.
Each sensitive cell is anonymized with the method you choose.
Formulas and structure are preserved, and an audit report documents the run.
The trap
Why deleting the name column is not enough
A spreadsheet holds personal data well beyond the obvious columns.
And deleting columns often destroys what made the file useful.
Other tabs and file properties
A forgotten working tab, or the author saved in the file properties, is enough to identify a person.
Analysis no longer possible
Without a customer column, no more totals per customer and no more matching with another file.
A constant identifier keeps those uses, without the identity.
What NymData does
An anonymized spreadsheet you can still use
The whole workbook analyzed
Every cell of every sheet, plus cell comments, goes through the detection engine.
Structure preserved
Only the sensitive cells change: columns, tabs and formulas stay in place.
Constant identifier across files
The same person keeps the same identifier (for example PERSON_7b94f21c) across the whole project: matching between files keeps working.
Re-importable CSV
The original delimiter (comma, semicolon or tab) is preserved, with one row per record.
File properties cleaned
The author and the last person who modified the workbook are erased from the file properties.
Source file never modified
NymData creates an anonymized copy in a separate folder, on your servers.
An audit report documents the run.
Learn more: how NymData works, security and on-premises installation, anonymization vs. pseudonymization. In your industry: finance and insurance, public sector, manufacturing.
Use cases
When should you anonymize your spreadsheets?
- Analytics and AI: work on customer, HR or patient files without seeing identities.
- Sharing with a vendor: send a usable file to a consulting firm, a software vendor or a partner.
- Test data: give your teams realistic files, with no real data.
- Recurring files: every new file dropped into a folder is anonymized automatically, thanks to scheduled processing.
Scope
Supported spreadsheet formats
- SupportedExcel (.xlsx)
- Every sheet, cell values and cell comments.
- Formulas and structure preserved.
- SupportedCSV
- Comma, semicolon or tab delimiter, detected automatically and kept exactly as is.
- SupportedCell comments
- Comments attached to cells are analyzed and anonymized just like values.
- SupportedFile properties
- The author and the last person who modified the workbook are erased.
FAQ
Frequently asked questions about anonymizing Excel and CSV data
Is deleting the name column enough to anonymize an Excel file?
No. Personal data often sits elsewhere: notes columns, cell comments, other tabs, file properties such as the author.
You need to analyze the whole workbook.
Are formulas preserved after anonymization?
Yes. NymData anonymizes the sensitive values in the affected cells, and keeps formulas, tabs and column structure.
Can I still run analytics on an anonymized file?
Yes. With a constant identifier, the same person gets the same code across the whole project, for example PERSON_7b94f21c.
Counts, grouping and matching between files remain possible, without knowing the identity.
Can the anonymized CSV file be re-imported?
Yes. NymData keeps the original delimiter (comma, semicolon or tab) and one row per record.
The file re-imports into Excel, a database or a business application.
Learn more
Related reading
ProductFormatGuide
Which method should you choose?
Anonymization, realistic pseudonymization, constant identifier: examples and use cases.
PDF redaction
Why a black rectangle is not enough, and how to truly remove the information.
Anonymization vs. pseudonymization
The differences, what the GDPR says, and when to choose one or the other.
See NymData anonymize your spreadsheets, live
A demo on a complete NymData installation, with sample files.
Your files stay with you.