How to Import Lotus Notes Contacts into Outlook with Manual Steps

Published on
4,046 Points
2 Endorsements
Last Modified:
Geeta Malik
Hi, my name is Geeta Malik. I have completed my degree in 2012 and working for an IT Company as Content Developer.
This article describes how to import Lotus Notes Contacts into Outlook 2016, 2013, 2010 and 2007 etc. with a few manual steps. You can easily export and migrate Lotus Notes contacts into Microsoft Outlook without having to use any third party tools.

A very common question I frequently see is how to import Lotus Notes contacts into Outlook. I also found few similar queries at Experts-Exchange. That’s why I decided to write an article with a quick and easy guide showing how to import contacts from Lotus Notes into Microsoft Outlook.  

Some users tend to go with paid tools for such a small task due to a lack of awareness about a manual solution. By following this guide, you'll be able to transfer your Lotus Notes contacts to Outlook effortlessly, with just the two simple processes described in this article. Now you can say 'bye bye' to 3rd Party Tools for such a simple task.

Step 1: Export All Lotus Notes Contacts to a CSV File

In the very first step, we need to export our Lotus Notes address book to a CSV (Comma-Separated Values) file format. Later we can import the resulting CSV file into Outlook. We will download and save all our contacts from Lotus Notes to a CSV file. This procedure is very easy to understand and is shown below:

  1. Launch and open your Lotus Notes Application and Click on Contacts.
  2. Lotus Notes will open Address Book in a new tab. Now Select the “Export Contacts” option after clicking on “More” as shown in the snapshot below.

  3. A Dialog box will appear on the screen, choose the required field, provide a file name for the CSV file and then Click on the “Export” button.

  4. A few seconds later, you will have all of your Lotus Notes Contacts saved into a CSV file.

Step 2: Import CSV File into MS Outlook 2016, 2013, 2010 and more…

Having completed the 1st step, we are done with 50 % of the process.

Now in this second step, we will import the resulting CSV file into MS Outlook with the help of the the Outlook Import/Export Wizard.

  1. Open Microsoft Outlook, Select File > Open & Export from the File menu bar and then choose the Import/Export option

  2. The Import and Export Wizard will appear on the screen. Select “Import from another program or file” and then click on the “Next” button.

  3. Now Select the “Comma Separated values (Windows)” option and click on the “Next” button.

  4. Click on the “Browse” button to locate and select the CSV file that you exported and saved from Lotus Notes in Step 1 of this guide. Select the radio button you prefer in Options, and then click on the “Next” button.

  5. Select the "Contacts" folder in your MS Outlook Data File where you want your Lotus Notes contacts to be imported to, and then Click the Next button.

  6. Map custom fields is an optional choice, use it if required and then click on the “Finish” button. That’s it.

  7. It will take a few seconds to import Lotus Notes contacts to Outlook from the .csv file created in Step 1.

  8. Once you're done with above procedure, you will be able to see your Lotus Notes Contacts in your MS Outlook address book.

The process I have discussed above is very easy to perform and does not require any other applications to export Lotus Notes contacts into Microsoft Outlook. Still, there are a couple of small drawbacks I don’t want to hide and that you should be aware of.

  1. Only basic fields will be imported and specific fields may be deleted or altered.
  2. Images and logo's will not get imported

Conclusion: In this article I tried to introduce the simplest way I know of to import Lotus Notes Contacts to Microsoft Outlook, and also provided screen capture snapshots of the steps to make the process as easy as possible to follow.

You will now be able to access your Lotus Notes Contacts in Outlook without using any free or paid utilities.

I hope you love this post. Please feel free to post your comments and feedback.

Author:Geeta Malik

Expert Comment

by:Christ Harold
Nice Article Geeta......

Author Comment

by:Geeta Malik
Hi Christ Harold, Thank you so much for your appreciation.

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Join & Write a Comment

There may be issues when you are trying to access Outlook or send & receive emails or due to Outlook crash which leads to corrupt or damaged PST file. To eliminate the corruption from your PST file, you need to repair the corrupt Outlook PST file. U…
Discover the basics of using Outlook 2016 from office 365.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month