Skip to content
NoClutterCRM

Free spreadsheet check

Phone number formatter

Turn the phone numbers in a contact CSV into one international format. Numbers that cannot be formatted are flagged for review instead of guessed.

  • Free to use
  • No signup
  • Stays in your browser

Enable JavaScript to use this tool in your browser.

Worked example

With the United Kingdom chosen, 020 7946 0018 becomes +442079460018. A number a spreadsheet saved as 4.47701E+11 is flagged, because its missing digits cannot be recovered.

A valid format does not prove a number is in use, reaches a mobile or is registered on WhatsApp. The original column is kept unchanged, and the formatted numbers are added in a new column beside it.

How to format phone numbers in a contact list

Phone numbers collected over time arrive in every style: with and without the country code, with spaces, brackets or dashes, sometimes with an extension. CRMs, calling tools and WhatsApp work best when every number is written the same way, in international format.

Choose the column with the numbers and the country to use for numbers written without a country code. Numbers that already start with + or 00 keep their own country. Each number is checked against its country’s numbering rules and written as +442079460018, or with spaces if you prefer.

Anything that cannot be formatted with confidence is flagged instead of changed: cells holding two numbers, text, too few digits, or numbers a spreadsheet has turned into scientific notation. Your original column stays in the download, so you can compare every change.

Phone number formatter questions

What is E.164 format?

The international standard for writing phone numbers: a +, the country code and the number, with no spaces or punctuation, such as +442079460018. Most CRMs and messaging tools accept it.

What happens to numbers without a country code?

They are read using the country you choose, and the check column says that country was assumed. If your list mixes countries, add the country codes in your spreadsheet first, or format each country’s rows separately.

Does a formatted number mean it works on WhatsApp?

No. The formatter checks that a number follows its country’s numbering rules. It cannot tell whether the number is in use, is a mobile or is registered on WhatsApp.

Is my contact list uploaded?

No. The file is read in your browser tab and never sent to NoClutterCRM. It can be up to 5 MB and 10,000 rows.