XLSX Import

Import Excel (xlsx) and CSV files into Energylogserver indices.

The XLSX Import module allow to import your xlsx and csv file to indices.

Importing steps

  1. Go to XLSX Import module and select your file and sheet:

  2. After the data has been successfully loaded, you will see a preview of your data at the bottom of the window.

  3. Press Next button.

  4. In the next step, enter the index name in the Index name field, you can also change the pattern for the document ID and select the columns that the import will skip.

  5. Select the Configure your own mapping for every field. You can choose the type and apply more options with the advanced JSON.

  6. After the import configuration is complete, select the Import button to start the import process.

  7. After the import process is completed, a summary will be displayed. Now you can create a new index pattern to view your data in the Discovery module.