How to Export Group Contacts in Outlook as a CSV

To export Outlook group contacts, first identify whether you have a classic Outlook Contact Group or a Microsoft 365 group. Classic Outlook does not reliably export a Contact Group as a CSV of individual members, so expand the group in a new message, copy the recipients, and save the cleaned list from Excel as a CSV. If you only need your saved contacts, Outlook can export the Contacts folder directly.

What You’ll Need

Classic Outlook for Windows is the most practical option for expanding a traditional Outlook Contact Group. The New Outlook and Outlook on the web have different contact features and may not provide the same group-editing options.
Excel or another spreadsheet app if you want a tidy CSV file. You can use a plain-text editor to keep a temporary copy of the expanded recipients.
Permission to view the group members. For a work or school Microsoft 365 group, you may need an owner or administrator to provide a complete membership list.
A safe place to store the exported addresses. A CSV is plain text and can be opened by other people, so treat it as sensitive if the addresses are private.

Step-by-Step

Check what kind of group you have. A Contact Group, sometimes called a distribution list, is a personal Outlook item made up of email recipients. It is normally stored in your Contacts folder. A Microsoft 365 group is a work or school collaboration group with shared resources such as a mailbox, calendar, or files. It is managed differently and may include members who are not saved as your personal contacts. If you are unsure, look in People or Contacts for a group you created; if you open the group from a work or school Groups list, it is likely a Microsoft 365 group.
Decide whether you need the group members or your whole Contacts folder. If your goal is a CSV of every saved contact, skip to step 7 and export the Contacts folder. That export does not necessarily turn a Contact Group into a row for every member. If you need only the people inside one group, continue with the recipient-expansion method. This distinction prevents a common surprise: a CSV may contain your individual contacts but not a usable membership list for the group itself.
Open a new message without sending it. In classic Outlook for Windows, choose Home > New Email. Enter the Contact Group’s name in the To field and select the matching suggestion. Do not put the group into the Cc or Bcc field unless you specifically intend to use that field; the goal here is only to make Outlook resolve the group.
Expand the Contact Group into individual recipients. In the To field, use the plus sign or expansion control beside the group name. Outlook may show a confirmation that the group will be expanded; confirm it. The single group entry should change into individual recipient entries. If you do not see an expansion control, check that Outlook resolved the group from your Contacts rather than leaving the name as unrecognized text. Do not send the message.
Copy the expanded recipient list. Click in the To field, select the recipient entries, and copy them with Ctrl+C on Windows. Paste them into a temporary text document or a blank Excel worksheet. The result can vary by Outlook build: it may include display names and email addresses, or it may paste as a string of recipient tokens. Review what was pasted before relying on it as a complete address list. If the list is large, copy in smaller batches so it is easier to check for missing entries.
Clean and verify the list. In Excel, place one recipient per row if possible, with separate columns for name and email address. Remove headings, punctuation, or other text that is not part of a name or address. Check the beginning and end of the list against the group window, and look for duplicates. If a pasted entry shows only a person’s display name, open that recipient’s contact card or check the original group entry to confirm the actual email address. Do not assume a display name is an address that can be imported elsewhere.
Save the cleaned member list as a CSV. In Excel for Microsoft 365 on Windows, choose File > Save As, select a folder, and choose CSV UTF-8 (Comma delimited) (*.csv) in the file type list if it is available. Give the file a clear name, such as outlook-group-members.csv, and select Save. Excel may warn that CSV keeps only the active worksheet and removes some formatting or features; confirm if the simple list is all you need. Reopen the saved file in a text editor or spreadsheet to check that the rows and characters look right. On Mac, use File > Save As and choose a CSV format in the file format menu; wording can differ by Excel version.
Use Outlook’s built-in export when you need all saved contacts. In classic Outlook for Windows, select File > Open & Export > Import/Export. Choose Export to a file, select Next, choose Comma Separated Values, and select Next. Select the Contacts folder for the account you want, choose Next, browse to a destination and enter a filename, then select Finish. If prompted about date ranges, the setting is generally not relevant to contacts. The resulting file is a contact-folder export, not a guaranteed expansion of each Contact Group into separate member rows.
Handle a Microsoft 365 group separately. Do not use the personal Contact Group method as if it were a complete export of a Microsoft 365 group’s membership. Open the group in Outlook and review its member list; available controls depend on your Outlook version and your role. For a small list, you may be able to copy the displayed names and verify each address. For a complete or repeatable export, ask the group owner or Microsoft 365 administrator for a membership export. If you only need an address list for a message, use the group’s mail address rather than exporting every member.

Common Mistakes

Exporting Contacts and expecting a group-members CSV. The built-in Contacts export is useful for saved individual contacts, but it may not give you one spreadsheet row per member of a Contact Group. Use the expanded recipient list when the membership itself is what you need.
Confusing a Contact Group with a Microsoft 365 group. The names sound similar, but the objects and permissions are different. A work or school group’s membership may be managed centrally and may not appear in your personal Contacts.
Sending the draft accidentally. The message is only a way to make Outlook resolve and expand the list. Leave it unsent, and close it without saving or discard it when finished.
Keeping only display names. Names such as Alex Smith are not enough to import or contact someone reliably. Confirm the email address for entries where copying did not include it.
Saving in the wrong format. An .xlsx workbook is not a CSV, and renaming the extension does not convert it. Use Save As and select a CSV file type.
Overlooking data privacy. A CSV exposes addresses in readable form. Store it in an approved location, share it only with people who need it, and delete temporary copies when they are no longer needed.

Tips

Keep a separate untouched copy of the group or original contact list before making edits. That makes it easier to compare the export and recover from accidental changes.
Use clear column headings such as Name and Email. A simple, consistent layout is easier to import into another mailing tool than a single column of mixed recipient text.
For a long list, check the number of entries before and after copying. Outlook may wrap recipients across lines, so count rows or verify a few names at the top, middle, and bottom rather than relying on how wide the To field looks.
Keep the original file in an Excel workbook if you may need formatting or additional columns later. CSV is best treated as a final, plain-data copy; it does not preserve multiple sheets, formulas, or formatting.
If you plan to import the CSV into another service, check that service’s required column names and encoding first. CSV files can use different separators in some regional settings, and the receiving app may expect a specific layout.
When exporting contacts from more than one Outlook account, select the correct Contacts folder each time and name the files clearly. Outlook can show several accounts or folders with similar names.

Troubleshooting

The group name does not appear in the To field. Check spelling and make sure you are using the account that owns or can access the group. In classic Outlook, open People or Contacts and confirm the group is still present. For an organization-managed group, ask its owner whether you have access and whether the group is still active.
There is no plus sign or expansion option. You may be using New Outlook, Outlook on the web, or a Microsoft 365 group rather than a classic Contact Group. Try classic Outlook for Windows if available and confirm that the list is a personal Contact Group. If it is a Microsoft 365 group, request a membership export from an owner or administrator instead.
The copied text has names but no email addresses. Outlook can paste recipient display names without exposing the full address in the text. Check the group editor or open each relevant contact card to verify addresses. If the group is large, ask its owner or administrator for a proper member export rather than manually guessing from names.
Some members seem to be missing. Reopen the original group and compare its member count with the copied list. Nested groups, unresolved addresses, and members hidden from your account can complicate a manual copy. Expand nested groups separately if Outlook offers that option, and request an authoritative list when completeness matters.
The CSV opens with garbled characters or all the data in one column. Re-save as CSV UTF-8 if available. When importing, use Excel’s Data > From Text/CSV option and check the preview for the correct delimiter and encoding. Do not overwrite the source until the preview looks correct.
The Export option is missing or disabled. You may be using New Outlook or Outlook on the web, where menus differ from classic Outlook, or your organization may restrict export. Use classic Outlook if your account supports it, export from the contact provider that owns the data, or ask your Microsoft 365 administrator about the approved method.

Frequently Asked Questions

Can Outlook export a Contact Group directly to CSV?
Do not assume so. The standard Contacts-folder export is not a dependable way to create one CSV row per group member. Expand the Contact Group into individual recipients, copy and verify the list, then save that list as CSV.

Does exporting Outlook contacts include group members?
It exports contact data from the folder you select, but the Contact Group itself may not become a complete set of member rows. Export the group membership separately if that is what you need.

Can I do this in New Outlook or Outlook on the web?
Some contact export and group controls differ by version, and the classic expansion workflow may not be available. For a personal Contact Group, use classic Outlook for Windows when possible. For a Microsoft 365 group, ask an owner or administrator for a full membership list.

Can I export a Microsoft 365 group’s members from Outlook?
Outlook may let you view a group’s members, but a complete CSV export is not available in every version or for every user role. Ask the group owner or your Microsoft 365 administrator for an authoritative export if you need every member and address.

Will the CSV include names and email addresses?
It depends on how the recipients paste from Outlook. Check the result before sharing or importing it. Keep separate Name and Email columns where possible, and verify any entries that contain only display names.

Can I import the CSV back into Outlook?
Often, yes, but the import steps and required columns depend on the Outlook version and whether the file represents individual contacts or group membership. A CSV of recipients does not automatically recreate a Contact Group; you may need to create a new group and add the imported contacts.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.