Foreign characters when uploading a list in HubSpot.

SOLVE
Highlighted
New Contributor

Hi everyone, 

 

I am a new HubSpot user and I am having issues in uploading my list. 

 

I have a list that consists of Korean characters and when i uploaded it in HubSpot, the the property "First Name" (Which was in Korean characters), the value only showed "??????". 

Is there a way for HubSpot to automatically translate the foreign characters into English? If yes, how do we do that? If no, what would you suggest for me everytime i will import a list with a foreign character?

 

Hoping for your inputs! 

 

Thank you! 

0 Upvotes
1 Accepted solution

Accepted Solutions
Highlighted
Solution
HubSpot Product Team

Thanks for following up @rsantiago. Excel can be a little tricky when it comes to downloading CSV. files with special charactes. This help article guides you step by step on how to format and save your excel document to preserve these characters: How to include special characters in your import file

 

Second to this, I'd reccommend using Google Sheets for documents such as these - they tend to be more successful for imports of this kind!

 

View solution in original post

0 Upvotes
4 Replies 4
Highlighted
HubSpot Product Team

Hey @rsantiago could you confirm if you are using a csv. file from Excel or Google Sheets in this case?

0 Upvotes
Highlighted
New Contributor

Hi Roisinkirby,

 

I am using a CSV (Comma Delimited) excel sheet.

0 Upvotes
Highlighted
Solution
HubSpot Product Team

Thanks for following up @rsantiago. Excel can be a little tricky when it comes to downloading CSV. files with special charactes. This help article guides you step by step on how to format and save your excel document to preserve these characters: How to include special characters in your import file

 

Second to this, I'd reccommend using Google Sheets for documents such as these - they tend to be more successful for imports of this kind!

 

View solution in original post

0 Upvotes
Highlighted
Occasional Contributor

Hi, that link only takes us to a page where it states that I need utf-8 files for IMPORT. How can I get Unicode characters at EXPORT from Hubspot? 

 

Thanks, 

0 Upvotes