I can't import Google contacts into Outlook Classic

Question

I can't import Google contacts into Outlook Classic

Anonymous

Dear Community friends, my problem, which seems very simple to me, has not received any effective answers for over three weeks, neither from Microsoft support services nor, unfortunately, from users of various forums.

The issue is as follows: I have a 365 family contract and use the Classic version of Outlook.

I had to delete all my contacts from Outlook, thinking that I could reimport them from Google Contacts, where I have over 1,500 well-maintained contacts.

Unfortunately, every attempt to generate a .csv file for Outlook has proved futile, as the structure of the file exported from Google, as specifically indicated for Outlook, does not match the actual file, as the individual fields are not laid out as Outlook would like.

The suggestions I received from the forums were unable to resolve this simple issue, and Microsoft replied that importing Google contacts into Outlook Classic is now only possible for Microsoft 365 Business users (!!!????!!!).

Is there anyone who can help me, or will I have to abandon Outlook and move all my email to Gmail?

Thank you

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Answer 1

I would hope that the problems are not with each individual contact row, but how the columns are arranged in the CSV or how you are doing the mapping.

I've looked for something about your specific problem (Google -> Outlook) but I'm not finding much.

All I can suggest is a couple of articles that go over the general process step-by-step. I wish I could give you a better answer.

https://www.myexcelonline.com/blog/import-csv-contacts-in-outlook/

https://support.microsoft.com/en-us/office/create-or-edit-csv-files-to-import-into-outlook-4518d70d-8fe9-46ad-94fa-1494247193c7

Answer 2

Anonymous

I have 1,700 contacts, and Outlook reports an error for almost all of them. According to Microsoft, how many hours would I need to spend manually correcting the .csv file?

0 comments

Answer 3

Anonymous

Thank you, but I don't seem to have understood the problem

0 comments

Answer 4

One way to know how the CSV should look.

Create an Outlook Contact with clearly indicated values. e.g.

First Name: FIRST_NAME

Last Name: LAST_NAME

Company: COMPANY_NAME

E-mail 1: EMAIL_01

e-mail 2: EMAIL_02

...

Export your contacts to a CSV.

Pick out this one row.

This gives you a map of columns in the CSV to Outlook fields. Hack the Google CSV until it matches this map.

Answer 5

Anonymous

Read the comments as well as the Answer.

0 comments