Skip to content
CSVTidy
Import checker

Will this file import into HubSpot?

Find out before you upload. This checks your spreadsheet against HubSpot's real contacts rules, maps your columns to its field names, and shows you exactly which rows would be rejected — with row numbers.

Runs in your browser. Nothing is uploaded.

Drop a CSV or Excel file here

Or choose a file — nothing leaves your browser.

What we check

Email is HubSpot's unique identifier for contacts, so a missing or duplicated address is what usually breaks this import. Lifecycle Stage must also match HubSpot's fixed list exactly.

Required by HubSpot
  • Email — used to deduplicate
File rules
  • Save as CSV (UTF-8) or XLSX — non-UTF-8 files mangle accented names.
  • One contact per row, with column headers in the first row.
  • Email is the default unique identifier: duplicates merge into one contact.

Common questions

Which columns does HubSpot require for contacts?

Email. Rows missing it are rejected. This page checks every row for you and lists the ones that would fail.

Why did my HubSpot import fail?

Email is HubSpot's unique identifier for contacts, so a missing or duplicated address is what usually breaks this import. Lifecycle Stage must also match HubSpot's fixed list exactly. Drop your file above and you'll get a row-by-row list of what HubSpot would reject, with the row numbers.

Is my file uploaded anywhere?

No. The mapping and validation run entirely in your browser using JavaScript. Your spreadsheet never reaches our servers, which matters when the file is a customer list.

Does it change my data?

It renames your column headers to HubSpot's exact field names and reformats values that HubSpot would otherwise reject — phone numbers, yes/no fields and picklist casing. Every change is listed before you export, and nothing that can't be safely converted is touched.

Field rules sourced from HubSpot's own documentation.