Is there a way to Export the Contact in Outlook to Excel?

Hi Experts,
Is there a way to Export my Contact in Outlook 2013 to Excel?

How can I do this?

Thank you in advance,
mrotor
mainrotorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

discgmanCommented:
Yes, its file, open and export, import/export, choose export to a file, choose comma seperated values, select contacts in the list of folders, choose the name you give the file and the location and choose next. That should export your contacts to which you can open the csv file in excel and edit it.
0
Zac HarrisSystems Administrator Commented:
I have used the following method to do this: (Note: I pulled this from here )

Although the Import and Export wizard allows you to export to an Excel spreadsheet, the Wizard doesn’t allow you to export all the fields and filtering the mapped fields is a cumbersome process as well.

The export to Excel option has been removed from Outlook 2013 mainly because it was still using the old xls-format instead of the new xlsx-format. You can still achieve the same by exporting to the csv-format but that can be even more cumbersome.

Fortunately there is another, more graphical (WYSIWYG), way to do this as well via the copy/paste method.

    Change your view to a table view like the “Phone List” view;
        Outlook 2010 and Outlook 2013
        Home tab-> group: Current View-> Phone
        Outlook 2007
        View-> Current View-> Phone List
        Outlook 2003
        View-> Arrange By-> Current View-> Phone List
        Outlook 2002 and previous
        View-> Current View-> Phone List
    Insert and arrange the columns you want to export to Excel
        Outlook 2010 and Outlook 2013
        Tab View-> group: Arrangement-> button Add Columns
        Outlook 2007
        View-> Current View-> Customize Current View…-> button Fields…
        Outlook 2003
        View-> Arrange By-> Customize…-> button Fields…

        Outlook 2002 and previous
        View-> Current View-> Customize Current View…-> button Fields

        You can choose between even more fields by selecting “All Contact fields” from the “Select available columns from” dropdown list.  
        You can choose between even more fields by selecting “All Contact fields” from the “Select available columns from” dropdown list.
    Press OK until all the open screens are closed.
    Press CTRL+A to select al your contacts.
    (In Outlook 2007 and previous, you can also use Edit-> Select All)
    Press CTRL+C to copy your selected Contacts.
    (In Outlook 2007 and previous, you can also use Edit-> Copy)
    Open up Excel and select cell A1.
    Press CTRL+V to paste all contact information or use the Paste button on the Ribbon or on the Toolbar.
    Save your Excel sheet
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Zac HarrisSystems Administrator Commented:
You can use the option by @discgman but it takes more data manipulation and some people aren't comfortable with that. If that's your thing then go for it..
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Outlook

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.