Export Outlook Distribution List to Gmail


Milan Stanojevic
by Milan Stanojevic
Deputy Editor
Loading Comments
Affiliate Disclosure

export Outlook Distribution List to gmail

Looking for a way to export Outlook distribution list to Gmail? It’s time to discover how to do it, since copying and pasting the very same email addresses over and over until everyone gets your message is not productive.

Microsoft Outlook has the ability to create a contact group (formerly known as a Distribution List) from your Contacts list, and conveniently store that list in the Contacts folder. Then, you can use it to send the same email to multiple people – a project team, your coworkers, or simply a group of friends.

Gmail‘s contact manager cannot import distribution groups from Outlook contacts, but you can set up a different email distribution list that you use from any email client. This way, you make sure everyone stays in the communication loop.

Just remember that exporting your Outlook Distribution List to Gmail is a four-step process. Don’t hesitate to read all of the instructions thoroughly before applying these directions.

How can I export Outlook Distribution List to Gmail?

1. Save Outlook Distribution List as Text file

  1. Open Outlook.open Outlook Distribution List
  2. Browse to Contacts.
  3. Open the Distribution List to be moved to Gmail.
  4. Go to File > Save As.
  5. Save it as a .txt file. Choose an accessible location on your computer to temporarily save the file.

2. Open the Text file in Microsoft Excel

  1. Launch Microsoft Excel.launch Microsoft Excel
  2. Open the saved file.
  3. Now, make sure the Files of Type is set to All Files, or Text Files.
  4. Selecting the .txt file created before starts the Text Import Wizard.
  5. Here, accept all the default to complete the import process.
  6. Make sure the first column has last name, the next column has first name, and the third one has email address.
  7. Insert a row above data.
  8. There, insert these labels: last name, first name, email address.

3. Save the Excel file as CSV file

  1. Click on File > Save As.
  2. Make sure to save as type: CSV (comma delimited).save as CSV
  3. Name your file.
  4. If you get the prompt, click Yes to confirm that you wish to save the Excel file in .csv format and complete the exporting.

Also interested in exporting an Outlook email into an Excel spreadsheet? Check out this guide and learn how to do it.


4. Import CVS files into Gmail

  1. Open your Gmail account.
  2. Then, browse to Contacts page.
  3. Select import link from the left column in Contacts list.
  4. Select Choose File on the Import contacts popup box.Import contacts popup box
  5. Navigate to your .csv file and click Import.
  6. Once complete, a summary will display. Now, this group can be used just like any contact.

Some people want to be addressed personally and don’t fancy the idea of being lumped into a huge group. Don’t worry about that. A personalized email for an entire group solves the problem, so don’t give up on exporting your Outlook Distribution List to Gmail.

If you have any other suggestions or questions, don’t hesitate to leave them in the comments section below.

READ NEXT: