Skip to Main Content
HCL Domino Ideas Portal

Welcome to the #dominoforever Product Ideas Forum! The place where you can submit product ideas and enhancement request. We encourage you to participate by voting on, commenting on, and creating new ideas. All new ideas will be evaluated by HCL Product Management & Engineering teams, and the next steps will be communicated. While not all submitted ideas will be executed upon, community feedback will play a key role in influencing which ideas are and when they will be implemented.

For more information and upcoming events around #dominoforever, please visit our Destination Domino Page

import data directly from XLS/ODS file (Lotus 123 is too old)

To import data into a notes client:

it is possible to import from Lotus 123, but not from Excel or OpenOffice

(my solution or workaround  is to use an old Excel 2003, which can save as WK4 (Lotus 123))

  • Attach files
      Drop here to upload
    • Guest
      Reply
      |
      Sep 14, 2021


      3 years ago I added this thread? Will there be a solution?

      Like Theo I used the 123-importer very often, and I think more than 115 votes show that a lot of people are missing this feature.

    • Guest
      Reply
      |
      Aug 12, 2021

      Agreed with Theo!

      Import/Export from/to Excel means ability to export a set of documents from a view to Excel speadsheet file of specified format. and then to import it into another DB with fields set as headers and each Excel row to convert into separate docs in goal DB

      Ivan Kuzmenkov, Ambassador 2021 class

    • Guest
      Reply
      |
      Aug 12, 2021

      This only imports Excel data into a Rich Text.

      It does not import from a view, where records from Excel are transformed into Notes documents. The ‘old’ 123 importer did this, and I used it a lot.


      Please add this capability too, as I’m sure this is what the requestor wanted.


      And change the status, if set to ‘implemented’


      Theo

    • Admin
      Thomas Hampel
      Reply
      |
      Aug 12, 2021

      Import from XLS is available in Notes 12.0

    • Guest
      Reply
      |
      Feb 27, 2020

      If this is implemented then please consider this idea as wel https://domino-ideas.hcltechsw.com/ideas/NTS-I-209

    • Guest
      Reply
      |
      Oct 25, 2018

      I have installed Notes V10 Client, but the import / export options are the same as in 9, no xls files. Where is the option?

    • Guest
      Reply
      |
      Aug 2, 2018

      .xls support is available in V10 Beta

    • Guest
      Reply
      |
      Jul 24, 2018

      .xlsx and .odf should be considered as well.

    • Guest
      Reply
      |
      Jul 24, 2018

      Thanks for your proposal!

      I have a lot of import utilities, too.

      I have written them in JavaScript, and Java, and from command line via Ruby and OLE.

      All is working, but  nothing on earth could replace a fast and interactive import with the Notes Client.

    • Guest
      Reply
      |
      Jul 24, 2018

      It would be nice to have a configurable import-from-Excel function. In the meantime you can use this approach: http://www.botstation.com/code/excel_people_to_notes.php