Mask Customer Data Before You Share a Report
Reports travel. A file sent to an agency, a vendor or another team should not carry more personal data than it needs.
Finance and marketing files often hold more personal data than the report needs: customer names, emails, phone numbers, account or card numbers and addresses. Sending the full file to a partner or pasting it into a ticket creates a risk that is easy to avoid.
The first question is what the reader needs. If they only need totals by campaign or by product, remove the personal columns. If they need to match rows, keep an identifier but mask the rest. Data Masking finds columns that look like personal data, such as emails and phone numbers, and replaces the values with masked ones while keeping the row count and the other columns.
Choose the method to fit. You can redact a value, mask it partly (for example keeping the last digits), replace it with a realistic fake value or hash it. The option Same input gives same output keeps joins and counts working inside the file. Check how each choice affects the analysis.
Verify the result. Open the masked file, look for any column the tool did not detect, and search for leftovers such as emails inside a notes column. The tool reports what it found, but you remain responsible for checking free-text fields.
Masking is not the same as anonymisation under a privacy law, and this article is not legal advice. Keep the original file secure, and follow your organisation policy on what may be shared. The masking runs in your browser, so the original file is not uploaded to Data Utility.
Related tool pages
- Mask Emails in a CSV File: Hide email addresses and phone numbers in a CSV file before you share it. Detects personal columns for you. Free, in your browser.
- Anonymize CSV Data: Anonymize a CSV before sharing it: hide names, emails, phones and card numbers with the method you choose. Free, in your browser.
- Mask PII in Excel Files: Find and hide personal data in an Excel file before you share it, such as emails, phone numbers and names. Free, in your browser.
- Mask Phone Numbers in a CSV: Hide phone numbers in a CSV, Excel or JSON file before you share it. Keep the country code or last digits, or replace with fake numbers. Runs in your browser.
- Mask Credit Card Numbers in a File: Find card numbers in a CSV or Excel file and mask them, keeping only the last 4 digits. Free, private, no upload.
- Mask Names in a CSV File: Replace real names in a CSV, Excel or JSON file with fake names or initials, so you can share the data safely. Free, in your browser.
How to use the Data Masking: step by step
- Open Data Masking and load the file.
- Review the personal columns it found and add any it missed.
- Choose how each column is masked.
- Download the masked file and check free-text columns by hand.
When to use the Data Masking
- Share a report with an agency or vendor
- Attach a sample to a support ticket
- Prepare a dataset for training or testing
- Remove personal data before storing a file
Example
Input: ada@example.com, +1 555 0100
Output: a**@example.com, +1 *** ****
Frequently asked questions
What is data masking?
Hiding or replacing sensitive values, such as emails, phones and names, so a file can be shared or tested without exposing real people.
Which masking methods are available?
Fake data, partial masking, hashing and noise for numbers, with consistent masking so the same input gets the same result.
Is my file uploaded?
No. Masking runs in your browser, so the real values never leave your device.
Is masking the same as anonymizing?
Not always. Combined details can still identify people, so review before sharing.
Tip: Check free-text columns such as notes. Emails and phone numbers can hide inside them.