Paste your messy phone numbers in the left textarea. Choose a country and an output format, and copy the result to clipboard.
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.
E164 is the International Telecommunication Union recomendation. This format is compatible with most automated tools, and is independent of the dialer country.
This is the number with national prefix. This number most often cannot be use as is.
This is the number as you have to type it if you are calling from the same country.
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.