# Can I Ingest Excel (.xlsx) Files Of Multiple Sheets Into Elasticsearch?

**URL:** <https://discuss.elastic.co/t/can-i-ingest-excel-xlsx-files-of-multiple-sheets-into-elasticsearch/347427>\
**Category:** Elasticsearch\
**Created:** [November 17, 2023, 6:33pm UTC](https://discuss.elastic.co/t/can-i-ingest-excel-xlsx-files-of-multiple-sheets-into-elasticsearch/347427 "2023-11-17T18:33:16Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ethan777100](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ethan777100/32/70366_2.png) [@Ethan777100](https://discuss.elastic.co/u/Ethan777100)\
**Post date:** [November 17, 2023, 6:33pm UTC](https://discuss.elastic.co/t/can-i-ingest-excel-xlsx-files-of-multiple-sheets-into-elasticsearch/347427/1 "2023-11-17T18:33:16Z")

</div>

I have a year's worth of Excel .xlsx files that are basically tabular reports manually updated by people.

1 file = 1 day worth of Occurrence Reports.

The data in here is not in typical csv format.

But its manually populated in tables that look like this. The table cells are offset from A1:1.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/3/4/3403e68c77324eb8d57cb1c13d9e0e91ce0fb465.png)

I have quite a few sheets within each day's .xlsx Files.

This kind of files can I ingest them into Elasticsearch for indexing? Am I forced to ingest into 1 index or can I seperate indexes?

I want the ingesting in such a way that I can still retain daily distinction of events across every sheet per .xlsx file. When I filter inside Kibana, i should be able to filter properly by Day.

Any help / suggestions on what I need to do?

---

<div class="post-metadata">

**Author:** ![Priscilla\_Parodi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/priscilla_parodi/32/43047_2.png) [@Priscilla\_Parodi](https://discuss.elastic.co/u/Priscilla_Parodi)\
**Post date:** [November 17, 2023, 11:37pm UTC](https://discuss.elastic.co/t/can-i-ingest-excel-xlsx-files-of-multiple-sheets-into-elasticsearch/347427/2 "2023-11-17T23:37:39Z")

</div>

Hello @Ethan777100,

It is better to export the file to a delimited CSV file, because then you can import this into Elasticsearch using the Integrations \> [Upload a file](https://www.elastic.co/guide/en/kibana/current/connect-to-elasticsearch.html#upload-data-kibana) tool.

If you intend to keep editing the file, you'll have to create a new index each time. In this case, you can use [Logstash](https://www.elastic.co/guide/en/logstash/current/plugins-filters-csv.html) or a custom script using to append the data from the file into an existing index.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [December 15, 2023, 11:37pm UTC](https://discuss.elastic.co/t/can-i-ingest-excel-xlsx-files-of-multiple-sheets-into-elasticsearch/347427/3 "2023-12-15T23:37:41Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
