Use a country calling code
Store each number in an international form such as +1 followed by the national number.
- Do not assume a default country for mixed lists
- Check whether a domestic trunk prefix must be removed
- Preserve the source value in a separate column when needed
Remove display-only characters
Spaces, parentheses, and hyphens may be useful for display but can make bulk imports inconsistent.
Create a normalized working column rather than overwriting the original CRM field.
Handle duplicates and spreadsheet conversion
Deduplicate the normalized value and prevent spreadsheet software from converting long numbers to scientific notation.
- Import the column as text
- Remove blank rows
- Check leading plus signs
- Review a small sample after export

