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!

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.













