Skip to content
toolsdocks

Format Phone Numbers in Excel or CSV

Open an Excel or CSV file, choose the phone column and a default country, and get every number in one format. This page opens the contact list formatter on the file input with only the phone column selected.

Runs on your device

More options in the full Email and phone list formatter.

Loading tool…

How to use it

  1. Choose a CSV or Excel file; pick the sheet if the workbook has several.
  2. Check the Phone column the tool picked, or choose another.
  3. Set the Default country and the Phone format: E.164, International or National.
  4. Review the flagged rows, then download the CSV or XLSX.

Worked example

With the default country US and E.164 format, (415) 555-0132 becomes +14155550132. The same number written 415-555-0132 gives the same result and is flagged as a duplicate of row 1, +44 20 7946 0958 becomes +442079460958, and 12345 is flagged as the wrong length.

Formats and limits

InputCSV, TSV, XLSX, XLS, ODS
OutputCSV, XLSX
Enginelibphonenumber-js metadata; RFC 5322-based syntax checks and typo detection for common domains

Limitations

  • Numbers are checked against numbering-plan data, which cannot tell whether a line is in service.
  • For an invalid number the phone_clean value is only an approximation; use the status column to find it.
  • One file at a time, and one sheet of a workbook at a time.

Questions

How are numbers without a country code read?

With the default country you choose. With United States, (415) 555-0132 becomes +14155550132. A number written with + and a country code, or a 00 prefix, keeps its own country.

What does invalid mean?

The number does not fit its country's numbering plan, for example the wrong length. It is flagged with the reason in the status and flags columns. A valid number is not proof that the line works.

Does it change my original column?

By default it adds phone_clean and phone_status columns and leaves yours alone. Tick Replace original values to overwrite the column instead.

Is my file uploaded?

No. The file is read and formatted in your browser; the number rules load from this site and nothing from your file leaves your device.

Privacy

Runs on your device. Files and text are processed in this browser tab and are not uploaded.

This page opens the Email and phone list formatter ready for this task. See the privacy policy for how toolsdocks handles data.