# Index xlsx files in Elasticsearch

**URL:** <https://discuss.elastic.co/t/index-xlsx-files-in-elasticsearch/140564>\
**Category:** Elasticsearch\
**Created:** [July 18, 2018, 1:15pm UTC](https://discuss.elastic.co/t/index-xlsx-files-in-elasticsearch/140564 "2018-07-18T13:15:39Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![alexander.tsulin](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@alexander.tsulin](https://discuss.elastic.co/u/alexander.tsulin)\
**Post date:** [July 18, 2018, 1:15pm UTC](https://discuss.elastic.co/t/index-xlsx-files-in-elasticsearch/140564/1 "2018-07-18T13:15:40Z")

</div>

Hi all,

I'm implementing utility that uses Elasticsearch database and should be able to index excel files with specified file sctructure.

For instance, I have file with 3 columns:  
UserId FirstName LastName  
1 Alex Smith  
2 John Johnson

I use ingest attachment plugin and examples in elasticsearch documentation and it works perfectly. In result I can find any excel file in elasticsearch by, for instance, 'Alex' or 'John' query.

But I don't undestand how to find files by specified columns. For instance, I want to find excel files, that contains 'Alex' in column FirstName, or contains 'Johnson' in column LastName.

Any ideas?

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [July 18, 2018, 9:18pm UTC](https://discuss.elastic.co/t/index-xlsx-files-in-elasticsearch/140564/2 "2018-07-18T21:18:27Z")

</div>

You can't with this plugin as it just extracts flat text.

You may be need to export to CSV then create a Logstash or an ingest pipeline to parse the CSV content...

---

<div class="post-metadata">

**Author:** ![zqc0512](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/zqc0512/32/32141_2.png) [@zqc0512](https://discuss.elastic.co/u/zqc0512)\
**Post date:** [July 19, 2018, 3:06am UTC](https://discuss.elastic.co/t/index-xlsx-files-in-elasticsearch/140564/3 "2018-07-19T03:06:41Z")

</div>

logstash csv input and filter

---

<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:** [August 16, 2018, 3:06am UTC](https://discuss.elastic.co/t/index-xlsx-files-in-elasticsearch/140564/4 "2018-08-16T03:06:46Z")

</div>

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