# How to import excel sheet in elastic search

**URL:** <https://discuss.elastic.co/t/how-to-import-excel-sheet-in-elastic-search/158942>\
**Category:** Elasticsearch\
**Created:** [November 30, 2018, 4:26pm UTC](https://discuss.elastic.co/t/how-to-import-excel-sheet-in-elastic-search/158942 "2018-11-30T16:26:17Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nethaji](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nethaji/32/72803_2.png) [@Nethaji](https://discuss.elastic.co/u/Nethaji)\
**Post date:** [November 30, 2018, 4:26pm UTC](https://discuss.elastic.co/t/how-to-import-excel-sheet-in-elastic-search/158942/1 "2018-11-30T16:26:17Z")

</div>

Hi,  
I struggled to import my excel in elastic search, provide solution to import into elasticsearch.

or else we can convert the excel file into csv then import this file in elasticsearch.

---

<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:** [November 30, 2018, 4:45pm UTC](https://discuss.elastic.co/t/how-to-import-excel-sheet-in-elastic-search/158942/2 "2018-11-30T16:45:50Z")

</div>

I shared some ideas here:

- [http://david.pilato.fr/blog/2017/01/09/4-years-at-elastic/](http://david.pilato.fr/blog/2017/01/09/4-years-at-elastic/)
- [http://david.pilato.fr/blog/2018/01/10/5-years-what-a-milestone/](http://david.pilato.fr/blog/2018/01/10/5-years-what-a-milestone/) (latest update)

Might help.

---

<div class="post-metadata">

**Author:** ![gbrown](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gbrown/32/34482_2.png) [@gbrown](https://discuss.elastic.co/u/gbrown)\
**Post date:** [November 30, 2018, 5:15pm UTC](https://discuss.elastic.co/t/how-to-import-excel-sheet-in-elastic-search/158942/3 "2018-11-30T17:15:04Z")

</div>

For importing CSV data into Elasticsearch, you may be able to use the new Data Visualizer (currently experimental, but [available in the default distribution with Elasticsearch and Kibana 6.5](https://www.elastic.co/blog/kibana-6-5-0-released), scroll down to "Visualize data from a log file") under the Machine Learning tab. This will let you drag and drop your CSV file, automatically generate an ingest pipeline and mapping, and import it.

---

<div class="post-metadata">

**Author:** ![Mischa\_Diehm](https://avatars.discourse-cdn.com/v4/letter/m/f6c823/32.png) [@Mischa\_Diehm](https://discuss.elastic.co/u/Mischa_Diehm)\
**Post date:** [November 30, 2018, 6:03pm UTC](https://discuss.elastic.co/t/how-to-import-excel-sheet-in-elastic-search/158942/4 "2018-11-30T18:03:30Z")

</div>

While I totally agree on the value of this new feature I must say after working with it for a couple of days there could be many ways to make this even more useful. I wonder where feature and bug discussions should be targeted. Is this a good place or rather go to github and discuss there?

Thanks for the great work,  
Mischa

---

<div class="post-metadata">

**Author:** ![gbrown](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gbrown/32/34482_2.png) [@gbrown](https://discuss.elastic.co/u/gbrown)\
**Post date:** [November 30, 2018, 6:10pm UTC](https://discuss.elastic.co/t/how-to-import-excel-sheet-in-elastic-search/158942/5 "2018-11-30T18:10:37Z")

</div>

Generally, questions about the how to use a product or feature should go here, but feedback about a product or feature should go into a GitHub issue, where it will be seen and addressed by the relevant development team.

We always welcome feedback, and especially for experimental features like the Data Visualizer, so I encourage you to [open an issue in the Kibana repo](https://github.com/elastic/kibana/issues/new) with any bugs or feature requests you have!

Edit to be clear: One bug or feature request per issue please. If you have more than one, create more than one issue!

---

<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 28, 2018, 6:20pm UTC](https://discuss.elastic.co/t/how-to-import-excel-sheet-in-elastic-search/158942/6 "2018-12-28T18:20:38Z")

</div>

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