In Outlook 2013 or 2016 Microsoft has for some reason removed the Excel import feature! Outlook will not import Chinese from a CSV file (even a CSV UTF-8 file that retains Chinese text), so for now we're stuck looking for other solutions.

Then import into Outlook as an Excel file.

Be careful to match the order and columns for English contacts.

Copy/paste the Chinese names into the appropriate Outlook fields in the outlook.csv file.

Open contacts.csv in Excel, and save it as an Excel file (.xls Office 97-2003 format) so that it will retain the Chinese characters and be ready for import.

In the 'Get External Data' group, click 'From Text'. (In Outlook 2007 or 2010, click the 'Data' tab.

Import google.csv into Excel using the Text Import Wizard.

Export for both Gmail (google.csv) and Outlook (contacts.csv).

In Outlook 2007 or 2010 you can still import that data, after some editing:

(When you export in 'vCard' format the Chinese is in there, but this file is in Apple Address Book format so Outlook cannot read it.).

When you export in 'Outlook CSV' format, it saves in ASCII text I think, and then the Chinese turns into garbage characters or just disappears.

When you export in 'Google CSV' format, it saves in Unicode text and it will display Chinese OK, but the field (column) order is all wrong for Outlook.

The problem here is the way Gmail exports your contacts: FAQ: Importing Chinese contacts to Outlook from Gmail and CSV files :: Pinyin Joeįrom Gmail into MS Outlook? When I export them I see '?' in place of the characters.

Import csv into outlook 2016 mac