Skip to Main Content
Spotfire Ideas Portal

Import data from multiple excel sheets at once into a single datatable

When an excel file with multiple files have to be imported, it will always allow to choose one sheet at a time to create a data table. Whereas what he / customer is looking for is to merge all the data from different sheets into one data table when importing into Spotfire.

  • Attach files
      Drop here to upload
    • Guest
      Reply
      |
      Nov 5, 2018

      I have many instances where I keep the data for a specific dashboard in one Excel workbook as multiple sheets.  Being able to import multiple sheets as multiple tables would be definitely streamline the process.

    • Guest
      Reply
      |
      Nov 3, 2018

      Would also like to import multiple sheets as multiple tables in one import procedure (without having to relocate the file and re-select sheets for each sheet import)

      I think since Spotfire X automatically recognizes similar columns for "add rows", if you were able to do the above then the merging process might possibly handle itself (?)