Export Anonymiser
Version 1.0 · Offline · Makes a copy of an Excel export with names, contact details and free text replaced, so it can be shared as a sample.
How it works: it reads the export on this computer and writes a new copy. Nothing is uploaded. The original file is not changed.
- Columns that look personal are replaced: names, staff names, emails, phone numbers, addresses, notes and codes. The same real value always gets the same made-up value, so totals and counts still match.
- Every other text cell is also checked for email addresses and phone numbers, which are replaced wherever they appear. The file's author details are cleared.
- Unit numbers, dates, amounts, statuses and the totals row are kept, so the copy still works in the Report Converter. In notes, everyday words (such as “care call”, “follow up”, “paid”), single letters and dates are kept; every other word, including names, and other numbers are replaced.
You can change what happens to each column below. Open the copy in Excel and check it before you send it.
2. Check each column (examples are shown only on this screen)
3. Download the anonymised copy