CSV PII Cleaner
Mask emails, phones, SSNs, and cards in CSV records.
Mask emails, phones, SSNs, and cards in CSV records. Enter your numbers and get an instant result.
Paste CSV records, name the columns to clean or leave the list empty for all of them, and the page returns the same table with emails, phones, social security numbers and card numbers masked in place.
This page executes on the tool server: the CSV text, the column list and the single mask character are sent for that one request, the scrub runs there, and nothing is stored. An empty paste is refused with the reason, and the mask must be exactly one character.
The table keeps its shape: masked cells stay in their rows and columns, and the response reports the character counts before and after so the scale of the scrub is visible.
What the scrub covers
Each cell in scope is matched against the four PII shapes and the sensitive text is replaced with the mask character. Columns outside the named list pass through byte-identical, so identifiers you need can be kept while the rest is cleaned.
Masking is replacement, not redaction review: the page hides the matched shapes it knows and reports the counts, but a value shaped like none of the four passes through as written.
- Emails, phones, SSNs and card numbers
- Named columns or every column
- Single mask character, star by default
What is sent and what is kept
The request carries the CSV, the columns and the mask, and the response carries the sanitised table with its counts. Neither is written to disk or logged; a second paste is a second request with no memory of the first.
A scrub that throws is reported with the reason rather than returned half-masked, so a failed run never looks like a cleaned table.
How to use the CSV and columns
Paste the CSV records into the paste box, name the columns to clean in the columns field or leave the list empty for all of them, keep the single mask character, and press Execute Tool Engine. Each cell in scope is matched against the four PII shapes, emails, phones, social security numbers and card numbers, and the sensitive text is replaced with the mask in place.
Columns outside the named list pass through byte-identical, so identifiers you need can be kept. The table keeps its shape with character counts before and after; a scrub that throws is reported with the reason rather than returned half-masked.
What to Expect
Best for
- Stripping PII before sharing a CSV export
- Masking contact columns while keeping the rows
- Preparing demo data from real records
Not ideal for
- PII shaped unlike the four covered kinds
- Certified anonymisation for regulated data
- Cleaning non-CSV text
What this tool keeps
- Every row and column in place
- Untouched columns byte-identical
- Your records private beyond the single request
What may need cleanup
- Reviewing values the four shapes miss
- Checking the counts against the source
- Confirming the policy the cleaned file must meet
Common errors
- Reading masked as anonymised for compliance
- Expecting names or addresses to be caught
- Pasting with no columns named and missing the scope
Example use cases
- Sharing a support export without emails
- Masking phone columns before analysis
- Building a demo from production rows
Sample input
CSV records with email and phone columns, cleaned in every column with the star mask.
Sample output
The same table with sensitive values masked and the before-and-after character counts, scrubbed on the tool server.
Who this is for
- Support teams sharing exports
- Analysts preparing demo data
- Anyone stripping contact PII from CSVs
Frequently asked questions
What counts as PII here?
Emails, phone numbers, social security numbers and card numbers found in the CSV cells. Each is masked in place so the table keeps its shape.
Can I clean only some columns?
Yes. Name the columns to sanitise and the rest pass through untouched; leave the list empty and every column is checked.
What is the mask character?
The single character that replaces sensitive text, star by default. One character only: a longer mask is refused rather than truncated silently.
Build custom tools for your store
Join the SDK program to create useful ecommerce utilities for your store.