ThirdParty Tool–Ideal Way to Export MS Excel Database

Excel is a component of Microsoft Office package. If you are using Excel, then you must be storing huge contacts lists including names, address, contact numbers, email addressed etc, in Excel XLS files.

Export MS Excel Database to Outlook: You can move data from MS Excel to Outlook. As with any database, you will need to name the columns your data is in. You can use whatever name you willing to give and map it to Outlook fields or export to Excel format and delete the data from the workbook and enter your data. You'll also need to name the used range of cells in Excel.

Things You Require While Converting Excel to Outlook

• Excel contacts list
• Microsoft Outlook email application
• Computer system

Manual Method to Convert Excel Contacts to Outlook

• The steps you'll need to follow the steps given below in Excel are:       

  1. Select your used data range and type a name in the field to the left of the address bar. (Include the field names in your selection.)
  2. Press Enter
  3. Save the workbook as an Excel 97-2003 workbook
  4. Close Excel
• After that, you need to follow the steps mentioned below in Microsoft Outlook email application:

  1. First, go to File
  2. Select Import and Export
  3. Select Import from a file
  4. Choose Microsoft Excel as the source
  5. Now, browse to the workbook file
  6. Select the contact folder from the workbook file
  7. Select the named range. If you export to Excel to get the field names, you'll see two named ranges when you import. Just make sure you select the correct named range
  8. If you are not using the field names that Outlook uses, you'll need to map your fields to Outlook's fields
  9. Press “Next” when ready
  10. Finish the import

Pitfalls of the Above Method: Manual method to convert Excel to Outlook has many drawbacks mentioned below:

• This method is very time consuming, long and tiring
• Outlook has the ability to import in other formats, but it may require more work to rearrange the information the way you want it
• Sometimes unexpected things can happen like original data can be altered during transfers. So, it becomes imperative for you to check for accuracy, which again is a pain