How to fix phone numbers in a spreadsheet so they're all the same format
Phone numbers end up as a mix of (555) 123-4567, 555.123.4567, and 5551234567 when they come from different forms and exports. To fix them, strip everything but the digits, then rebuild one format. You can do that with a formula, or let SheetSweep Clean format US phone numbers for you for free.
Option 1: Google Sheets formula
Say your numbers are in column A, starting at A2.
- In B2, strip out everything that isn't a digit:
=REGEXREPLACE(TO_TEXT(A2), "[^0-9]", "") - In C2, rebuild a 10-digit US number as (555) 123-4567:
=IF(LEN(B2)=10, "(" & LEFT(B2,3) & ") " & MID(B2,4,3) & "-" & RIGHT(B2,4), A2) - Drag both formulas down the column.
- Copy column C, then Edit > Paste special > Values only to keep the results without formulas.
Numbers with a leading 1 (11 digits) or an extension won't match the 10-digit rule, so they stay as they were for you to check by hand.
Option 2: Excel
Excel doesn't have a built-in regex function in every version, so the usual route is nesting SUBSTITUTE to remove spaces, dashes, dots, and brackets, then using Format Cells > Special > Phone Number on the digits-only result. It works, but it's fiddly.
Option 3: SheetSweep Clean (free, nothing uploaded)
Phone formatting is built into SheetSweep's free Clean tool.
- Open SheetSweep Clean.
- Choose your CSV, TSV, XLSX, or XLS file.
- Review the cleanup. You'll see every cell that changed, plus anything flagged for your decision.
- Download the cleaned file and its change log. Your original isn't touched.
Clean formats US phone numbers and, in the same pass, removes duplicate and blank rows, trims stray spaces, tidies emails and headers, and converts unambiguous dates to YYYY-MM-DD.
FAQ
Does it handle international numbers?
SheetSweep Clean formats US phone numbers. Values it can't safely format are flagged for review rather than guessed.
Will it change my original file?
No. You get a cleaned copy plus a change log of every edit.
Is my contact list uploaded anywhere?
No. The file stays in your browser tab the whole time.
Fix your phone column
Stop fixing numbers one at a time. Open SheetSweep Clean, it's free with no signup for files up to 4 MB.