CleanCSV

Clean Up Phone Numbers in CSV and Excel Files

Turn “+1 (555) 010-2030” and “555.010.2030” into consistent digit-only numbers that CRMs, SMS tools and dialers accept.

Free, no sign-upFiles never leave your deviceCSV, Excel & JSON

CSV & Excel cleaning workspace

No account. No uploads. Just clean data.

100% in your browser
1

Upload your file

Drop your CSV or Excel file here

or browse your device. You can select several files at once.

CSV, TSV, TXT, XLSX, XLS, ODS and JSON · up to 50.0 MB and 250,000 rows

Your files never leave your device.

Step by step

How to use this tool

  1. 1

    Drop your CSV or Excel file into the tool above. Columns named Phone, Mobile, Cell, Tel or Fax are detected automatically.

  2. 2

    Clean phone numbers is on. Spaces, dashes, dots, slashes and brackets are removed, and a leading + is kept.

  3. 3

    Check the preview, then download.

Conservative on purpose

Only values that are clearly a single phone number, made of digits and common punctuation with 7 to 15 digits, are reformatted. Values with extensions, words or several numbers, like “555-0102 ext. 4” or “call after 5pm”, are left exactly as they are, so digits are never merged by accident.

Adding a country code

Many tools want E.164 numbers such as +447700900123. If your numbers are all from one country and start with a trunk 0, use Find & replace on the phone column with Regular expression on: find ^0 and replace it with +44 (for the UK) or your own country code.

Keeping numbers intact in Excel

Excel drops leading zeros and the + sign when it opens a CSV file. When you download as .xlsx, values like 07700900123 are stored as text so they stay intact. If you open a CSV in Excel instead, import it with Data > From Text/CSV and set the column type to Text.

Frequently asked questions

Does it validate phone numbers?

It checks the characters and the number of digits, not whether the number exists or fits a country's numbering plan.

Will it remove the + sign?

No. A leading + is kept and every other non-digit character is removed.

My column is not called Phone. What can I do?

Use Find & replace on that column with Regular expression on: find [^\d+] and leave the replacement empty to keep only digits and +.