Import Error - INCORRECT_NUMBER_OF_COLUMNS

[MichaelHCO1]

Hello All - I wondered if I could get someone's assistane with the following.  I did spend a good deal of time researching within the help function, but no luck

Below are the errors that I keep getting during every import I do.... 

Error code	Object type	Reason	Row #
INCORRECT_NUMBER_OF_COLUMNS		Header (36) and row (1) sizes don't match	2
INCORRECT_NUMBER_OF_COLUMNS		Header (36) and row (26) sizes don't match	5

In my Google Sheet, HEADER 36 is called Lead Status, and the only text in the 2nd row is the word "New". The spreadsheet contains only two rows...

Row #1 - Headers

Row #2 - Data (text/numbers)

Row 3 to the end and Column 37 to the right are all blank.

Any assistance would be appreciated.  Thanks.

[MFrankJohnson · Accepted solution]

Difficult to help without seeing all the .csv headers.

Maybe  visually inspect the .csv export before attempting to use it. You may see extra rows containing "".

Help answer your question? If so, remember to accept this solution now.

Best,
Frank

Author, the Perfect HubSpot Series

---

MFrankJohnson.com | Connect on LinkedIn

Help find posts quickly ... accept this solution now.

[MichaelHCO1]

Hey Frank - Thanks for reaching out.  I did scan the columns to the right (as it was the last column with a header) and rows below for an data (text or numbers).  I even deleted the rows below about 500.  Maybe someplace in my template something is hiding??  I think I'll start with a fresh import google sheet to see if that clears it up.

I appreciate that you took the time to reply.

Michael 

[gelflex-cc]

@MichaelHCO1 I don't mean this as insulting,  but a reality check I also needed to do. Look at your spreadsheet and confirm the lead status you have listed match the available lead status in HubSpot. 

[MichaelHCO1]

Not my first rodeo with data sets and imports...I did confirm that the lead status I listed match the available lead status in HubSpot.