Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to export Outlook contact groups to Excel?

It may be quite easy to export a whole contact folder from Microsoft Outlook as .csv file or Excel workbook. However, some users may only want to export a certain contact group from Outlook, how to get it done? In this article, I will show you the steps about exporting Outlook contact groups into Excel.

Export Outlook contact groups to Excel

One click to save/export multiple emails to text/PDF/HTML/CSV files in bulk in Outlook

Normally we can export/save an email message as a text file with the Save As feature in Outlook. But, for batch saving/exporting multiple emails to individual text files, you have to manually handle each message one by one. Time-consuming! Tedious! Now, Kutools for Outlook's Batch Save feature can help you quickly save multiple email messages to individual text files, PDF files, HTML files, etc. with only one click! Click for 60-day free trial without limitation!
ad batch save as 9.50

Office Tab - Enable Tabbed Editing and Browsing in Office, and Make Work Much Easier...
Kutools for Outlook - Brings 100 Powerful Advanced Features to Microsoft Outlook
  • Auto CC/BCC by rules when sending email; Auto Forward Multiple Emails by rules; Auto Reply without exchange server, and more automatic features...
  • BCC Warning - show message when you try to reply all if your mail address is in the BCC list; Remind When Missing Attachments, and more remind features...
  • Reply (All) With All Attachments in the mail conversation; Reply Many Emails at once; Auto Add Greeting when reply; Auto Add Date&Time into subject...
  • Attachment Tools: Auto Detach, Compress All, Rename All, Auto Save All... Quick Report, Count Selected Mails, Remove Duplicate Mails and Contacts...
  • More than 100 advanced features will solve most of your problems in Outlook 2010-2019 and 365. Full features 60-day free trial.

Export Outlook contact groups to Excel

To export a certain contact group from Outlook to Excel, you can do as following:

1. Shift to the Contact view, select the contact group you will export, and then click the File > Save As.

2. In the Save As dialog box,
(1) Select the folder that you will save this contact group into;
(2) Enter a name for the exported contact group into the File name box;
(3) Click the Save as type box, and select the Text Only from the drop down list;
(4) Click the Save button.

3. Create a blank workbook, and then click the File (or Office button)> Open or File > Open > Computer > Browse.
 

4. In the popping up Open dialog box,
(1) Open the folder that you saved the exported contact group in just now;
(2) Click the second box behind the File name, and then select All Files (or Text Files) from the drop down list;
(3) Click to select the text file of exported contact group, and then click the Open button.

5. In the popping up Text Import Wizard dialog box, make sure the Delimited option is checked, and then click the Finish button.

Then contact group is successfully exported to the Worksheet with the information of group name and members.

6. Save and close the workbook.


Demo: Export Outlook contact groups to Excel

Tip: In this Video, Kutools tab is added by Kutools for Outlook. If you need it, please click here to have a 60-day free trial without limitation!


Kutools for Outlook - Brings 100 Advanced Features to Outlook, and Make Work Much Easier!

  • Auto CC/BCC by rules when sending email; Auto Forward Multiple Emails by custom; Auto Reply without exchange server, and more automatic features...
  • BCC Warning - show message when you try to reply all if your mail address is in the BCC list; Remind When Missing Attachments, and more remind features...
  • Reply (All) With All Attachments in the mail conversation; Reply Many Emails in seconds; Auto Add Greeting when reply; Add Date into subject...
  • Attachment Tools: Manage All Attachments in All Mails, Auto Detach, Compress All, Rename All, Save All... Quick Report, Count Selected Mails...
  • Powerful Junk Emails by custom; Remove Duplicate Mails and Contacts... Enable you to do smarter, faster and better in Outlook.
shot kutools outlook kutools tab 1180x121
shot kutools outlook kutools plus tab 1180x121
 
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Misha · 2 years ago
    Thanks so much. Great instructions and it made it easy. Appreciate the help.
  • To post as a guest, your comment is unpublished.
    Susan · 2 years ago
    Awesome! The instructions on importing grouped contacts worked perfectly! Thank you!
  • To post as a guest, your comment is unpublished.
    Uma · 2 years ago
    Worked beautifully. Thanks a lot!
  • To post as a guest, your comment is unpublished.
    Uma · 2 years ago
    Worked perfectly. I have been wanting to do this and these instructions helped me each step of the way.

    Thanks again.
  • To post as a guest, your comment is unpublished.
    Keara · 2 years ago
    Thank you for these instructions. They were very helpful, but when I follow these steps I can get it to work, but the actual group member names are not listed. Only the Contact Group Name: and then under Members: it repeats the Contact Group name (and does not list the members. Any idea what I'm doing wrong and how to fix the problem?
    • To post as a guest, your comment is unpublished.
      Christy Nicholas · 2 years ago
      Same here. I get the name of the group and the admins and notes, but NO contacts listed at all. It's highly frustrating.
    • To post as a guest, your comment is unpublished.
      Bernard · 2 years ago
      Same thing happens to me. I get the contact group. but the contacts in the group are not displayed.
    • To post as a guest, your comment is unpublished.
      Bernard · 2 years ago
      [quote name="Keara"]Thank you for these instructions. They were very helpful, but when I follow these steps I can get it to work, but the actual group member names are not listed. Only the Contact Group Name: and then under Members: it repeats the Contact Group name (and does not list the members. Any idea what I'm doing wrong and how to fix the problem?[/quote]
      That is exactly what happens when I follow these steps. I get the contact group name, but the members are not listed.
  • To post as a guest, your comment is unpublished.
    Emma · 3 years ago
    This is was so easy to follow and worked perfectly, thanks
  • To post as a guest, your comment is unpublished.
    Joyce · 3 years ago
    Very Helpful indeed!
  • To post as a guest, your comment is unpublished.
    Margaret Murray · 3 years ago
    Thank you very helpful