Parses XLSX files into ElasticSearch using column titles from specified row combined with data in columns on each row. For use with Kibana or other visualization applications, example result using a transaction log in excel format image. The application comes with a web interface to simplify uploading.

The application requires ElasticSearch as its output.

1. ElasticSearch (version 5+) should not require any additional configuration or installation, just download and run from Elastic.

2. Download the latest release of excelastic-1.2.0.jar and the configuration.json (optional) file from GitHub releases.

Running the application, filename and index is optional to import using terminal mode.

java -jar excelastic-1.2.0.jar <filename> <index>

When the application successfully connects to the ElasticSearch server, the browser will automatically open a new tab.

If any connection errors occur check that the ElasticSearch listen port matches with the elastic_port in the configuration file. Make sure that ElasticSearch is running by directing your browser at localhost:9200.

Compiling a new fatjar and run tests,

mvn clean package

├── configuration.json

web_port (8080) port that the webserver will listen on.

elastic_port (9200) port that ElasticSearch listens to, host is set to localhost.

elastic_host (localhost) address of the ElasticSearch server.

If no configuration file is present a new configuration file will be created using the default values listed here.