Anonymize HR data before AI sees it
An Excel template that turns employee data into an AI-safe version: pseudonyms instead of names, salary bands instead of amounts, and an automatic check for whether someone could still be identified. All formulas run locally in Excel, no macros - your data never leaves your computer.
What the template does
Paste your data into the first sheet and the second sheet automatically computes a safe version:
Pseudonymization
Names become Employee_001, Employee_002... Personal ID, email and job title are dropped.
Generalization
Salary is translated into pay bands (PR1-PR4), year of birth into age groups (<35, 35-49, 50+).
K-anonymity check
The K_groups column shows how many people share the same combination of attributes. Fewer than 5 means a person is recognizable even without a name (e.g. the only woman 50+ in IT) - the template flags it.
Step-by-step instructions
The third sheet walks you through it, with a 50-row sample dataset you can try right away. Note: the template is in Croatian.
The template is an educational data-preparation tool. It is not legal advice nor a replacement for a full pay equity audit.