Extract Email Addresses from OLM File

Your old OLM file holds email addresses you need, and you cannot open it. Outlook for Mac only exports OLM archives, and Excel cannot open them. A user on Microsoft Q&A hit that wall when asking for a CSV of contacts. Below are three ways to extract email addresses from OLM file data, from free steps to a batch tool that can extract email addresses from OLM file archives in one run.

What is inside an OLM file when you extract email addresses?

Before you extract email addresses from OLM file data, know what it holds. An OLM file is an Outlook for Mac archive. It stores emails, contacts, calendars, tasks and notes. Addresses sit in three places: contact cards, sender and recipient fields, and message bodies.

Microsoft describes OLM as export of items to an archive file in legacy Outlook for Mac, and it says support for that version ends in October 2026. Format is a zip archive. FileExt notes that most OLM files use zip, and renaming its extension to .zip shows Accounts and Local folders plus a Categories.xml file. Every way below reads those parts differently, so match method to need: contacts, or every address.

How to extract email addresses from OLM file contacts in Outlook for Mac?

Import your OLM file into legacy Outlook for Mac, then export Contacts as tab-delimited text and open it in Excel. It gets contact cards only, not addresses from message headers or bodies.

1. Open legacy Outlook for Mac. Go to Tools tab and select Import.
2. Choose Outlook for Mac archive file (.olm) and select Continue.
3. Locate your OLM file and select Import. Imported items appear under On My Computer.
4. Open Contacts, then choose File and Export.
5. Select Contacts to a list (tab-delimited text), name your file with a .txt extension and save it to Desktop.
6. In Excel, open that text file, choose Delimited in Text Import Wizard and save as Excel Workbook or CSV.

Microsoft documents how to import an OLM file into Outlook for Mac in legacy steps. A volunteer moderator on Microsoft Q&A told one user that OLM is only export option, and another moderator posted tab-delimited route above. That asker reported their OLM file greyed out in Excel and no accepted answer is marked, so treat these steps as a workaround that depends on your version.

Catch: to extract email addresses from OLM file contacts in that way, you need a Mac with Outlook, new Outlook for Mac may differ because Microsoft documents legacy steps only, and you get contact cards, not senders from your mail.

How to extract email addresses from OLM file with Terminal?

Unzip your OLM file and run grep over extracted files to extract email addresses from OLM file contents. It is free and covers headers and bodies, but it also pulls noise.

1. Copy your OLM file to Desktop and rename archive.olm to match your file name in commands below.
2. Open Terminal and unzip: unzip -q ~/Desktop/archive.olm -d ~/Desktop/olm_out.
3. Run grep command below. It writes unique lowercase addresses to emails.txt.
4. Open emails.txt in TextEdit and delete addresses you do not want from your OLM email addresses list.

grep -rhoE "[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,}" ~/Desktop/olm_out | tr 'A-Z' 'a-z' | grep -vE "\.(png|jpe?g|gif|svg)$" | sort -u > ~/Desktop/emails.txt

Our team ran that pipeline on a small test archive built to mimic OLM layout, and it returned sender, recipient and body addresses one time. It is not tested on a real Outlook export, so try it on a copy first. Output may include system addresses, image names such as logo@2x.png (command removes common ones) and addresses from newsletters.

Catch: that way to extract email addresses from OLM file data needs Terminal comfort, it does not read addresses inside PDF or Word attachments and it returns no sender or date, only addresses.

Steps to extract email addresses from OLM file with software

1. Copy your OLM file to a Windows PC. Install Corbett Email Address Extractor and open it.
2. Add your OLM file as source. Tool lists your OLM folders. Folders load on left, messages on right.
3. Preview items, then tick search fields: From, To, Cc, Subject, Message Body or Message Header.
4. Untick folders you do not need, such as Junk. Add filters if you want fewer addresses.
5. Select Extract and review addresses and total count in results pane.
6. Save TXT list to a folder, then open it in Notepad.

Software helps you extract email addresses from OLM file data on your PC, and Corbett never sees mail data. Your OLM file is read, not changed. Clean your list next with Corbett Email Address Validator. Need files, not addresses? See how to extract attachments from OLM file.

Which way to extract email addresses from OLM file is best?

To extract email addresses from OLM file contacts only, use Outlook for Mac. For free full search on a Mac, use Terminal. For attachments, filters and Windows, use software.

Other sources work in same way. See how to extract email addresses from OST file or extract email addresses from MBOX file.

Why does OLM email address extraction fail?

Excel cannot open your OLM file when you extract email addresses

OLM is an archive, not a spreadsheet, so you cannot extract email addresses from OLM file data inside Excel. Export contacts as tab-delimited text from Outlook for Mac, or extract addresses with Terminal or software.

On My Computer folder is missing after import

In legacy Outlook for Mac, open Outlook, then Settings, select General and clear Hide On My Computer folders.

Terminal returns zero addresses when you extract email addresses from OLM file data

Check that unzip finished and that your OLM file really is a zip archive. A small share of OLM files use another structure, per FileExt, so try software on those.

Email addresses from OLM file output hold duplicates or junk

Terminal command removes exact duplicates, not newsletters or system mail. Software lets you skip folders and filter by sender before you extract email addresses from OLM file data.

Software does not load your OLM file

Copy file to a local Windows drive, check that it is not corrupt and run tool as administrator. Try free demo on one folder first.

What to do after you extract email addresses from OLM file data?

After you extract email addresses from OLM file archives, remove duplicates and test addresses before any mailing. Keep a copy of your OLM file until you check your list. Need mail on Windows after you extract email addresses from OLM file archives? See how to import OLM file to Outlook.

Questions about extract email addresses from OLM file