Import Excel Contacts(XLSX/XLS Spreadsheet) To Lotus Notes

By -
Lotus Notes of IBM is one of the desktop applications used by large business organization since it is designed to hold contacts, notes, emails, tasks etc. and preserves well ordering. With Notes storing of information is easy and secure. The performance and security provided by this desktop client is so large that, organizations rely on these as compared to web-based clients.


Since contacts can be managed easily with Lotus Notes, storing the data in Excel Spreadsheet is bit cumbersome nowadays. Everyone goes for easy method for storing the data, especially when it comes to organization level. Excel Spreadsheet stores data in rows and columns, holds large amount of data but, managing is a tedious task. Thus, anyone can go for export of Excel contacts to Lotus Notes.

Take this scenario:
“Recently, my senior staff asked me to renew the contact list stored in Notes and gave me an Excel sheet of contacts. Is there any possible and easy way since I don’t have much time to map all the contacts according to the Lotus Notes Contacts?”
If similar situation is faced by others as well then, stick to this blog. Here, an easy way to import Excel contacts to Lotus Notes contacts is described.

How To Export Excel Contacts To IBM Notes Contacts?

Users will have to first export the Excel file to vCard form which is supported by Lotus Notes. In-order to export .xlsx contacts spreadsheet to Lotus Notes compatible VCF file, users will have to lend the support of third party tools. Excel to vCard Converter tool is one such software that helps you to overcome the situation. Let us see how it helps.

Steps to Export Excel Contacts to Lotus Notes

  1. Install and launch the tool in your system.
  2. Run the software and browse the required file to convert.
  3. Click on the ‘Next’ button and you will find the window to map the fields. Map the fields of Excel with vCard and proceed with ‘Next’.
  4. Complete the filter procedures listed, you can choose the required vCard version. Then, go for the conversion by pressing the ‘Convert’ button.
  5. You will be able to see the process of conversion.
Now, you will come to end of Excel to vCard conversion. Once when the conversion is carried out, user can import the file directly to Lotus Notes.

Note: Discussion on the importing of vCard file in Lotus Notes is given below. The newly create VCF file is compatible in Lotus Notes.

Import vCard To IBM Notes

  1. Run Notes of your system and select the contact tab.
  2. Go for the ‘More’ option on the top and select “Import Contacts” choice from the dropdown.
  3. Choose the vCard file you have created from earlier steps and opt the file format as ‘vCard’.
  4. Proceed with “Import” button. All the contacts will be imported to the existing contacts of Notes. When the contacts are more than 250, a window will appear asking for your permission to proceed. Proceed by clicking ‘Yes’
Hope this information might be helpful for importing the contacts from Excel to Lotus Notes. Without any change to the data of your original spreadsheet, you can access your Excel contacts on Lotus Notes platform.


Comments

Post a Comment

Popular posts from this blog

How to Repair Excel Strict Open XML Spreadsheet ?

By -
Image
File Format In Microsoft Excel Workbook Microsoft Excel application is utilized for spreadsheet management. When users create a new worksheet in Excel, it can be saved in two main formats of XLSX. One is Excel Workbook (.xlsx) and another is Strict Open XML Spreadsheet (.xlsx) . These two formats are a bit different from each other.  How Strict Open XML Spreadsheet is Different ? The ordinary Excel Spreadsheet is called the transitional variant while Strict Open file is known as the strict variant. As the file name suggests, there are some restrictions in Strict Open Excel files. For example, Strict XLSX file contains graphics done by DrawingML, as VML is not supported. This file format also contains UNICODE Characters only. Strict XLSX also does not allow legacy techniques. User Query 1: “I am in urgent need to open some Excel files. I keep getting this error message whenever I attempt to open those files: Strict Excel Spreadsheet .xlsx is not valid. I do not k...
Read more

Can I Copy And Paste a List of Email Addresses from Excel To Outlook?

By -
Image
“Hello, I have recently joined an organization, in which I have to take records of thousands of contacts. And for easy management, I keep those contacts list in Microsoft Excel file. But recently there is a need to transfer all email addresses from Excel contacts to Outlook account. Therefore, I want to know, can I copy and paste a list of email addresses from Excel to Outlook? If yes, then how?” Now let’s start. Sorry, the answer is no. You cannot copy and paste the email address from the Excel sheet to Outlook, but you can import them to Outlook contacts. In this blog, we will discuss various solutions available to import contacts from Excel spreadsheet to Outlook contacts . So first let's discuss the manual solution and the difficulties which come with it. Import Contacts (Email Addresses) From Excel File to Outlook Open the Microsoft Outlook & go to the File menu Choose open & Export category from the dashboard Hit on the import/export. Select Import from...
Read more