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

135 VOTE
Status Assessment
Workspace Notes
Created by Guest
Created on Jul 23, 2018

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
  • 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