Can I validate a HubSpot contact CSV before importing it?+
Yes. This local preflight checks contacts-only quick-import structure, headers, identifiers, duplicate rows and emails, selected property formats, tier limits, and workbook shape. It cannot query a HubSpot portal or guarantee acceptance.
Does the validator upload contact data?+
No. Parsing, type choices, findings, masked evidence, normalization, and downloads remain in the browser tab. No contact value is sent to HubSpot or csvtodashboard.
Which files work with HubSpot contact quick import?+
HubSpot documents CSV, XLSX, and XLS contact files with one sheet, a header row, one contact per row, and a separate column for each property.
What identifies an existing HubSpot contact?+
Email, Record ID, or a custom property configured with unique values can identify records. Record ID takes precedence when it is included, and Email still must remain unique.
Will a blank cell clear an existing HubSpot value?+
No. HubSpot ignores blank cells during import, so they do not clear existing property values. Clearing values needs a separate deliberate workflow.
How should multiple checkbox values be formatted?+
Separate values with semicolons and no spaces. A leading semicolon can append values instead of replacing them, but the destination property's available options still need portal review.
What file limits does the preflight check?+
It checks the documented 20 MB Free tools or 512 MB paid file limit, fewer than 1,000 columns, the paid per-file row ceiling, and the Free rolling-day row limit as an account-dependent review.
Can a clean preflight replace a small test import?+
No. A local file cannot prove custom property existence, owner users, enumeration options, timezone behavior, account settings, existing records, or downstream automation. Import and inspect a controlled test first.