"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

[RKon]

That error usually means one of the columns with data is missing a proper header, even if it looks fine visually, sometimes extra spaces or hidden characters sneak in. Try opening it in a plain text editor or saving as CSV to double-check.

If it keeps acting up, Skyvia’s import tool is a solid workaround that handles these quirks better.

[victoriahcw]

Instead of uploading an entire spreadsheet, you can also look into using other tools to export data from your Excel file. I've been using one called Coefficient and one of their features allows you to export live data from Excel directly into HubSpot. It's been great because this tool is quite easy to use and allows you to manually select the mapping of your headers. So for instance, if your header names don't match exactly in HubSpot, you can still perform a successful export.

[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!

[SRamachandra]

Unfortunately that didnt work for me.  It still says can't find the headers

[SRamachandra]

Solved it

[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