"Header Missing" message when importing excel file

[RachelLura]

Hello,

I'm importning about 100 new contacts into my CRM. To do this, I created Excel spreadsheet with header names matching those set up in my CRM. When I attempted to import the spreadsheet, I keep getting an error messsage "Check your import file and make sure each column with data has a header". I've tried formatting the spreadsheet as a table with header, bolded the font, increased font size, to no avail. 

I've imported data before to the CRM and it worked. Not sure what I am doing differently this time. 

Thank you,

Rachel

[FWalsh2]

Hi, just adding an update on this. Experience the same issue this week when importing a new list, I read above about copying the columns into a new spreadsheet and this actually worked for me. Just wanted to say that @TitiCuisset thanks for the heads up 👍

[mld20005 · Accepted solution]

I was having this exact problem and turns out for me, it had nothing to do with the Headers (that were already there).  The problem was the file name - I had a plus-sign "+" in the file name and I think that is what Hubspot rejected.  I renamed the file and it worked just fine.  Hope this helps someone!

[Anonymous]

Thanks for the info.

[jennysowyrda]

Thank you for sharing @mld20005 ! 

[drzeeofficial]

To resolve the issue, select and copy all the columns with headers and values from your Excel sheet. Then, paste them into a new Excel file. Importing the data from the new file should now be error-free

[ADeLaRosa51]

This worked!  Thanks

[TitiCuisset]

Hi @RachelLura 

Thank for posting in the Community! 

Could you try to copy only the columns/lines having information in them from your excel sheet, paste that in another excel sheet and then try again? 

Thank you

Tiphaine

[RachelLura]

Thank you Tiphaine! It worked!

The only two things that didn't populate are "Type of Contact" and "Vendor Type", both of which have checkboxes, and Type of Contact usually has multiple checkboxes. Unelss there is a magical way to update that info, I'm okay with it for now 🙂

Much apprecited!

Rachel

[TitiCuisset]

Hi @RachelLura 

If it is not populating, it is probably because the value you have put in the excel does not match exactly a possible value in your checkboxes/dropdown field property. If the system cannot find exact matching values, it won't import. 

To import correctly multiple checkboxes properties, I would advise you to have a look at the following article:
Import data to checkbox properties 

Hope that helps

Best, 

Tiphaine