← Toolkit Home

PID Toolkit: CSV Pseudonymisation

Toolkit version: v?
PID Scheme: v?
Build ID: v?

Upload a CSV containing participant fields (first_name, last_name, dob).
To include a date suffix, add column include_date with text "Y", and the required date in the column date.
Enter the secret passphrase / seed below — it is never stored or exported. Output will add: sanitised_first_name, sanitised_last_name, pid, and pid_with_date (when a row explicitly requests and supplies a date).

CSV requirements
  • Required columns (case-flexible): first_name, last_name, dob (YYYY‑MM‑DD preferred)
  • Optional per-row date controls: include_date (Y/N) and date (YYYY‑MM‑DD or YYYYMMDD)
Preview (first 5 rows)

      

Output appends: sanitised_first_name, sanitised_last_name, pid, and pid_with_date (the last one is populated only where a row has include_date = Y and provides a valid date).