How do i import stack of Excel/CSV sheets to Elasticsearch?

Elastic Stack Elasticsearch
1

Im new to elasticsearch and i have 100's of excel/csv sheets that need to be imported to elasticsearch.
All of these files has a Primary column name as "Mobile Number" and other different attributes.

  1. I need to import all of these files to Elastisearch
  2. after import i need to setup a searchh term including data of multiple files

i have already setup elasticsearch , logstash & Kibana in my Macbook and still couldn't find a way to import multiple files.

2

Are they all the same format (columns)?

3

not in same format, different files has different number of columns BUT 1st column is same (Mobile number)