How to Move Excel Contacts To Outlook & Vice-Versa

By -

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.

Comments

Post a Comment

Popular posts from this blog

How to Repair Excel Strict Open XML Spreadsheet ?

By -
Image
File Format In Microsoft Excel Workbook Microsoft Excel application is utilized for spreadsheet management. When users create a new worksheet in Excel, it can be saved in two main formats of XLSX. One is Excel Workbook (.xlsx) and another is Strict Open XML Spreadsheet (.xlsx) . These two formats are a bit different from each other.  How Strict Open XML Spreadsheet is Different ? The ordinary Excel Spreadsheet is called the transitional variant while Strict Open file is known as the strict variant. As the file name suggests, there are some restrictions in Strict Open Excel files. For example, Strict XLSX file contains graphics done by DrawingML, as VML is not supported. This file format also contains UNICODE Characters only. Strict XLSX also does not allow legacy techniques. User Query 1: “I am in urgent need to open some Excel files. I keep getting this error message whenever I attempt to open those files: Strict Excel Spreadsheet .xlsx is not valid. I do not k...
Read more

Can I Copy And Paste a List of Email Addresses from Excel To Outlook?

By -
Image
“Hello, I have recently joined an organization, in which I have to take records of thousands of contacts. And for easy management, I keep those contacts list in Microsoft Excel file. But recently there is a need to transfer all email addresses from Excel contacts to Outlook account. Therefore, I want to know, can I copy and paste a list of email addresses from Excel to Outlook? If yes, then how?” Now let’s start. Sorry, the answer is no. You cannot copy and paste the email address from the Excel sheet to Outlook, but you can import them to Outlook contacts. In this blog, we will discuss various solutions available to import contacts from Excel spreadsheet to Outlook contacts . So first let's discuss the manual solution and the difficulties which come with it. Import Contacts (Email Addresses) From Excel File to Outlook Open the Microsoft Outlook & go to the File menu Choose open & Export category from the dashboard Hit on the import/export. Select Import from...
Read more