Export Outlook Contacts to Excel or Export Windows Mail Contacts to Excel

Oct 07 2008

Export Outlook Contacts to Excel or Export Windows Mail Contacts to Excel

Posted by alex in Insights

Below is a step by step guide to export your Microsoft Outlook contacts to Excel as well as a step by step guide to export your Windows Mail to Excel. If you are running Windows Vista follow the Windows Mail steps and any other Windows version, including Windows XP, should use the Microsoft Outlook steps.

Export Contacts from Windows Mail to Excel:

Open Windows Mail: Click Start Icon, Click All Programs, Choose Windows Mail
Select Contacts: From Windows Mail Select Tools, Select Windows Contacts, Left Click Windows Contacts.

Select Export: From the center window navigation, Click Export

Choose CSV:Select CSV [which means Excel], Click Export

Choose Location: Click Browse and browse to the desktop

Click Next: Verify location, Then Click Next

Select Fields: Check the fields you want to appear in the Excel file, For instance: First Name, Last Name, and Email Address to have an excel file with three columns.

Finish: Select Finish, Left Click
Verification: Click OK once Windows verifies it has exported the file.

Open Excel: Locate the file on your desktop and make sure the contacts were exported properly or email this file to the person requesting it.

Export Contacts from Microsoft Outlook

Open Outlook: Choose MS Outlook from the start menu
Select Export: Click File in the top navigation, Scroll down and select Import and Export

Select Method: Highlight “Export To a File”, Click Next

Select Type:Highlight “Microsoft Excel”, Click Next

Select Folder: Highlight “Contacts”, Click Next

Browser for Location: Click Browse and navigate to desktop

Name File: Choose a name for your Excel file, Type it in, Click OK

Move Forward: Click Next

Verify Action: Make sure the action is correct, such as “Export Contacts from folder: Contacts”, If so Click Finish **Note you may also custom map fields as well by clicking “Map Custom Fields”.

Verify: Wait until the progress bar is finished, Open file and verify it has exported properly.

Outlook Express should be very similar to Outlook. I was unable to find a download of Outlook Express as it is no longer included with the latest downloads of Internet Explorer.

Pick up a copy of Excel from Amazon.

Microsoft Office Home and Student 2007

Microsoft Software 2007, CD-ROM, $60.00

A great book to really get started with Excel.

Excel 2007 For Dummies (For Dummies (Computer/Tech))

Greg Harvey. For Dummies 2006, Paperback, 408 pages, $12.79

Share: Click an icon below to share using one of the social networking sites below. These icons link to social bookmarking sites where readers can share and discover new web pages.