Key Takeaways
- The free scrubber detects emails, phone numbers and IP addresses in a CSV before you share it.
- Each detected column can be masked, hashed or redacted, so you keep the shape of the data without the person.
- Detection and scrubbing run in your browser, so the file is never uploaded.
- It is a sharing aid, not a compliance guarantee, so review the result before it goes anywhere.
Introduction
You need to share a sample of your data with a vendor, a colleague or a support thread. The file works for the task, but it carries emails, phone numbers and IP addresses that have no business leaving your systems.
The free CSV PII scrubber finds those values and replaces them, so you can share the structure of the data without the personal detail. Open the CSV PII scrubber.
What Counts as PII in a CSV
Personal data is any value that can point to a person, directly or in combination. In a typical export the obvious ones are the values the scrubber detects:
- IP addresses: network identifiers that can point to a device or location.
- Email addresses: direct identifiers that often double as a login.
- Phone numbers: identifiers that are easy to trace and hard to change.
Names, postal addresses and account numbers are also personal data. The scrubber targets the three patterns above, so review the rest by column before you share.
Mask, Hash or Redact
For each column you decide how the value should change, and the choice depends on what the reader still needs:
- Mask: replace part of the value with symbols, so someone can confirm a format without reading the value. The original is not recoverable.
- Hash: replace the value with a fixed-length digest. Equal inputs give equal digests, so grouping and joins still work, but the text is not recoverable.
- Redact: remove the value entirely, the safest choice when the reader needs nothing from that column.
Privacy First
Detection and scrubbing happen in a background worker in your browser.
Nothing is uploaded, stored or logged, so the file being protected never travels anywhere to be protected.
How to Use It
- Open a CSV file or paste the content.
- Scan the detected emails, phone numbers and IP addresses by column.
- Choose mask, hash or redact for each column.
- Press Scrub and download the cleaned copy.
When to Scrub Before Sharing
- Preparing demo data for a presentation or a test environment.
- Sending a data sample to a vendor or consultant.
- Sharing a dataset with a colleague who only needs the structure.
- Reducing exposure before a file leaves your control.
- Attaching an export to a support ticket or bug report.
What Scrubbing Does Not Do
Scrubbing is a sharing aid, not a guarantee. Two things are worth keeping in mind.
- It is not a compliance sign-off. If your data is governed by a policy, review the output against that policy before it moves.
- It detects patterns, not meaning. A personal value in an unexpected format, or a name or address, is left in place.
Treat the scrubber as the cleaning step before a review, not a replacement for the review itself.
Share the Shape of the Data, Not the People in It
Sharing a file should not mean sharing the people inside it. The CSV PII scrubber finds the common identifiers, lets you mask, hash or redact them by column and hands back a copy you can share with confidence.
Because the whole step runs on your device, you never send the data out to protect it.
For recurring cleanups inside a spreadsheet, Flookup Data Wrangler brings data cleaning and matching into Google Sheets.