You are here:

Using Lotus Notes/Importing Excel Database into Lotus Notes Contacts


Frenchy wrote at 2008-06-11 03:43:50
Hi Tomasz,

I am trying your suggestion to import from an excel to Lotus 6.5 and it is just not working I get invalid. I get "invalid worksheet file format". I am brand new on Lotus Notes, but do not consider myself complitly useless with computer having been coding in Assember, C and C++ for years. I am, however sure it is human error. Can you help at all?



DaudLamber wrote at 2009-11-10 17:47:27
Note that Excel 2003 does not enable saving to WK4 format by default,  and you have to add the "LotusandQuattroFiles" value to the "...\Security\FileSaveBlock" key as described in the following article to enable it:  

Jeannie080561 wrote at 2012-04-30 13:37:30
Hello I did it anothere way. I saved my Excel spreadsheet as a csv (delimited file) went to contacts in Lotus Notes, file and import. Then I mapped the fields from left to right to match them and then imported them. v easy.  

Gizik wrote at 2013-05-28 15:46:25
Hi Jeannie,

Thanks for this suggestion. I am trying to this as you suggested, but it is showing a lot of errors, such as address instead of name, misplaced info, etc.

Do you know how to solve it?

Gratefulf for your advice.



Using Lotus Notes

All Answers

Ask Experts


Tomasz Frydryk


I have over 10 years experience with Lotus Notes and Lotus Workflow. I`m specialized in programing Workflow aplications and cooperation between Lotus Notes and another aplications and systems. I have experiences with Lotus Connectors (DB2 and SAP), ODBC and COM integration. I`ve worked with windows based systems as well as with Linux, UNIX (e.i. HPUX) and AS400. Of cuorse I am CLP certificated person. I am able to speak (not ever errorfree, but with two-side understanding) polish, englich, german and russian.


Lotus Notes, Lotus Workflow, integration with another systems with Conectors, ODBC, COM.
I do not have a lot to do with Java, almost nothing with JavaScript and WEB aplications.

Polish Social-Democratic Party, Mensa.

University Master Degree in Mechanical Ingeneering,
University Master Degree in Marketing and Management,
Post-Graduate Studies in Banking,
Now I am working about obtaining a doctorate in economics.

©2017 All rights reserved.