Trying to impoert 100 contacts, getting error of blank header. The only blank headers are blank excel columns. Tried CSV but file has too many columns. I must be missing something here.
Hi @Tarpon ,
When importing contacts, HubSpot needs each column to have a header. Here’s the step by step process to ensure the import is done right
Step 1: Open file in Excel or Google Sheets and remove any blank columns from the sheet and make sure the every column has an header
Step 2: Make sure its saved as a CSV file and use this right file to import the contacts.
Link to the import file guide for your reference: Import records for multiple objects
If this helps, feel free to mark it as the solution
and give it an upvote
!
there are thousands of blank columns becasue they are unused, I also stated the CSV has too many columns. All used columnshave headers
It sounds like the extra blank columns in your file are causing the import to fail—HubSpot (and a lot of CRMs) get picky about that. Sometimes it could even been some formatting or cells that look like they don’t have anything in them, but there could be white text, formatting, etc.
The easiest way to always ensure this won’t happen it to completely delete any empty columns before exporting your file.
If you’re dealing with big or messy files often, Coefficient’s 2-way sync between HubSpot and Sheets/Excel can help - it’s here on the marketplace. You can push clean, structured contact data directly from your spreadsheet, map fields easily, and avoid import headaches like this altogether. Makes the process smoother in some cases.