How do I export my Lotus Notes address book to Excel?

Favorite Answer

I'd open excel, click file, import, and se where that takes you


bd...Show more

If you do not want to buy a third party export tool, you will need to create your own export view in your Notes address book. This is not difficult, but can be very, very time consuming.

The Notes export feature has 3 different export options for creating spreadsheets: CSV, Lotus123, and Tab Text, all of which export the exact columns of data that you see in the Notes view from which you are performing the export.

To create an appropriate view for exporting address book data, you'll first want to gather the field names you wish to export. If you do not have a designer client, you can find the field names by looking at the second tab of an address book entry's properties box. Here's an example list of some of those field names:

Title
FirstName
MiddleInitial
LastName
Suffix
CompanyName
Department
JobTitle
OfficeCity

Once you have your list of field names, create your export view by clicking on the Create menu and selecting Design....View..

Your view selection formula will be SELECT Form = "Person"

There will probably already be a few predefined columns in your view, you may want to edit those so they display the fields you wish to export. For most fields, you'll be able to simply select a field name to be displayed from the field list.

There are a few fields that may have multiple values that you will want to create multiple columns for. Example: If you have multiline street addresses in your addressbook, you will want to have a column for each of those lines. Here are the formulas for two different columns, one displaying the first line, and a second that displays the second line of the OfficeStreetAddress field:

(Column one formula):
temp1 := @If(OfficeStreetAddress != ""; @ReplaceSubstring(OfficeStreetAddress; @NewLine; "~"); "");
@If(temp1 != ""; @Word(temp1; "~"; 1); "")

(Column two formula):
temp1 := @If(OfficeStreetAddress != ""; @ReplaceSubstring(OfficeStreetAddress; @NewLine; "~"); "");
@If(temp1 != ""; @Word(temp1; "~"; 2); "")


Once you have your export view created, from your export view, choose File....export. Change the filetype to Comma Separated Value, enter a file name, inclucing the .csv file expension, then click Export. As you probably know, you'll then be able to open the csv in Excel, where you will be able to save it as an xls file.

Good luck
...Show more

If you want your Notes Contacts without any alteration and corruption then you have only choice of using External Utility software which migrates your all contacts flawless and arranged them in sorted form. You can get more information at:...Show more

For the best answers, search on this site https://shorturl.im/ax7uM

Use Yahoo! Intellisync Software. Download it from Yahoo's site. You can configure to sync ur addressbok from Yahoo!...Show more