Extract Email Addresses from OLM File

Your old OLM file contain 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 pull OLM addresses, from free steps to a batch tool that can extract addresses from OLM archives in one batch.

What is inside an OLM file?

Before you extract email addresses from OLM file data, know what it contain. 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 pull addresses from an 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 pull addresses from an OLM file with Terminal?

Unzip your OLM file and use grep on extracted files to pull addresses from an OLM file contents. It is free and includes 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. Enter the grep command below. It saves 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 like logo@2x.png (command removes common ones) and addresses from newsletters.

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

Steps to pull addresses from an 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 open on left and 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, like 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 assists you pull addresses from an OLM file data on your PC and Corbett never sees mail data. Your OLM file is opened and left unchanged. Clean your list next with Corbett Email Address Validator. Need files, not addresses? See how to Extract attachments from OLM file.

Which way to pull OLM addresses suits you?

To pull addresses from an 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 address extraction fail?

Excel cannot open your OLM filesses

OLM is an archive, not a spreadsheet so you cannot pull addresses from an 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 addressessses 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.

The output has duplicates or junk

Terminal command removes exact duplicates, not newsletters or system mail. Software can exclude folders and filter by sender before you pull addresses from an OLM file data.

Software does not open your OLM file

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

What to do after the extraction?

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

Questions About OLM Email Addresses