Anonymise an Excel file before sending it
A payroll export for a provider, a customer base for a demo, a file to attach to a support ticket: the data is needed, not the people. Personal columns are recognised, and each value is replaced by a made-up one, always the same for the same person.
What this tool does
- Names, emails, phones, IBANs, identifiers (social security, company number, staff number), addresses: recognised from the name and content of the columns.
- Consistent replacements: the same person becomes "Person 12" everywhere, in every column; the file can be counted, looked up and deduplicated like the original.
- Obviously made-up values, but well formed: an import check accepts the IBANs and emails produced.
- The key table, only if you ask for it, in a separate file.
- The file never leaves your computer: that is the whole point, since it holds what needs protecting.
What it does not do: With the key table, this is pseudonymisation under the GDPR, not anonymisation. The columns left as they are (dates of birth, postcodes, rare amounts) can still make someone recognisable: read them over.
No file is uploaded. Turn off your network once this page has loaded: the tool keeps working. How to check it yourself.
Other tools
- Fix a CSV file : Broken accents, everything in one column, lost zeros: a file Excel opens right the first time.
- Remove duplicates : On the columns you choose, optionally ignoring case, spaces and accents.
- Near-duplicates : "Smith Ltd" and "SMITH LTD.": the almost-identical duplicates, reviewed one by one.
- Clean text : Extra spaces, non-breaking spaces, line breaks, invisible characters, case.
- Convert text to numbers : "1,234.56 $", "(45.00)", "12.5-": real numbers that add up.