csv Archives - Syntax Byte

Microsoft Outlook Export Contacts to Excel (CSV)

In this article we are going to export contacts to an Excel sheet. The resulting file is a CSV file that can be opened in Excel or used for another purpose, such as importing in another program. If you wish to save it as an XLSX file (regular excel file format), simply open it in Excel and save it as a regular file. To get started, open Outlook. Locate the folder containing the contacts you want to export if you have multiple.

Showcasing contacts to export in Outlook interface. — The folder containing the contacts to export is highlighted. Remember its name so you can select it in the export wizard.

Microsoft Outlook Import Contacts from Excel or CSV

In this article we are going to import contacts to Outlook from an Excel file. My file is currently in .xlsx format so we will first convert it to .csv format. Then, we will map it and import the contacts.

excel file with contacts to import — The Excel file with contacts to import