Skip to main content

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


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.

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!


ad batch save as 9.50

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!


Best Office Productivity Tools

Kutools for Outlook - Over 100 Powerful Features to Supercharge Your Outlook

🤖 AI Mail Assistant: Instant pro emails with AI magic--one-click to genius replies, perfect tone, multilingual mastery. Transform emailing effortlessly! ...

📧 Email Automation: Out of Office (Available for POP and IMAP)  /  Schedule Send Emails  /  Auto CC/BCC by Rules When Sending Email  /  Auto Forward (Advanced Rules)   /  Auto Add Greeting   /  Automatically Split Multi-Recipient Emails into Individual Messages ...

📨 Email Management: Easily Recall Emails  /  Block Scam Emails by Subjects and Others  /  Delete Duplicate Emails  /  Advanced Search  /  Consolidate Folders ...

📁 Attachments ProBatch Save  /  Batch Detach  /  Batch Compress  /  Auto Save   /  Auto Detach  /  Auto Compress ...

🌟 Interface Magic: 😊More Pretty and Cool Emojis   /  Boost Your Outlook Productivity with Tabbed Views  /  Minimize Outlook Instead of Closing ...

👍 One-click Wonders: Reply All with Incoming Attachments  /   Anti-Phishing Emails  /  🕘Show Sender's Time Zone ...

👩🏼‍🤝‍👩🏻 Contacts & Calendar: Batch Add Contacts From Selected Emails  /  Split a Contact Group to Individual Groups  /  Remove Birthday Reminders ...

Over 100 Features Await Your Exploration! Click Here to Discover More.

Read More       Free Download      Purchase
 

 

Comments (12)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
man.... I looked everywhere and this was it! One thing I will note, I had a group contact that couldn't be expanded. To do this, I expanded the list from my email, copied the recipients and then created a new contact group and pasted the names from my email in the members section at the bottom in the new group window. This populated the names and emails in two separate columns that allowed me to save into the text file and import into excel. Thanks again!
This comment was minimized by the moderator on the site
Thanks so much. Great instructions and it made it easy. Appreciate the help.
This comment was minimized by the moderator on the site
Awesome! The instructions on importing grouped contacts worked perfectly! Thank you!
This comment was minimized by the moderator on the site
Worked beautifully. Thanks a lot!
This comment was minimized by the moderator on the site
Worked perfectly. I have been wanting to do this and these instructions helped me each step of the way. Thanks again.
This comment was minimized by the moderator on the site
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?
This comment was minimized by the moderator on the site
Same here. I get the name of the group and the admins and notes, but NO contacts listed at all. It's highly frustrating.
This comment was minimized by the moderator on the site
Same thing happens to me. I get the contact group. but the contacts in the group are not displayed.
This comment was minimized by the moderator on the site
[quote]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?By Keara[/quote] That is exactly what happens when I follow these steps. I get the contact group name, but the members are not listed.
This comment was minimized by the moderator on the site
This is was so easy to follow and worked perfectly, thanks
This comment was minimized by the moderator on the site
Very Helpful indeed!
This comment was minimized by the moderator on the site
Thank you very helpful
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations