Contact import failing

SOLVE
Highlighted
New Contributor

I keep getting the error message "Something Went Wrong" when attemping to import my contact cvs file. No futher explanation for the error is given.

 

There are no blank spaces in the file, every contact has an email address, and there are no funny characters. What could be going wrong?

Reply
0 Upvotes
1 Accepted solution

Accepted Solutions
Highlighted
Solution
HubSpot Employee

Hi @GFigueroa,

 

I wanted to let you know that I was able to import a new copy of the CSV that you provided into your protal.  It looks like the original file was encoded in a way that Hubspot was having difficult reading.  The file that you sent me was in UTF-16 format, but CSVs imported into Hubspot must be in UTF-8.  

 

In addition to the steps in the link above, a quick solution is to copy all of the data into Google Sheets, and export the CSV from there.  There are typically less encoding issues from Google Sheets.

 

I hope this helps!

Brett

 

 

View solution in original post

Reply
0 Upvotes
10 Replies 10
Highlighted
HubSpot Employee

Hello @GFigueroa,

 

Welcome to the Hubspot Community and thank you for your question!

 

Can you please try clearing your browser's cookies and cache and try again?  Also, please try using a different web browser.  If neither of these suggestions work, can you please private message me a link to the file hosted online somewhere (Google Drive or Dropbox)?

 

Thank you,

Brett

Reply
0 Upvotes
Highlighted
New Contributor

Brett,

 

Thanks for the response! Unfortunately those methods didn't work. I'll shoot over the file to you.

Reply
0 Upvotes
Highlighted
HubSpot Employee

Hi @GFigueroa,

 

I received your private message.  Can you please explain at what point you see the error message in the import process?  Below are the steps that one takes during the import process - let me know where you are experiencing the error.

 

1. Go to contacts > actions > import contacts.

2. Strat a new import > Contacts > Select a file > Upload.

3. Import Name and Select a lifecycle stage (let me know which lifecycle stage you are selecting) > "Next, map your properties"

4. Map your properties > "Next, confirm additional options"

5. True > True > True > Enter your initials and "Finish Import"

 

Thanks,

Brett

 

Reply
0 Upvotes
Highlighted
New Contributor

Hey @BrettLanguirand,

 

I make it through all of these steps successfully. Only at the very end after clickling "finish import" does the "Something Went Wrong" message appear.

Reply
0 Upvotes
Highlighted
HubSpot Employee

Hi @GFigueroa,

 

I'd like to attempt to import the CSV into your portal to see if I can reproduce the issue.  Which lifecycle stage would you like to import these contacts as?  

 

Brett

Reply
0 Upvotes
Highlighted
New Contributor

@BrettLanguirand,

 

Lead is fine, thank you!

Reply
0 Upvotes
Highlighted
Solution
HubSpot Employee

Hi @GFigueroa,

 

I wanted to let you know that I was able to import a new copy of the CSV that you provided into your protal.  It looks like the original file was encoded in a way that Hubspot was having difficult reading.  The file that you sent me was in UTF-16 format, but CSVs imported into Hubspot must be in UTF-8.  

 

In addition to the steps in the link above, a quick solution is to copy all of the data into Google Sheets, and export the CSV from there.  There are typically less encoding issues from Google Sheets.

 

I hope this helps!

Brett

 

 

View solution in original post

Reply
0 Upvotes
Highlighted
New Contributor

@BrettLanguirand,

 

Thank you so much! I just tried uploading a different file and didn't have any issues this time. I really appreciate your help!

 

Giovanna

Reply
0 Upvotes
Highlighted
Visitor
I just imported 510 contacts only got 1 error but I can only see 236 contacts did I do something wrong or am I missing something please help ! - Marley
Reply
0 Upvotes
Highlighted
HubSpot Employee

Hello @Marleybeezie

 

Do you have any filters in the left column added to your view that could be preventing all of the contacts from displaying?  

 

Brett

Reply
0 Upvotes