How to use it
- Choose a CSV or Excel file; pick the sheet if the workbook has several.
- Check the Phone column the tool picked, or choose another.
- Set the Default country and the Phone format: E.164, International or National.
- 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
| Input | CSV, TSV, XLSX, XLS, ODS |
|---|---|
| Output | CSV, XLSX |
| Engine | libphonenumber-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.