[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More


How to Import Lotus Notes Contacts into Outlook with Manual Steps

Published on
4,514 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

Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

Join & Write a Comment

If you, like me, have a dislike for using Online Subscription anti-spam services, then this video series is for you. I have an inherent dislike of leaving decisions such as what is and what isn't spamming to other people or services for me and insis…
This is Part-2 of Learning to use the Power of Mailwasher Pro so if you haven't watched Part-1 yet, I urge you to do so before watching this video. Click this link to watch Part-1 (https://www.experts-exchange.com/videos/56638/Learn-to-use-the-POWER…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month