Paste your messy phone numbers in the left textarea. Choose a country and an output format, and copy the result to clipboard.

How to use to with Excel or LibreOffice Calc ?

You can use this tool to easily format a column of phone numbers in any spreadsheet.

1. Select the column you want to format, copy-paste it in the left area.

2. Select the numbers country and your output format, make sure Preserve lines with errors is checked.

3. Click Copy to clipboard. Go back to your spreadsheet, select the column you want, and paste the result.



Formating lists of phone numbers you recolted in spreasheets via forms or other user entries is often a headache. To use with automated tools or even for user readability, you need them to follow a unique format.

Which output format shoud I use ?

E164

E164 is the International Telecommunication Union recomendation. This format is compatible with most automated tools, and is independent of the dialer country.

International

This is the number with national prefix. This number most often cannot be use as is.

National

This is the number as you have to type it if you are calling from the same country.


Built with React and Google's libphonenumber - Created by @guilro

By using or accessing phonenumbers.tools in any way, viewing the website or using the service, you are agreeing to be bound by these Terms of Service : we provide the service "as is" without warranty of any kind. We disclaim any and all implied warranties or conditions, including any implied warranty of title, non-infringement, merchantability or fitness for a particular purpose, regardless of whether we know or had reason to know of your particular needs. We do not warrant that the service will be timely, secure, uninterrupted, or error free; nor do we warrant that errors in the service will be fixed or otherwise corrected.