NotesSQL is an ODBC driver for Notes Database(.nsf File). People can leverage it to query a Notes Database through ODBC.
In Excel people can import data from external data sources, so NotesSQL provides a convenient way to transfer data from Notes to Excel.

1, Install NotesSQL. It can be downloaded from
Notes Toolkit

2, Add a data source from ODBC Administrator
Select "Lotus Notes SQL Driver (*.nsf)" as driver.

Input data source name, server name and db file. You can also provide user name and password.


3, From Excel menu - Data->Import External Data->Import Data...

New Source...

Select ODBC DSN as source type

Select ODBC data source

Select the object you'd like to import

Give the source a file name then "Finish"

Select the file you just saved as source, then "Open"

Select where you would like to put the data to

Then you can see the data