QueHow

A How-To and wiki Blog

  • Operating System
    • Windows
      • Windows 10
      • Windows 7
    • Linux
  • Software
    • Application Software
    • Microsoft Office
      • Outlook
      • Word
      • PowerPoint
  • Internet
    • Browsers
      • Mozilla Firefox
      • Google Chrome
    • CMS
    • Tips & Tricks
  • Website
    • ecommerce
    • Google
    • Social Networking
    • General Websites
  • Mobile
  • Email
    • Gmail
  • Wiki

How to Export Contacts from Outlook 2010 to Excel

By Neha T Leave a Comment

The Microsoft’s most attracting feature is the contact view that keeps all your contacts organized and easily traceable without any hassle. Contacts in Outlook contains the address books ,which sooner or later, you may need to make the copies of it.

If you want to copy the contacts in another file, you can export these contacts to that file in various formats such as web mail clients, excel spreadsheets, or database applications.

Comma Separated Value (CSV) file are the most commonly used file format. Exporting contacts from outlook  to excel is an easy process which can be done by following the simple steps.

Steps to Export Contacts from Outlook 2010 to Excel

Step 1: Open Microsoft Outlook 2010 on your computer system.

how-to-export-contacts-outlook 2010-excel-step1

 

Step 2: Click the “File” tab on the top of the screen and select “Options” from the left navigation bar as shown in the image.

how-to-export-contacts-outlook 2010-excel-step2

 

Step 3: You will find “Advanced” option from the left side navigation bar in the “Options” window. Click it to open advanced features of outlook 2010.

how-to-export-contacts-outlook 2010-excel-step3

 

Step 4: Click on “Export” button as shown in the image. The “Import and Export Wizard” window will then open.

how-to-export-contacts-outlook 2010-excel-step4

 

Step 5: Select “Export to a file” option from the list and click on “Next”.

how-to-export-contacts-outlook 2010-excel-step5

 

Step 6: You have to select an option from the given formats available for exporting. You will find various formats like text files, databases, spreadsheets, and a personal folders file.

  • Select “Comma Separated Values (.csv)” option if you are using Outlook 2010 on a Windows computer, and you want to import it to an unrelated program.
  • Select “Excel spreadsheet option (.xls)”, if you want to gain access to the file for a backup or spreadsheet function.

Here I am selecting “Comma Separated Values” (.csv) option and then, click On “Next”

how-to-export-contacts-outlook 2010-excel-step6

 

Step 7: Select “Contacts” folder from “Export to a file” window and then, click on “Next”.

how-to-export-contacts-outlook 2010-excel-step7

 

Step 8: Browse the file name from your computer as shown in the image. Choose the file name and the type of the file and click on “OK”.

Type of the file name should be in “.CSV”

how-to-export-contacts-outlook 2010-excel-step8

 

Step 9: Click “Next” after saving the file in “Export to a file” window.

how-to-export-contacts-outlook 2010-excel-step9

 

Step 10: Check ‘Export “Contacts” from folder: Contacts’ and then click on “Finish” to complete the exporting.

how-to-export-contacts-outlook 2010-excel-step10

 

Step 11: Finally click on “OK”.

Your contacts has been exported to the file you selected.

how-to-export-contacts-outlook 2010-excel-step11

You Might Also Like:

How to Import Contacts in Outlook 2010 How to take Backup of Outlook 2010 How to put Signature in Outlook 2010 How to Schedule a Meeting in Outlook 2010 How to Change your Name (IMAP and POP3) in Outlook 2010 How to Encrypt E-mail in Outlook 2010 How to Recall an Email in Outlook 2010 How to make Signature in Outlook 2010

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Most Viewed

  • How to Install and Use TELNET in Ubuntu
  • How to install Hindi fonts in MS Word
  • How to Change a File Extension in Windows 10?
  • How to create a flipkart account in 3 simple steps
  • How to Change Monitor Refresh Rate in Windows 10?
  • How to install IIS on Windows 10
  • How to Insert Clickable Checkbox in MS Word 2016?
  • How to Set Auto Reply in Outlook 2016?
  • How to Login as Administrator in Windows 10?
  • How to Check RAM Size and System Type in Windows 10?

Recent Additions

  • How to Add Hyperlink to Another Sheet in Excel?
  • How to Add and Remove Watermark in Excel
  • How to use Relative and Absolute Cell Reference in Excel?
  • How to Enable and Disable Scroll Lock in Excel?
  • How to Use INDEX and MATCH Functions in Excel?
  • How to Make Bar Graph in Excel?
  • How to Count Duplicate Values in Excel?
  • How to Wrap Text in Excel?
  • How to Round off Numbers in Excel?
  • How to Create a Bell Curve in Excel?

Related Searches

  • How to Sort Data in Ms Excel 2016?
  • How to Hide Formula in Excel?
  • How to get Offline Maps from the Maps App in Windows 10
  • How to install Hindi fonts in MS Word
  • How to update Mozilla Firefox to Latest Version?

Copyright © 2023 · QueHow · Contact Us