Home Lotus Notes

Import Excel Contacts to Lotus Notes

Lotus Notes acts as one the secured Desktop Based Email Client application that help millions of user to send & receive messages for Corporate activity. It not only stores emails, but also include various functions such as Scheduling, Calendar management, programming, discussion forums, instant messaging, Web Browsing etc. If you want to Import and Export contacts in Lotus Notes, you can use vCard File format.

Since Excel file can store a large number of user information such as Username, Address, Email address, Contact number, Company name etc. The vCard file format supported by Notes to store contact files and can be converted from Excel file format to stores a large number of contacts in Lotus account. For that, you can download Excel to vCard Converter. As no direct methods are available to import Excel contacts to Lotus Notes Account.

Key Features – Excel to Lotus Notes Contacts Converter

  • Import Excel Contacts into Lotus Notes Application
  • Preview Complete Excel file details before exporting to device
  • Both XLS and XLSX Format of Excel supported by Software
  • Store Exported Contacts into different VCF Foramt Versions

How to Import contacts to Lotus Notes from Excel

  • Step1: Convert Excel contacts to vCard File format
  • Step2: Import VCF File Contacts to Lotus Notes Account

To Import contacts to Lotus Notes from Excel Workbook, First, a user need to convert Excel (XLS, XLSX) contact information into VCF file format, supported by Lotus Notes application. Follow the below steps properly :

import vCard contact to lotus notes

1 - Launch Excel to VCF Converter

Download & Run the Excel to VCF Software. Click on Browse File option and just Locate the Excel file (XLS/XLSX) in Configured system.

view excel file contacts details

2 - Preview Contact Information:

When Excel file properly configured within software, user can view Excel file details.

map vCard to Lotus notes contacts

3 - Mapping Functions

Now Map the field attributes of Excel File with the vCard File attributes.

select vCard format

4 - Different vCard Versions:

Software offers three options:
  • Empty Email Address: Allow to Import Empty Email Address
  • Single vCard File: Allow to create Single VCF File for All Contacts
  • vCard Version: Select Different vCard File Version

Import vCard to Lotus Notes Address Book


5 - View vCard File:

Now Browse the Location to view the exported Vcard File.

launch Lotus notes application

6 - Launch Lotus Notes Application

Now Start Lotus Notes Email Client and Provide Username and Password Credentails to Login to your account.

open contact section in lotus notes

7 - Contact Section

Now Go to Contact section to add Excel contact to your Lotus Notes profile.

import excel contact to lotus notes

8 - Import Contacts

In account interface, Click on "More" option and select "Import Contacts" from the Drop-down menu.

browse vcf file

9 - Browse VCF File

Now Browse the exported VCF File file from the above conversion process and click on "Open" button.

add contact

10 - Add Contacts

If number of imported Excel contacts into Lotus notes is greater then 250 contacts then a pop appear with message-box, do you want to continue or not . Click on "Yes" button.

import option

11 - Import Option

User can Preview contacts before importing into Notes Account using "Next" option. Now Click on "Import" option to transfer Excel contacts to Lotus Notes Application.

Synchronize VCard Contacts to lotus notes contacts

13 - View Excel Contacts

After sometime, you can able to view imported contacts in Address Book of Lotus Notes Account.

Follow the above procedure properly to import Excel Contact to Lotus Notes Application, before that, use Excel Contact to Lotus Notes Convert to export Excel file contact into vCard.