# Read excel file and search in elastic search

**URL:** <https://discuss.elastic.co/t/read-excel-file-and-search-in-elastic-search/127061>\
**Category:** Elasticsearch\
**Created:** [April 6, 2018, 9:44am UTC](https://discuss.elastic.co/t/read-excel-file-and-search-in-elastic-search/127061 "2018-04-06T09:44:09Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![famo](https://avatars.discourse-cdn.com/v4/letter/f/a698b9/32.png) [@famo](https://discuss.elastic.co/u/famo)\
**Post date:** [April 6, 2018, 9:44am UTC](https://discuss.elastic.co/t/read-excel-file-and-search-in-elastic-search/127061/1 "2018-04-06T09:44:09Z")

</div>

Hi  
I have a 20 millions rows student document in elastic search and I have excel file with 7000 rows that have students mobile number and I want to find all these students national No and students code in elastic search. I don't know how to read and search from a file.  
Thanks a lot for any help

---

<div class="post-metadata">

**Author:** ![jpountz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jpountz/32/45836_2.png) [@jpountz](https://discuss.elastic.co/u/jpountz)\
**Post date:** [April 6, 2018, 9:49am UTC](https://discuss.elastic.co/t/read-excel-file-and-search-in-elastic-search/127061/2 "2018-04-06T09:49:20Z")

</div>

You will need an external process that reads your excel spreadsheet and updates your Elasticsearch documents accordingly. You will probably have to write it yourself, I don't know of a tool that could do this automatically.

---

<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:** [May 4, 2018, 9:49am UTC](https://discuss.elastic.co/t/read-excel-file-and-search-in-elastic-search/127061/3 "2018-05-04T09:49:29Z")

</div>

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