Excell to Elasticsearch with Python

Hi everyone; With this article we will convert excell file to csv file using python. After convert operation We will transfer data from csv to elasticsearch using python. By the way, Elasticsearch has security configuration. That is why we have to get “http_ca.crt” file from server elasticsearch is allready installed.

Just install this prerequest packages using pip.

pip install elasticsearch
pip install pandas 

Here is the Python code.