15
Export the Microsoft Outlook address book data
• In Microsoft Outlook, select File > Import and Export.
• Select Export to a file > Next.
• Select Tab Separated Values (Windows) > Next.
• Select Contacts > Next.
• Select Browse.
• Select a folder and enter the file name to export the data to.
• Select OK.
• On the Export to a File window, select Next.
• Select Map Custom Fields.
• Clear all items in the To list by selecting Clear Map.
• Drag selections in the From (First Name, Last Name and Business Phone) to the
To list.
• Select OK.
• Open Microsoft Excel.
• Click Office Button > Open.
Please note: Make sure to open a TSV file in this procedure. Changing the
extension of a TSV file to “.csv” may cause the character encoding of the file to
be distorted.