How to Synchronize Outlook Contacts With Excel Spreadsheetsby Andrew McClain
Outlook stores its Contacts data in a PST file that you can use to import and export contacts between Outlook on different computers. If you want to export the data and use it in Excel, such as to perform a mail merge or print address labels, you'll need to export the PST file to a CSV file that Excel can read. To synchronize the two, repeat this process regularly.
Open Outlook, select "File," and then click "Open & Export." Click "Import/Export" to open the Import and Export wizard.
Select "Export to a File" and click "Next."
Click "Comma Separated Values" from the "Create a File of Type" list and click "Next."
Click "Contacts" from the "Select Folder to Export From" field and click "Next."
Browse to the location where you want to export the file and click "Next."
Verify that the "Export" option is marked and click the "Map Custom Fields" button.
Click any fields listed in the "From" column and drag them to the "To" column. Click "Clear Map" to remove all fields, and then click "Previous" or "Next" to see individual records. If a "+" appears next to a field, you can click on it to expand the list.
Click "OK" to close the dialog box and return to the wizard. Click "Finish" to export the file.
Open Excel, browse to the location of the file and click "Open" to load it.