How to Mask Phone Numbers in a List Before You Share It

To mask phone numbers, replace most of the digits and keep the last two to four. The bulk phone number masker does it for a pasted list or CSV: (415) 555-0132 becomes (XXX) XXX-0132, with the brackets and dashes kept so it still looks like a phone number. It runs in your browser, so the full numbers never leave your device.

Why mask a phone column

A phone number is personal data. Support tickets, screenshots, shared sheets, demo data and bug reports often need to show that a number is there, and which one, without giving it away. The last few digits let a person find the right row.

Step 1: paste the list

Paste numbers, or upload a CSV and the phone column is found for you.

Step 2: choose how much to show

Pick how many digits stay visible at the end (0 to 6) and the character that hides the rest: X, an asterisk or a bullet. Digits are replaced one for one, so the length and layout stay the same.

Step 3: decide about the country code

A number written with a + can keep its country code visible, since the code names a country, not a person. The code is read from the numbering plan. Extensions are masked in full.

Step 4: check and download

Check the preview, then download the CSV or copy the masked column. Numbers with no more digits than you chose to keep are left as typed and marked.

The by-hand way in Excel or Sheets

On a column of plain digits, keep the last four:

=REPT("X",LEN(A2)-4)&RIGHT(A2,4)

That loses the brackets and dashes, and it fails on any cell that still has punctuation, spaces or an extension. Strip the column first with how to remove dashes and spaces from phone numbers. Mind that a spreadsheet may also drop leading zeros: see how to keep leading zeros when opening a CSV. To hide email addresses the same way, use the email address masker.

Keep the original

The original file still holds every digit. Masking changes the output only. Keep the original somewhere safe and share only the masked copy, and delete the original column if the number must not appear at all.

What this tool cannot do

• It hides digits in the output only. The original file still holds the full numbers.
• It is not a substitute for deleting data that privacy rules say must go.
• The last digits and the layout can still help someone narrow down a number.
• It does not check a number is valid. Use the bulk phone number validator for that.

Does a masked number tell you anything about activity

No. Nothing here contacts a phone network, so a number that passes is only well formed. If the same list has email addresses, check them on the verify page: the first 100 email checks are free with a Google sign-in, no card. Each comes back valid, risky or invalid with a reason, and nothing is sent to anyone on the list. For larger or recurring lists, see bulk email verification, list cleaning and pricing.

Mask your numbers now

Paste the list into the bulk phone number masker.