Pages

Wednesday, 27 January 2016

How to Move Excel Contacts To Outlook & Vice-Versa

Introduction

MS Outlook is one of the most commonly used email clients that keep us connected across our devices with powerful organizational tools and a suite of Microsoft applications & services. MS Outlook stores the email data, contacts, calendars etc. in single PST file.In this page, we will be discussing on procedure of exporting to and importing from Excel Contacts in Outlook .


Excel Contacts to Outlook

The Excel spreadsheet file containing important contact information can be imported into Outlook Contactsso that it can be utilized in MS Outlook. Without importing, the MS Excel spreadsheet will not be readily accessible in MS Outlook or to other programs that may access the Address Book.
However, earlier versions of MS Outlook allow exporting of Outlook data to Excel file to work with it from there or import data into MS Outlook from Excel, This option is no longer present in Outlook and later versions.The manual procedure for using Excel contacts in Outlook involves exporting contacts information to Excel and importing from Excel to Outlook.

Export Outlook Contacts To Excel File

We need to make sure that we export our data to a .csv file format instead of an .xlsx because both Excel and Outlook supports CSV format. Once the contacts are exported to a CSV file, the file can be saved as an Excel file later on.The steps for exporting data to CSV file are almost same but we need to choose “Comma Separated Values” option. We can open the CSV file in Excel by double-click or setting file filter as All Files (*.*) or Text Files (*.prn;*.txt;*.csv”)
Exporting contacts from Outlook to Excel can be done in two ways-
I. Using Import/Export
Open Outlook account, click ‘File’ and ‘Open & Export’, and then select ‘Import/Export’ option. Here are the steps with screenshots.
  1. Choose ‘Export to a file’
  2. Select ‘Comma Separated Values’ (CSV)
  3. Select ‘Contacts’ Folder since we want only this particular folder
  4. Set destination path of the CSV file containing contacts.
  5. Check the Export option and click ‘Finish’
  6. Export is completed from Outlook Contacts to Excel CSV file.
II. Using Copy + Paste
This option does not require Import/Export Wizard. For this, open your Outlook Account, open Contacts Folder, select the contacts you want to export and then copy it from Outlook and paste them directly in Excel. Then save the Excel file in CSV format.

Import Contacts In Outlook

The Excel file containing contact information can be imported into MS Outlook by first saving it as a CSV file and then following the below-mentioned steps:
  1. Open the Import and Export Wizard and select ‘Import from another program or file’.
  2. Select CSV and click ‘Next’
  3. The file will be automatically selected and is now ready to import.Three options are available to choose whether to import duplicate contacts or not.Click ‘Next’ and select Folder where we want to store the imported items.
  4. Import the CSV file into Contacts Folder and click ‘Finish’.

Conclusion

The contacts present in MS Excel saved in CSV format can be accessed easily in MS Outlook by following the steps explained in manual procedure. Though manual method is familiar with the people from technical background, some other people find it difficult to follow the manual procedure.That is why third party software like Excel to Outlook Converter can be used for moving contacts from Excel to Outlook.

0 comments:

Post a Comment