Import error: Header and row sizes don't match

Last updated: July 26, 2018


When you import a file into HubSpot, you can download a list of any errors that occurred during the import. 

You may find an error with the error reason: 

Header and row sizes don't match

This error means that you have information in some columns where there is no header indicating the field where those values should be stored. This can happen if your file once had additional columns containing information that were not deleted properly before importing the file. 

If you are opening the file in a spreadsheet editor (such as Excel) the extra columns may look blank, but if you open the file in a text editor (such as notepad), you should see a number of superfluous commas.
Extra commas in CSVTo correct this, you can search (Ctrl or Cmd + F) and replace all of those commas with one comma, then save and re-import your file.

Was this article helpful?

If you still need help you can get answers from the , or to contact support.

Free Inbound Marketing Training Learn inbound marketing techniques that range from creating content, using  social promotion, converting and nurturing leads, and all the way to marketing  to your customers. Start the course