What this tool does
CSV exports can expose hundreds or thousands of records in one action. This tool parses quoted values, processes every cell locally, and generates a downloadable cleaned copy.
Column names are not automatically removed because they are often necessary to understand the dataset. Review headers such as notes, address, patient_id, account, and comments even when the sample values do not match a simple pattern.
Recommended workflow
- Duplicate the source fileNever overwrite the only copy of a business export.
- Use a limited sample firstTest a few rows and confirm that delimiters, quoted values, and line breaks are preserved.
- Run the anonymizerDownload the cleaned file and compare row and column counts.
- Review high-risk columnsManually inspect notes, comments, addresses, identifiers, and other organization-specific fields.
What it checks
The current tool version is designed to handle the following areas:
- emails
- phone numbers
- IPv4 addresses
- URLs
- common IDs
- two-word name patterns
Example
Before
name,email,customer_id
John Carter,john@example.com,CUST-4501Safer output
name,email,customer_id
[PERSON],[EMAIL],[ID]Safety checks before sharing
- Remove unneeded columns before anonymizing
- Check free-text cells manually
- Confirm no formulas or alternate delimiters are required
- Open the downloaded copy before sharing
Representative test coverage
This page is checked with representative examples, not every possible format or file produced by every application.
- comma-separated UTF-8 files
- quoted commas
- multiline quoted values
- small spreadsheet exports
Known limitations
Automated processing can miss unusual formats, indirect identifiers, hidden data, unsupported structures, and information that requires human judgment. This tool may miss:
- addresses
- single-word names
- free-text context
- internal numeric identifiers
- non-comma delimiters
- very large files that exceed browser memory
Do not describe the result as fully anonymous, legally compliant, secure, or impossible to re-identify. Review the exact final artifact before sharing it.
Frequently asked questions
Does CSV Anonymizer and PII Scanner upload my input?
The normal tool workflow runs in your browser. The page code is downloaded from the website, but the content you paste or select is processed locally and is not sent to a Privacy Toolbox processing API.
Can this guarantee complete anonymization?
No. Automated checks can miss context clues, unusual identifiers, text inside unsupported files, and details that only a person would recognize. Always review the result before sharing.
Should I use this for regulated or highly sensitive data?
Only when your organization permits it. For medical, legal, financial, employment, or customer data, follow your approved security and compliance process rather than relying on a free pattern-based tool alone.