CRM

LB2
Member

Unable to import contacts

SOLVE

When I try and upload an Excel Sheet of contacts I get this popping up each time:

Hub.PNGThe sheet I am uploading only has one tab on it with 8 columes that include: First Name, Last name, Phone Number, Mobile number, Address, Company name, email address, notes).

 

If I select the option of uploading multiple sheets then I get the same error:

Hub 1.PNGHub 2.PNGHub 3.PNG

Please help!

0 Upvotes
2 Accepted solutions
franksteiner79
Solution
Key Advisor

Unable to import contacts

SOLVE

Hi @LB2 

 

Based on the error message your XLSX file has more then one tab or worksheet, hard to tell without seeing a screenshot of the import sheet. Have you tried exporting your worksheet as a CSV and importing that into HubSpot?

 

The multiple file option you are showing is when you literally have two seperate Excel files - not multiple worksheets in one Execl file.

 

I hope that helps.

 

Frank

Found my comment helpful? Great! Please mark it as a solution to help other community users.


Frank Steiner

Marketeer | HubSpot Expert | CRM Consultant

InboundPro

Let's Talk About Your Project

View solution in original post

TomM2
Solution
Thought Leader | Platinum Partner
Thought Leader | Platinum Partner

Unable to import contacts

SOLVE

Hey @LB2 are you sure there are no empty sheets within your spread sheet? If it only has 1 sheet/tab then you could try export the file as a CSV instead of an xlsx file. Csv can only have one sheet so you should get around this issue with that if you try! 

Tom Mahon
Technical Consultant | Solutions Engineer | Community Champion
Baskey Digitial

Book a consultation

Did my post help answer your query? Help the community (and me) by marking it as a solution.


View solution in original post

2 Replies 2
TomM2
Solution
Thought Leader | Platinum Partner
Thought Leader | Platinum Partner

Unable to import contacts

SOLVE

Hey @LB2 are you sure there are no empty sheets within your spread sheet? If it only has 1 sheet/tab then you could try export the file as a CSV instead of an xlsx file. Csv can only have one sheet so you should get around this issue with that if you try! 

Tom Mahon
Technical Consultant | Solutions Engineer | Community Champion
Baskey Digitial

Book a consultation

Did my post help answer your query? Help the community (and me) by marking it as a solution.


franksteiner79
Solution
Key Advisor

Unable to import contacts

SOLVE

Hi @LB2 

 

Based on the error message your XLSX file has more then one tab or worksheet, hard to tell without seeing a screenshot of the import sheet. Have you tried exporting your worksheet as a CSV and importing that into HubSpot?

 

The multiple file option you are showing is when you literally have two seperate Excel files - not multiple worksheets in one Execl file.

 

I hope that helps.

 

Frank

Found my comment helpful? Great! Please mark it as a solution to help other community users.


Frank Steiner

Marketeer | HubSpot Expert | CRM Consultant

InboundPro

Let's Talk About Your Project