Lotus Notes7 min read

How to Export Lotus Notes Data to Excel?

Anjali Rawat
Published:

Quick Answer

You can export Lotus Notes data to Excel by saving a view as a CSV file and opening it in Excel.

Open the view, select File then Export and choose Comma Separated Value as the file type.

Lotus Notes to Excel Converter saves your full address book from names.nsf to an Excel file in one go.

Lotus Notes keeps contacts, mail and other records in databases that Excel cannot open. Teams still need those records in a sheet. They sort contacts, build mailing lists and check old address books in rows and columns.

Lotus Notes has a built in export for views. It works for short lists and falls short for a large address book or a locked file.

This guide shows the manual steps and the converter method, so you can choose the one that fits your data.

What Lotus Notes Data Can You Move to Excel?

Lotus Notes, now sold as HCL Notes, stores data in NSF databases. Your address book sits in a database named names.nsf. Mail, calendar entries and custom applications sit in other NSF files.

Notes shows every database through views. Every view lists records in rows and columns, which is why it maps well to a sheet. You can export the data of a view and open it in Excel.

Most users ask for one thing first, and that is the contact list. Names, email addresses and company details are the data that people move to Excel most.

People move this data to Excel for a few common reasons.

  • Sorting and sharing. You want to sort, filter or send your contacts in a spreadsheet.
  • Mailing lists. Your team needs names and email addresses for a campaign.
  • Old address books. You want to check every contact and fix old details in one place.
  • New apps. You plan to load your contacts into Outlook or a CRM.

How to Export a Lotus Notes View to Excel Manually?

Suits: Small views and a quick check of your records.

Needs: Lotus Notes with the view open.

Limit: Only view data exports. Notes cannot export to CSV from an open document.

  1. Open the view in Lotus Notes, for example your Contacts view.
  2. Select the documents you want to export.
  3. Select File then Export.
  4. Type a file name that ends in .csv.
  5. Choose Comma Separated Value in the Save as type list.
  6. Choose All documents or Selected documents.
  7. Check Include view titles when you want column headings in the sheet.
  8. Confirm the export and open the CSV file in Excel.

HCL explains that exporting from a view copies the data into a new file and leaves the documents in the view. Expand collapsed sections first, because Notes does not export entries inside them.

Notes view export also offers tabular text and structured text files. CSV is the type that Excel opens straight away, so choose it for a sheet.

Export follows the view. Check the columns the view shows before you start, because the CSV file holds those columns and no more. Contacts with many details need a view that shows them.

This way suits a short list. Full address books with hundreds of contacts need careful column checks and repeat exports.

How to Export Lotus Notes Data to Excel With a Converter?

Suits: Full address books and password protected names.nsf files.

Needs: A Windows PC, the names.nsf file and Lotus Notes 9.0 or an earlier version.

Limit: Contacts only. Free demo exports 15 contacts.

Lotus Notes to Excel Converter loads names.nsf and lists every contact in a preview window. It exports personal, business, briefcase and advanced details in one Excel file. Contacts sort by the first letter of the first name.

  1. Download the free demo and install it on your Windows computer.
  2. Open the software, add names.nsf and click Scan.
  3. Look through the contact list and check the details.
  4. Click Export to Excel, then click Open Export File to see your sheet.

These screens show the scan, the export option and the final view.

Lotus Notes to Excel scan of Notes contacts

Lotus Notes to Excel option to export Notes contacts

Lotus Notes to Excel exported contacts in the final view

Lotus Notes to Excel Converter exports the full address book at once, not one contact at a time. Your Excel file saves at the location of your names.nsf file. Lotus Notes to Excel Converter also works on a locked names.nsf file when you forgot the password.

Free demo mode previews your contacts and exports 15 of them, so you can check the Excel layout before you buy. Full export needs the full version.

Deleted contacts do not come back. Lotus Notes to Excel Converter converts only the contacts it can get from names.nsf.

What to Check Before You Export Contacts?

Five quick checks save you from a failed export. Go through this list before you start.

  • Lotus Notes client. Install Lotus Notes 9.0 or an earlier version as a standalone client. Keep it disconnected from the Domino server and use a valid or dummy POP3 profile.
  • Windows version. Windows 10, 8.1, 8, 7, Vista and XP work, along with Windows Server 2012, 2008 and 2003.
  • Framework. Install Microsoft .NET Framework 4.5 or later and use the Administrator account on Windows 10, 8.1, 8, 7 and Vista.
  • Memory and space. Keep 512 MB RAM at minimum, 1 GB recommended and 5 MB of free disk space.
  • File copy. Copy names.nsf to a safe folder before you scan it.

What to Do After the Export?

Open the Excel file and check the columns. Sort the contacts by name, remove old entries and fix details in one place. Microsoft explains how Excel opens CSV files on its text and CSV import page, which helps when the columns look wrong. Check the first rows for names or emails that landed in the wrong column.

Moving the contacts to Outlook? Excel to Outlook Converter loads XLS, XLSX, XLSM, XLSB and CSV files, maps the columns and saves the contacts in Outlook.

Share the sheet only after you remove contacts that the team no longer needs. Keep names.nsf as the source copy, so you can export again when the list changes.

Which Method Fits Your Case?

CaseMethodNeeds
A short view of recordsExport view to CSVLotus Notes
Any Notes view, not only contactsExport view to CSVLotus Notes
Full address book in one fileLotus Notes to Excel ConverterWindows PC and names.nsf
Locked names.nsf fileLotus Notes to Excel ConverterWindows PC and names.nsf

Best Practices for Lotus Notes Excel Export

  • Work on a copy of names.nsf and keep the original untouched.
  • Export a few records first and check the columns in Excel.
  • Expand collapsed sections in a view before you export it.
  • Save the Excel file under a clear name and store a copy on a second drive.
  • Remove duplicate and old entries before you share the sheet.
  • Keep a backup of names.nsf until the team confirms the sheet is complete.

Author's Verdict

Use the built in view export when you need a short list or a view that is not an address book. Choose Lotus Notes to Excel Converter when you need the full address book, every contact detail or a locked names.nsf file. Test the free demo on your own file first and check the preview before you buy.

FAQs on Lotus Notes to Excel Export

How Do I Export Lotus Notes Data to Excel?

Open a view, select File then Export and choose Comma Separated Value, then open the CSV file in Excel. For a full address book use Lotus Notes to Excel Converter.

Can I Export Lotus Notes Contacts to Excel?

Yes, add names.nsf to Lotus Notes to Excel Converter, scan it and export the contacts to an Excel file.

Does Lotus Notes Export to XLSX Directly?

No, Lotus Notes saves a view as a CSV file that you open in Excel. Lotus Notes to Excel Converter gives you the contacts in one Excel file.

Can I Export a Password Protected NSF File?

Yes, Lotus Notes to Excel Converter works on a locked names.nsf file even when you forgot the password.

Can I Export All Contacts at Once?

Yes, the converter exports the full address book at once and keeps personal, business, briefcase and advanced details.

Does the Converter Export Mail or Only Contacts?

It exports contacts from names.nsf. Use the view export for other views in Lotus Notes.

Can I Try the Export Before I Buy?

Yes, the free demo exports 15 contacts. Full version exports all contacts.