To use Gmail and Yahoo contacts in Outlook for Windows (classic), export contacts from each service to a CSV file, then import those CSV files into Outlook.
1. Export Gmail contacts to CSV
- Sign in to Google Contacts.
- In the left column, select More (or the menu with contact groups).
- Choose the contact group or All Contacts.
- Select Export.
- Under Which contacts do you want to export, choose the group or All Contacts.
- Under Which export format, select Outlook CSV (for importing into Outlook or another application).
- Select Export and when prompted, choose Save.
- Save the file (for example,
contacts_gmail.csv) to a known location.
2. Import Gmail contacts CSV into Outlook (classic)
- In Outlook, select File > Open & Export > Import/Export.
- Choose Import from another program or file > Next.
- Select Comma Separated Values (DOS) (or Comma Separated Values) > Next.
- Select Browse, choose the Gmail CSV file saved earlier, and choose one of:
- Replace duplicates with items imported
- Allow duplicates to be created
- Do not import duplicate items
- Select Next.
- In Select a destination folder, choose the Contacts folder under the Outlook account where the contacts should live > Next.
- If needed, select Map Custom Fields to adjust how CSV columns map to Outlook contact fields.
- Select Finish.
3. Export Yahoo contacts to CSV
Use Yahoo’s export feature (per Yahoo help) to export contacts to a CSV file and save it locally (for example, contacts_yahoo.csv).
4. Import Yahoo contacts CSV into Outlook (classic)
Repeat the same Outlook import steps as for Gmail:
- File > Open & Export > Import/Export.
- Import from another program or file > Next.
- Comma Separated Values (DOS) > Next.
- Browse to the Yahoo CSV file and choose the duplicate-handling option.
- Next, select the appropriate Contacts folder.
- Optionally use Map Custom Fields.
- Finish.
After these steps, Outlook will contain contacts from both Gmail and Yahoo in the chosen Contacts folder(s).
References: