Outlook: Exporting contacts as an Excel table

If you want to transfer your Outlook contacts to another computer or back them up, you can save the contacts in an Excel table. We will show you the individual steps.

Outlook: Export contacts as an Excel table

Depending on the Outlook version, the process may differ slightly in some steps.

• Click the “File” button at the top left of Outlook and select the “Options” at the bottom.

• Switch to the “Advanced” category on the left and look for the “Export” button. A small window will then open.

• Select the option “Export to file” as well as “Separated values”. Under older Office versions, a direct export function for Excel is available here.

• Now click on the “Contacts” in the list and confirm the selection with “Next”.

• Optionally select a desired storage location and name and click on “Next” again.

• Use the button “Assign custom fields” to decide yourself which information of the contacts will be exported.

• Finally, click on the “Finish” button and your contacts will be saved in an Excel-compatible CSV file.