Validate phone number formats for HubSpot imports

Phone values are often inconsistent across regions and exports. TidyImports highlights likely invalid formats and keeps your import prep fast.

Common phone format problems

• Mixed formats in the same file: +44 20 7946 0958 vs 02079460958 vs (207) 946-0958.
• Missing country codes for international contacts.
• Extension numbers embedded in the phone field without a separator.
• Spreadsheet auto-formatting stripping leading zeros.

What to standardize before import

• Pick a consistent format for your dataset (e.g. E.164: +15550001234).
• Separate extension values into a different column if HubSpot has one.
• Remove formatting characters that may not be expected.