Anonymise data before you share it (GDPR-friendly)
Sending a spreadsheet to a supplier, consultant, auditor or AI tool? Remove or disguise the personal data first. This tool suggests what to do with each column and does it in one click, inside your browser, so the original data is never uploaded.
- Replace with codes: Names and emails become Person 0001, Customer 0002โฆ The same person always gets the same code, so you can still count, group and join.
- Hash: A one-way code using a secret key (SHA-256), for matching records between files without revealing who they are. Capitals and spaces at the ends are ignored, so JANE@X.COM and jane@x.com get the same code.
- Mask: Keep a hint, for example j***@g***.com or ******** 123.
- Generalise: Postcode to outward code (CV1) or area (CV), date of birth to age band, dates to month or year, salaries rounded to ยฃ1,000.
- Redact text: Emails, phone numbers, NI numbers and postcodes inside notes become [email], [phone], [NI number] and [postcode].
- Remove Columns such as addresses, NI numbers and bank details.
Anonymised or pseudonymised? Under UK GDPR, data replaced with codes is "pseudonymised" while you keep the key file, and is still personal data. Delete the key, generalise enough, and the data can become anonymous. When in doubt, check with your data protection officer.