Written by Jennifer Walsh. Reviewed for technical accuracy by Shubham Dixit, Independent Expert in Email Forensics and Data File Conversion.
Shubham is an independent external reviewer and not an employee of PCDOTS.
Quick answer. Phone numbers sit in two places in Outlook. In your contacts they are tidy labelled fields, and a free CSV export gets them in a minute. In your mail they are loose text inside signatures, which needs a pattern match, so expect to review the results before you trust them.
On this page
Two places numbers hide
Before you pick a method, notice that a phone number can be sitting in one of two quite different places in Outlook, and they call for completely different approaches.
The first is your contacts. Every contact card has labelled fields for business phone, mobile, home and fax, so the numbers there are already structured and tagged. Getting them out is a tidy, reliable export. The second is your mail, where numbers appear inside email signatures and message bodies as ordinary text, sitting in a sentence like anything else. Nothing marks them as phone numbers, so pulling those out means recognising them by their shape, which is a looser and messier job.
Most people asking this question actually want the first one, their own address book, often after losing a phone. If that is you, the next section is a one minute fix and you can stop there.
Export your contacts to CSV, free
Outlook exports your contacts to a spreadsheet for free, and every phone field comes with them.
Step 1. In Outlook, go to File, then Open and Export, then Import/Export.
Step 2. Choose Export to a file, then Comma Separated Values.
Step 3. Select the Contacts folder and pick where to save it.
Step 4. Open the CSV in Excel. Each contact is a row, with separate columns for business phone, mobile, home and the rest.
You get the whole contact record rather than only the numbers, which is fine. Delete the columns you do not want, or copy the phone columns into a new sheet, and you have a clean list in another minute. The honest limit is that this covers people you saved as contacts, and nobody else.
Why numbers in mail are harder
Numbers written inside emails are a different proposition, and it is worth understanding why before you judge any tool that does it.
An email address is easy to spot automatically because it always contains an at sign, so a machine can find one with near perfect accuracy. A phone number has no such marker. It is just digits, and there is no single agreed way to write them. The same office number can appear with a country code or without, with spaces, dashes or brackets, with a leading zero or a double zero, and with an extension tacked on the end. All of those are the same number, and a tool has to recognise every variation as such.
An email address has an at sign to spot. A phone number has no such marker.
What a pattern match actually catches
“Pulling phone numbers out of message text is inference, not extraction, and that is the part to be clear eyed about. Anything with the right run of digits will be offered up, so invoice references, order numbers and tracking codes come along with the real ones, and a number written unusually can be missed entirely. I treat the output as a shortlist rather than an answer, because a list of numbers looks authoritative whether or not it is correct. A quick review pass is what turns it into something you can rely on.” Shubham Dixit, Email Forensics reviewer (draft, pending approval)
Because the match works on shape rather than meaning, two things happen. Some real numbers slip through, usually the ones written in an unusual way. And plenty of things that are not phone numbers get picked up, because they happen to look like one. Invoice numbers, purchase order references, parcel tracking codes, long reference strings, even dates and postcodes can all be the right length and pattern.
That is not a fault in any particular tool, it is what the job is. So plan for a review pass. Sort the results, glance down the column, and delete the obvious strays before you use the list for anything. It usually takes a couple of minutes and it is the difference between a rough dump and something dependable.
Treat the output as a shortlist, then spend two minutes cleaning it.
The macro route for message bodies
If the numbers you want are in your mail rather than your contacts, and you are comfortable with a little code, a VBA macro inside Outlook can walk a folder, run a pattern over each message body, collect anything shaped like a phone number and write the results to a file. It is free, it runs on your own machine, and you can widen or tighten the pattern as you go.
Write the pattern to allow for the variations above, spaces, dashes, brackets, a leading plus or a double zero, and an optional extension. Then apply the review pass. Expect to run it, look at the output, adjust the pattern once or twice, and run it again. That loop is normal for this kind of job.
Extract numbers in bulk with a tool
When you would rather not write a pattern yourself, when the mailbox is large, or when Outlook will not open because the profile is damaged, a dedicated tool does the same work through an interface. The PCDOTS PST Converter loads a live Outlook account or a PST file directly, lets you pick the folders you care about, and pulls the phone numbers out of the mail in one run, saving them to a file. Because it reads the PST itself, it also works when the profile is broken and the data file is all you have. The same review advice applies to its output as to any other method, so give the list a glance before you use it. There is a free demo version to try on your own data first.
The bulk route, then the same quick review of the results.
Here are the steps with the screens.
Step 1. Run the tool on Windows, open the menu, and load your Outlook account or PST file.
Step 2. Preview the mail and select the folders you want to search.
Step 3. Go to the Extract menu and choose phone numbers.
Step 4. Pick a destination and click Save, then open the file and review the list.
If it is addresses rather than numbers you are after, there is a companion guide to extract email addresses from Outlook, and another on extracting metadata from Outlook. To browse a mailbox without converting anything, a free PST file viewer opens it on its own.
The methods compared
Match the route to where your numbers actually are.
| Method | Best for | Good to know |
|---|---|---|
| Contacts to CSV | Your address book, free | Tidy fields, saved contacts only |
| VBA macro | Numbers inside mail, free | Tune the pattern, review results |
| PST extractor | A big mailbox or broken profile | Reads the file, still review |
Frequently asked questions
How do I extract phone numbers from Outlook?
For your contacts, use File then Open and Export then Import/Export and save the Contacts folder as CSV, which includes every phone field. For numbers written inside emails, use a VBA macro or a tool that scans the mail and collects them.
Can I extract phone numbers from Outlook for free?
Yes. The contacts export is built in and costs nothing, and a free VBA macro can scan message bodies for numbers. A tool is for large mailboxes, or when Outlook will not open.
Can I get only the phone numbers and not the whole contact?
The export gives you every contact field, so open the CSV in Excel and keep just the phone columns. That takes a minute and leaves you with a clean list.
Why does my extracted list contain things that are not phone numbers?
Because numbers in text are found by their shape, so invoice numbers, order references and tracking codes with a similar run of digits get picked up too. Sort the list and delete the strays before using it.
Why were some phone numbers missed?
Usually because they were written in an unusual format, with an unexpected country code, spacing or extension. Widening the pattern catches more, at the cost of a few more false matches to clear out.
Can I extract numbers if Outlook will not open?
Yes, if you still have the PST file. A tool that reads the file directly can scan it without a working Outlook profile, which is the usual answer after a crash.
Numbers you can actually call
Start by asking where the numbers are, because that single question decides how easy this is. If they are in your contacts, the free CSV export is a one minute job and the result is clean, which covers most people who came here after losing a phone. If they are scattered through years of email signatures, accept that you are asking a machine to recognise numbers by their shape, so give the output a quick sort and tidy before you rely on it. Do that and you end up with a list worth keeping, rather than a column of digits you are not sure about.
