Industries

Anonymize survey data, free-text answers included

Closed questions are quick to anonymize, open-ended answers are not: respondents write in the names of advisers, branches, their own children or their phone number. When you need to anonymize survey data, Diskretio cleans CSV and Excel exports including free text in one pass.

Microsoft ExcelClient_List_Q3.xlsx
StartEinfügenFormelnDatenAnsicht
A2fxJohn Smith
ABCDEF
1ClientDate of birthIBANEmailPhoneFees
2John SmithMarch 4, 1970GB82 WEST 1234 5698 7654 32j.smith@mail.com(212) 555-1234£4,250.00
3Jane DoeMarch 12, 1985GB33 BUKB 2020 1555 5555 55jane.doe@outlook.com(415) 555-0188£1,980.00
4Acme Construction Ltd–GB94 BARC 1020 1530 0934 59info@acme-build.co.uk(646) 555-0142£12,400.00
5Thomas BakerNov 21, 1962GB29 NWBK 6016 1331 9268 19t.baker@yahoo.com(312) 555-0199£760.00
6Emily ClarkeAug 7, 1979GB60 LOYD 3096 3412 3456 78emily.clarke@proton.me(617) 555-0123£2,315.00
7      
8      
ClientsFeesDeadlines

Your formats and the AI tools you work with afterwards

  • Word
  • Excel
  • PowerPoint
  • Outlook (emails)
  • PDF
  • Scans & photos
  • TXT Text & CSV
  • ChatGPT
  • Claude
  • Microsoft Copilot
  • Gemini
  • Mistral
  • DeepL
  • Perplexity

Where personal data hides in studies

  • Open-ended answers and comment fields in questionnaires
  • Contact details for follow-ups or prize draws in the same export
  • Transcripts of in-depth interviews and focus groups
  • Names of staff that customers comment on
  • IP addresses and timestamps in raw online survey data

How it works

  1. 1

    Upload the export

    CSV or Excel from the survey tool, transcripts as Word or text.

  2. 2

    Clean free text

    Names, emails, phone numbers, addresses and IP addresses are replaced, answer codes stay unchanged.

  3. 3

    Analyse or deliver

    To the client, the coding team or AI-assisted text analysis, without respondents being identifiable.

Respondent anonymity as an industry standard

Professional codes for market and social research, such as the ICC/ESOMAR Code, require protecting respondents' identity and not passing personal data to clients without consent. For closed questions, removing the contact columns is enough. In open-ended answers, personal details are scattered through the text.

Diskretio detects those details in free text and replaces them, leaving the rest of the answer untouched. “The advice from [PERSON_1] at the branch was great” is just as useful for coding.

Careful with small samples

In B2B studies or employee surveys with small groups, combinations of role, location and department can identify someone even without a name. No automatic anonymization detects these features; generalise or suppress them in reporting.

FAQ

Questions. Answered briefly.

Try it with your own document

10 pages per month are free. No subscription, no credit card.