Outlook contacts to Excel — a .pst address book as a sheet
Open an Outlook .pst or .ost file and save its contacts as an Excel workbook, one person per row.
About this conversion
The address book is often the part of an old mailbox that matters most — clients, suppliers, the plumber — and the part that is hardest to get at without Outlook. Here it opens from the .pst itself and becomes an Excel sheet: a row per person, phones by type, company and job title, business address split into its parts. Distribution lists are listed by name and marked as such.
Just want to look inside it?
The same tool without converting anything: open the file and read it.
The same contacts, any way out
The file is read once and stays open, so the format is picked at the end: the same list
can leave here as CSV, CSV for Google Contacts, CSV for Outlook, VCF or PDF. Before that you can search it, see which people are saved
twice — the same number written as (555) 201-4477 in one file and
+15552014477 in another counts as one — and fold the duplicates into a single
card without losing any phone, address or note.
Questions
- The file is several gigabytes.
- That is fine. A .pst is read in pieces straight from the disk, so its size is not limited by the memory of the tab.
- Some rows are just an email address.
- Those are addresses Outlook collected from your correspondence, labelled “Suggested by Outlook”. Search for that label to see or drop them.