Friday, 11 April 2014

How to Move Excel Contacts to Outlook Contact List

Microsoft® Outlook holds the special place for keeping your contacts and other data together. On several occasions, you find the requirement to convert all your contacts from Excel in Outlook. While you discuss with others about your need for online software package, you will find many advices piled up in front of you. As a safety measure, choose simple steps to move Excel contacts to Outlook.

There are certain manual steps mentioned for moving Excel contacts in Outlook: You can import contacts from Excel to Outlook following three major steps:
  • Make your contact info ready to be imported in Outlook
  • Then Import the contacts information
  • Map the Excel worksheet column with apt Outlook fields

First Step: First of all save entire contact info from Excel in some file which Outlook can import

With Outlook, you can import CSV or Comma Separated Value files but no workbooks containing multiple sheets.
  1. In the workbook, press the worksheet comprises of contact details which you need to import
  2. Click File then Save As.
  3. Select the location to save the file
  4. Go to Save as type box, select CSV (Comma delimited) (*.csv), press Save.
    Note: Excel shows message that ‘The selected file type does not contain workbooks that contain multiple sheets.’ This is showing the drawback of CSV file but nothing wrong will happen to the original workbook
  5. Press OK.
    Note: Excel tells you “Some features in your workbook might be lost if you save it as CSV (Comma delimited).” This refers only to limitations of the CSV file and can be ignored.
  6. Press on ‘Yes’ to have Excel and save the latest worksheet as a CSV file. The original workbook or the .xlsx file closes. After this close the CSV file as well.
    Note: By going through above mentioned steps, you have done with Excel. Begin with import process in MS Outlook.

Second Step: Begin Import Process

  1. Go to Outlook, Press File >> Open & Export >> Import/Export.
    Note: This help begin working with Import and Export Wizard.
  2. Select Import from some other program or file and press ‘Next’
  3. Select Comma Separated Values and press ‘Next’
  4. Browse the CSV file you need to import.
  5. Under the Options, select if you want to replace duplicates (existing contacts), generate duplicate contacts else will not import duplicates.
  6. Press ‘Next’ and select the destination folder. Select the contacts by default, but if this is not the case, scroll up or down until and unless you fetch them. You can find a different folder otherwise, create a new folder.
  7. Click Next.
  8. Ensure that check box next to Import ‘MyContacts.csv’ is chosen.
  9. ‘Map’ few of the columns in your CSV file to the contact fields in Outlook. With mapping you can easily import contacts turn out the way you need.

Third Step: Map CSV files columns to the Outlook contact fields

  1. Press the Map Custom Fields button and you will find it popped up on screen.
    -> A box containing names from the CSV file you're importing will appear.
    -> Under To, you will find the standard fields which Outlook uses for contacts. In case when a field matches with the column in the CSV file, you will see the column under Mapped from.
    -> The fields Name, First Name, and Last Name is the standard Outlook contact fields, in case the contact info in your file has these contact names, you can go for it.
  2. Perform manual mapping.
  3. In the pane on the left, drag Cell Ph and drop it on Mobile Phone in the right pane.
    -> You'll notice that Cell Ph now appears next to Mobile Phone in the Mapped from column.
  4. At a time, do with the one then drag other values from the left pane to the suitable Outlook fields in the right pane.
  5. Click Finish.
Drawbacks of manual method: You will find the above mentioned method a cumbersome procedure. This process is so very long and at the same time to be followed. In fact, you are likely to face issue slow conversion, difficulties etc. It is better to opt for professional help where you have to pay less and get more effective consequences.

Keep away from migration hurdles via professional solution: By using online utility like Excel to Outlook, there are ample chances of making quick and safe contacts migration. This professional solution uses easy steps.

No comments:

Post a Comment