Blog

How to Export Contacts from Outlook to Excel Mac?

Eva Mendis | Last Modified: November 20th, 2020 | Conversion, Outlook

Are you Outlook user and want to export contacts from Outlook to Excel Mac? If yes, then you will get the right answer of your request. In this blog, we will explain the effective solution to export Outlook contacts to Excel on Mac machine. So let’s start.

Exporting Outlook contacts to a spreadsheet can be used to move data from Outlook to another email client or as a contact backup. Contacts are always important as it stores information like name, mobile number, etc. And Excel is a good platform to save large number of contacts without any size limit.

There are two methods of exporting Outlook contacts as an Excel spreadsheet: manual and automated. The following section explains the two methods so that you can easily choose one of the method that best suits your needs.

Manually Export Contacts from Outlook to Excel

Follow the below steps to export Outlook contacts to Excel CSV file:

Step 1. Open Outlook application and go to the File tab.

Step 2. Click on Open & Export >> and select Import/Export.

Step 3. The Import and Export Wizard will open, select “Export to a file” and click Next.

Step 4. Select “Comma Separated Values” and then click Next button.

Step 5. Select “Contacts Folder to export from” and hit Next.

Step 6. Click Browse and choose location for the exported file and click Next.

Step 7. Hit on the Finish button.

Your export creates a text file with the extension “CSV”. The export file can be opened in Excel by double-clicking it.

If you find this method to be very tedious and you are looking for a quick fix, you can take the help of an automated solution.

Automated Solution to Export Outlook Contacts to Excel CSV on Mac

Use SysTools PST Conversion Tool for Mac that enables you to export contacts from Outlook to Excel CSV file. This software supports to transfer contacts from corrupted PST file. It has Advance Scan option that will fix the corruption issues of Outlook PST. The tool exports all contacts information in CSV file like first name, last name, mobile number, email address, etc. It is capable enough to export large sized PST contacts file without any limitations.

Using this tool, it is possible to export contacts from password-protected PST file without any complications. The software comes with simple and friendly interface that any beginner can easily to perform this task.

Steps to Export contacts from Outlook to Excel on Mac are as follows;

Step 1. Download and Install PST Converter in your system.

free download

Step 2. Click on Add Files or Folder to load PST contacts file.

add file

Step 3. Select CSV file format from the “Export Type” section.

export contacts from outlook to excel csv

Step 4. Click on “Change” and select the location to save CSV file.

choose location

Step 5. Click on the “Export” button to export contacts.

export outlook contacts to excel csv

Done! This is the best way you can quickly export Outlook contacts to Excel CSV file on Mac machine.

Additional Features of PST Converter Tool

  • The software is easy to use that allows any technical and non-technical user to easily access this utility to perform this task.
  • It supports all types of PST files. You can easily export contacts from ANSI, UNICODE and Password-protected PST file.
  • The tool provides preview of all contacts stored in the PST file with all details.
  • It is capable enough to export contacts from Outlook to Excel CSV file without losing a single data.
  • The tool gives freedom to export unlimited PST file to Excel with no size limitations.

Final Words

The import and export function in Outlook helps to export Outlook contacts to CSV file that easily open in Excel. Moving a large number of contacts with details from Outlook to Excel is not easy with this feature. Therefore, we suggested the professional tool that enables you to export contacts from Outlook to Excel CSV file.