Hola! ¡Tenemos nuestra Comunidad en Español!

Import Error - INCORRECT_NUMBER_OF_COLUMNS

SOLVE
Occasional Contributor

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 codeObject typeReasonRow #
INCORRECT_NUMBER_OF_COLUMNS Header (36) and row (1) sizes don't match2
INCORRECT_NUMBER_OF_COLUMNS Header (36) and row (26) sizes don't match5

 

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.

Reply
0 Upvotes
1 Accepted solution

Accepted Solutions
Highlighted
Community Thought Leader

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


hubspot-solutions-signature-mfrankjohnson-v05.png

MFrankJohnson.com | Connect on LinkedIn

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

Hope that helps.

 

Best,
Frank

 

MFrankJohnson-dot-com-HubSpot-Community-banner-gif-v20190817

4 Replies 4
Top Advisor

@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. 

Occasional Contributor

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.

Reply
0 Upvotes
Highlighted
Community Thought Leader

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


hubspot-solutions-signature-mfrankjohnson-v05.png

MFrankJohnson.com | Connect on LinkedIn

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

Hope that helps.

 

Best,
Frank

 

MFrankJohnson-dot-com-HubSpot-Community-banner-gif-v20190817

Occasional Contributor

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