Hook: Your Excel formulas reference cell A2 which contains a customer name. Here's why most anonymization tools break your spreadsheets.
The Challenge
Excel is the de facto data sharing format for business operations — customer lists, HR records, financial reports, and operational data all live in spreadsheets. Anonymizing Excel data presents unique challenges: PII is embedded in cells within tables, pivot tables reference named cells, formulas refer to specific rows containing PII, and VBA macros may process PII directly. Standard text-processing tools either break the spreadsheet structure or require export to CSV (losing formulas, pivot tables, and macros). For GDPR compliance, EU companies must be able to anonymize Excel exports before sharing with third parties or analytical systems.
By the Numbers
- Air-gapped environment requirement cited by 67% of government and defense procurement RFPs (DISA 2024)
- GDPR Article 32 requires offline processing capability for highest-risk data
- EU NIS2 Directive mandates local processing for critical infrastructure operators
Real-World Scenario
A data analyst at a retail company preparing customer purchase history for an external marketing analytics vendor. The 50,000-row Excel file contains customer names, emails, and loyalty IDs alongside purchase amounts and product categories. anonym.legal's Excel add-in replaces names and emails with pseudonyms while hashing loyalty IDs for referential integrity — allowing the analytics vendor to track behavior patterns without accessing real identities.
Technical Approach
The Office Add-in processes Excel at the cell level, supporting up to 100,000 rows and 20MB files. Per-entity operator configuration allows different handling for different entity types within the same spreadsheet. The full undo capability allows recovery if a formula column is accidentally flagged.
Comments (0)