How to remove pii columns from a csv before sharing
- Step 1Export the dataset — Download the full CSV with PII columns from your CRM, database, or data warehouse.
- Step 2Open in Column Remover — Drop the file in. The tool reads headers without uploading any content.
- Step 3Select all PII columns — Tick Name, Email, Phone, AddressLine1, PostCode, and any other identifiable columns.
- Step 4Download the anonymised output — Export the stripped file and share it safely with your external party.
Frequently asked questions
Does this hash or mask the values instead of deleting them?+
The current tool deletes the entire column. For masking specific cells, use CSV Find & Replace to overwrite values.
Is this approach GDPR compliant?+
Removing identifying columns is a standard anonymisation step, but full GDPR compliance depends on your overall process. Consult your DPO for data-sharing agreements.
Can I undo a column removal?+
The tool does not modify your source file. Keep the original and only share the downloaded output.
Privacy first
Processing runs locally in your browser with PapaParse. No file is uploaded — only metadata counters are saved for signed-in dashboard stats.