RECIPIENT CLEANER · PRACTICAL GUIDE

Copy Outlook recipients to Excel: names and email addresses in separate columns

Recipient Cleaner is a free browser tool that converts copied Outlook recipient fields into a name-and-email table, a plain email list, or a semicolon-separated Outlook list. Paste the recipients, review the parsed rows, and copy the table or download a CSV.

Open Recipient Cleaner →

Why recipient lists become a jumble

An Outlook recipient often contains a display name and an email address, such as “Doe, Jane” <jane@example.com>. Lists can include semicolons, commas inside names, line breaks, and company notes. Splitting everything at every comma can break a single person into multiple rows. Recipient Cleaner reads the structure, separates the address, normalizes name order, and shows uncertain entries for review.

How to copy recipients into an Excel table

  1. Copy a recipient field. In Outlook, use the To, Cc, or Bcc recipient field when it is selectable. If the message view only shows names or hides recipients, an editable compose or reply draft may expose more detail. Copy what you need without sending the draft. The exact steps vary by client; check that addresses were actually copied.
  2. Paste and convert. Open Recipient Cleaner, paste the list, and select Clean recipients. Check the usable-recipient and review counts.
  3. Choose your settings. Flag, remove, or leave duplicates. Keep parenthetical notes in names, move them to a separate column, or omit them. Correct any ambiguous rows using Edit.
  4. Copy or download. Choose Table and Copy table, then paste into Excel or Google Sheets. Download CSV provides a file with the same table columns. Copy for Word supplies a rich table where browser support permits.

Before and after: recipient text becomes rows

"Doe, Jane (Acme)" <jane@example.com>; Alex Smith <alex@example.org>

With Separate column selected, the result is:

Full nameEmailParenthetical text
Jane Doejane@example.comAcme
Alex Smithalex@example.org

Choose the output that fits your task

Common questions about Outlook recipient cleanup

Can I copy just the email addresses from Outlook?

If the copied recipients include addresses, choose Email list for one address per line or Outlook list for a semicolon-separated list. Names are excluded from those two outputs. If Outlook copied only names, this website cannot recover the missing addresses.

How do I separate names and email addresses into columns?

Paste your recipient list, convert it, then choose Table. Copy table produces tab-separated columns for Excel or Google Sheets. Download CSV creates a UTF-8 file with the current table columns. Check the preview before using the results.

Can I turn Last, First into First Last?

Yes. “Doe, Jane” becomes “Jane Doe”. Names without commas keep their order. Common suffixes are handled conservatively. Multiple unexplained commas are flagged for review; you can edit the normalized name.

What happens to company names in parentheses?

Choose Keep in name, Separate column, or Omit. The separate column is labeled Parenthetical text because annotations may also contain departments, pronouns, locations, or notes. Changing settings preserves your source.

How are duplicate recipients removed?

Choose Remove to keep the first occurrence of each matching address. Matching ignores surrounding whitespace and letter case, but preserves plus tags and distinct addresses. A summary lists removed entries and warns about conflicting names or notes. Flag highlights duplicates without removing them; Leave keeps them without highlighting.

Does this work with classic, new, web, and Mac Outlook?

The parser supports common recipient text formats rather than a single client version. The automated tests cover format fixtures, not verified clipboard captures from every Outlook client. Actual compatibility depends on what your client copies. Names without addresses, internal Exchange identifiers, and unexpanded groups need review.

Are my contacts uploaded or checked by AI?

No. This converter’s code processes recipient content in your browser tab, without an AI API, mailbox connection, or saved contact database. Clipboard and downloads act only when requested. Hosting can still receive ordinary page requests; see Privacy for details.

Does an accepted address mean the mailbox exists?

No. The tool checks common address formatting, not mailbox existence, ownership, consent, or deliverability. Review the output before sending messages or importing a list.

What this tool does not do

This is a pasted-recipient formatter. It does not export an entire mailbox, expand distribution groups, recover hidden addresses, resolve company directories, or send email. Paste recipient fields rather than full message bodies. Use only information you are authorized to process and review the results before sharing or importing them.

Privacy, ownership, and corrections

Recipient Cleaner is operated by Marctil Enterprises in Illinois, United States. It is independent of Microsoft. Read Privacy, Terms of use, and About & contact for processing details, usage terms, and project limitations. Contact hello@recipientcleaner.com for questions or corrections.

References and further reading

Microsoft’s instructions for creating an Outlook message describe recipient fields and semicolon separation in classic Outlook. Users also describe the copy-and-paste problem in this Outlook community discussion. Client-specific behavior can change.

Clean a recipient list →