Steps to Convert Excel Contacts into Lotus Notes

Lotus Notes is a database management system and "emailing" is its popular and strongest part. Many large organizations across the world employs Lotus Notes to manage their email transmission, web server, programming etc as it provides a higher level of security. The information is available centrally on Domino Server because of it; organization gets widely access to individual user data as well as organization address book information.


In Excel, people can easily manage large no. of contact information like email address, business address, contact number, full name, website etc. So, if you are one of those users who have their contact information's stored in Excel sheet and wants to access it with Lotus Notes then here are the steps to import Excel contacts into Lotus Notes platform.

For Importing Contacts from Excel to Lotus Notes, 2 Stages Needed


How to Export Excel Contacts into VCF File?


Here you will find easiest yet complete step-by-step guide to convert contacts from Excel spreadsheet into vCard format which can be further imported into Lotus Notes application.


  • Install "Excel to vCard Converter" tool, "Browse" to add CXV, XLS or XLSX file and then check added Excel file preview. Click on "Next"

    export contacts from excel to vcard and copy it into lotus notes

  • Now when the Excel file is successfully added, Excel fields need to be mapped with vCard field for proper conversion. Click on "Add" after mapping every fields and then click on "Next"

    map excel field with vcard field

  • For beginning export process, select the given options:

    • "Single vCard file for all contacts" to convert all contacts from Excel to single VCF file
    • "Allow Empty Email Address" to import contacts without email address

    Select destination location and then click on Convert

    select export option to start importing excel contacts into vcard for domino server

  • Now all contact information from Excel file is stored into single VCF format which can be easily imported into Lotus Notes.

Import VCF File Contacts into Lotus Notes Address book

Here, we will explain the process to copy or transfer Excel contacts into Domini Lotus Notes application.


  • Open "Lotus Notes Email Application" (Enter password to access it)

    open lotus notes application to copy excel contacts

  • Click on "Contacts" from the available options

    select contacts option to transfer excel contacts in lotus notes

  • Click on "More" options and from the drop down menu select "Import Contacts" option

    click on import contacts option to conver excel contacts to notes address book

  • Select VCF file from your machine and click on "Open"

    add vcf file to start importing contacts in notes address book

  • If your VCF file contains more than 250 contacts then a pop-up window will appear asking you whether you want to precede further, Click on "Yes"

    click on yes and copy contacts from excel cls, xlsx or csv into lotus notes

  • Now, VCF contained contacts will be shown in the preview window, click on "Import"

    click on import option in lotus notes address book

  • When the conversion procedure gets completed, a pop-window will appear showing the successful importing of contacts

    excel to lotus notes importing process is completed

  • Now you can see the imported contacts in Lotus Notes address book

    contacts from excel spreadsheet is transferred into lotus notes


Now the procedure of converting contacts from Excel sheet into vCard file and then importing them into Lotus Notes platform is accomplished.