Contact Problems

How to Export an Outlook Contact List to Gmail as a CSV File

Steven Parker Oct 19, 2026 868 views

Question details

The user needs to export a specific contact list (distribution group) from Outlook and import it into Gmail as a CSV file, bypassing the default limitation where Outlook exports all contacts instead of a targeted group.

How to Export an Outlook Contact List to Gmail as a CSV File

Product: Microsoft Outlook and Gmail
Device & OS: not provided
Scenario: Migrating a specific distribution group or contact list from Outlook to Google Contacts without mixing them with general contacts.
Observed behavior: Outlook's native export tool outputs all individual contacts rather than isolating the members of a specific contact list, making it difficult to maintain the group structure when importing to Gmail.

Before you start

Ensure you have access to the Microsoft Outlook desktop application, as Outlook on the web (Outlook.com) does not support extracting contact list members into individual files for a targeted CSV export.

Solution 1Recommended

Isolate and Export Contact List via Outlook Desktop

Since Outlook cannot export a distribution list directly, you must copy the group members into a temporary contact folder, export that folder to a CSV, and then apply a label in Gmail during import.

Outlook's export function only works on folders of individual contact records, not on distribution lists. To export a specific list, you must first break the list down into individual contacts within a separate folder.

Create a temporary contact folder

Open the Outlook desktop app, navigate to your Contacts view, right-click your main Contacts folder, and select 'New Folder'. Name this folder 'Temp Export Group' and ensure it is designated to contain Contact items.

Copy contact list members

Locate and open your target Contact List. Select all the members listed inside the group, and copy or drag them into the newly created 'Temp Export Group' folder to save them as standalone individual contacts.

Export the temporary folder to CSV

Click on 'File' > 'Open & Export' > 'Import/Export'. Select 'Export to a file', choose 'Comma Separated Values', and explicitly select your 'Temp Export Group' folder. Save the resulting CSV file to your desktop.

Import the CSV to Google Contacts

Open your web browser and navigate to Google Contacts (contacts.google.com). On the left-hand sidebar, click 'Import', click 'Select file', and upload the CSV file you just exported from Outlook.

Organize with Gmail Labels

Once imported, Google Contacts will group these users under a default label titled 'Imported on [Date]'. Hover over this label on the left sidebar, click the rename (pencil) icon, and change it to your original Outlook contact list name.

Isolate and Export Contact List via Outlook Desktop

Understanding Gmail Labels: Unlike Outlook, Gmail does not use 'Contact Lists' or separate folders. Instead, it uses 'Labels' to group contacts together for mass emailing. Applying a label to individual contacts replicates the function of an Outlook distribution group.

Free Microsoft Office alternative

Manage Your CSV Files and Documents with WPS Office

While migrating emails and contacts between Outlook and Gmail, you might need a reliable office suite to view, edit, or clean up your exported CSV files before importing them. WPS Office is a free, lightweight alternative to Microsoft Office that perfectly handles CSV, Excel, Word, and PowerPoint formats.

1. Download and Install: Download WPS Office for free from the official website and install it on your computer.
2. Open WPS Spreadsheet: Launch the application and select the Spreadsheet module to begin working with data.
3. Review Your CSV File: Drag and drop your exported Outlook CSV file into WPS Spreadsheet to easily review, edit, or clean up your contact details before uploading them to Gmail.

Fully compatible with Microsoft Office formats (including CSV, XLSX, and DOCX)Lightweight and fast performance on Windows, Mac, Linux, and mobileFamiliar, user-friendly tabbed interface for seamless document managementFree built-in PDF editing tools

microsoft office alternative - wps office

Frequently Asked Questions

Why does Outlook export all my contacts instead of just my contact list?

Outlook's native CSV export feature is programmed to export entire folders of individual contact records, not predefined distribution groups. To export a specific list, you must first extract the group members into their own separate folder and export that specific folder.

Can I export an Outlook contact list directly from Outlook.com?

No, Outlook on the web (Outlook.com) does not currently support exporting contact lists or distribution groups directly. You will need to use the Outlook Desktop application to separate the group members for a targeted export.

Does Gmail use folders for contacts like Outlook does?

No, Gmail uses a system called 'Labels' to organize contacts instead of traditional folders or distribution lists. When you import a CSV file into Google Contacts, you can assign a label to those contacts, which allows you to email them all at once just like an Outlook contact list.

Outlook & Email Problems