# How to import csv files into Elasticsearch

**URL:** https://discuss.elastic.co/t/how-to-import-csv-files-into-elasticsearch/46365
**Category:** Elasticsearch
**Created:** [April 5, 2016, 9:53am UTC](https://discuss.elastic.co/t/how-to-import-csv-files-into-elasticsearch/46365 "2016-04-05T09:53:12Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![mros](https://avatars.discourse-cdn.com/v4/letter/m/a9adbd/32.png) [@mros](https://discuss.elastic.co/u/mros)
#### Post date: [April 5, 2016, 9:53am UTC](https://discuss.elastic.co/t/how-to-import-csv-files-into-elasticsearch/46365/1 "2016-04-05T09:53:12Z")

</div>

I have a csv file exported from a database and can not find correct information on how to do.

I want to upload the CSV file to Elasticsearch then display it in Kiwana.

I would appreciate help.

Regards,  
Marc

---

<div class="post-metadata">

### Author: ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [April 5, 2016, 10:01am UTC](https://discuss.elastic.co/t/how-to-import-csv-files-into-elasticsearch/46365/2 "2016-04-05T10:01:35Z")

</div>

Use Logstash with stdin/file input and the CSV filter 🙂

---

<div class="post-metadata">

### Author: ![mros](https://avatars.discourse-cdn.com/v4/letter/m/a9adbd/32.png) [@mros](https://discuss.elastic.co/u/mros)
#### Post date: [April 5, 2016, 10:29am UTC](https://discuss.elastic.co/t/how-to-import-csv-files-into-elasticsearch/46365/3 "2016-04-05T10:29:48Z")

</div>

Mark thanks for the quick reply.

I created a file .conf with data input, filter and output in /etc/logstash/conf.d and I do not how to apply this configuration.

I'm missing steps to continue.

Regards,  
Marc

---

<div class="post-metadata">

### Author: ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [April 5, 2016, 8:35pm UTC](https://discuss.elastic.co/t/how-to-import-csv-files-into-elasticsearch/46365/4 "2016-04-05T20:35:19Z")

</div>

Start Logstash manually and then pass the config file to it with the `-f` flag, `/path/to/bin/logstash -f /path/to/config/file/conf`.

---

<div class="post-metadata">

### Author: ![bubba198](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bubba198/32/15866_2.png) [@bubba198](https://discuss.elastic.co/u/bubba198)
#### Post date: [April 30, 2017, 6:19am UTC](https://discuss.elastic.co/t/how-to-import-csv-files-into-elasticsearch/46365/5 "2017-04-30T06:19:39Z")

</div>

I hear Kibana will have this feature in future releases? Anyone know how close we are to having it?

For the time being there are ton of python scripts and github tools, all of which broken or defective (maybe I can't figure it out lol) so a native Kibana GUI would be most helpful!

---

<div class="post-metadata">

### Author: ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [April 30, 2017, 9:01am UTC](https://discuss.elastic.co/t/how-to-import-csv-files-into-elasticsearch/46365/6 "2017-04-30T09:01:04Z")

</div>

There's an open issue for it here - [https://github.com/elastic/kibana/issues/9804](https://github.com/elastic/kibana/issues/9804)

Not sure if there is a target for it at this stage, but please feel free to add a +1 to the OP 🙂

---

<div class="post-metadata">

### Author: ![bubba198](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bubba198/32/15866_2.png) [@bubba198](https://discuss.elastic.co/u/bubba198)
#### Post date: [April 30, 2017, 2:55pm UTC](https://discuss.elastic.co/t/how-to-import-csv-files-into-elasticsearch/46365/7 "2017-04-30T14:55:54Z")

</div>

Thanks @warkolm -- definitely will do. Getting structured data in is of utmost importance for me. Thank you

---

<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: [July 5, 2017, 10:00pm UTC](https://discuss.elastic.co/t/how-to-import-csv-files-into-elasticsearch/46365/8 "2017-07-05T22:00:47Z")

</div>


