HubSpot import errors: quick fix checklist

Before importing to HubSpot, run through these common failure points:

Required fields

• Contacts: email is required and must be present and valid for every row.
• Companies: name is required.
• Unmapped required columns cause entire rows to be skipped or rejected.

Email format

• Email values must include @ and a valid domain.
• Blank email fields on contact rows will block those rows from importing.
• Watch for trailing spaces or line-break characters in email cells.

Phone fields

• Phone fields should use a consistent format across all rows.
• Mixed formats (e.g. +1 555-000-0000 vs 5550000000) can cause data inconsistency.

Date columns

• Avoid mixed date formats in a single file (e.g. UK vs US ordering).
• HubSpot expects dates in a consistent, recognized format.
• Normalize all date values before export.

Column headers

• Headers must be unique — duplicate column names cause mapping failures.
• Blank headers are not accepted.
• Keep headers lowercase and consistent to reduce mapping friction.