Cannot retrieve data when importing contacts from gmail to outlook

Hey there

I'm here to help.

Can you please convert your CSV file to UTF-8 using Microsoft Excel:

In Excel, create a new blank document (workbook).

From the Data menu, select From Text/CSV. Browse to your exported CSV file (you may have to select to display Text Files (....csv) to see it). Select Import.

In the dialog box that appears, under File Origin, choose the encoding that makes the characters in the text appear correctly, for example, Cyrillic Windows 1251, and then select Load.

Check that characters are displayed correctly in Excel.

Select File >Save As. Enter a name for your file, and select CSV UTF-8 (Comma delimited) (*.csv) as your file type.

Select Save.

Now try importing again.

Please find below microsoft page for more details on importing gmail contacts into Outlook

https://support.microsoft.com/en-us/office/import-gmail-contacts-to-outlook-edbacfde-f48c-49da-a6a3-bcbb8f4f4819

More info from microsoft on importing contacts into Outlook (Web)

https://support.microsoft.com/en-us/topic/bb796340-b58a-46c1-90c7-b549b8f3c5f8

I'm adding import/export guide document here for your reference.

https://support.microsoft.com/en-us/office/import-and-export-outlook-email-contacts-and-calendar-92577192-3881-4502-b79d-c3bbada6c8ef

I hope it helps