# Add csv data to elastic search

**URL:** <https://discuss.elastic.co/t/add-csv-data-to-elastic-search/59657>\
**Category:** Elasticsearch\
**Created:** [September 2, 2016, 11:26am UTC](https://discuss.elastic.co/t/add-csv-data-to-elastic-search/59657 "2016-09-02T11:26:24Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![nvn.manikandaprabhu](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nvn.manikandaprabhu/32/11750_2.png) [@nvn.manikandaprabhu](https://discuss.elastic.co/u/nvn.manikandaprabhu)\
**Post date:** [September 2, 2016, 11:26am UTC](https://discuss.elastic.co/t/add-csv-data-to-elastic-search/59657/1 "2016-09-02T11:26:24Z")

</div>

Hi All,

I have set of data's which is in .csv format, I'm trying to push all the data into elastic search and based on the data i'll we be creating dashboard Kibana.

Is there any way to do that?

Thanks,  
Mani.

---

<div class="post-metadata">

**Author:** ![ketzler](https://avatars.discourse-cdn.com/v4/letter/k/71e660/32.png) [@ketzler](https://discuss.elastic.co/u/ketzler)\
**Post date:** [September 2, 2016, 6:02pm UTC](https://discuss.elastic.co/t/add-csv-data-to-elastic-search/59657/2 "2016-09-02T18:02:47Z")

</div>

Hey,

I had the same issue. We installed Logstash and executed it with a file like this:

```
input
{
  file {
  path => "/PathToFile/xy.csv"
  type => "core2"
  start_position => "beginning"
  }
}
filter {
  csv {
  columns => ["column1", "..."]
  separator => ";"
  }
}
output {
  elasticsearch
{
  action => "index"
  host => "localhost"
  index => "logstash-%{+YYYY.MM.dd}"
  workers => 1
  }
#optional, writes the input in the terminal
  stdout {
  codec => rubydebug
  }
}

```

The file must end on .conf and placed in the logstash-directory.  
You can execute your file from the terminal (logstash-directory) with

/bin/logstash -f xy.conf

I hope this will help you.

Regards

---

<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:22pm UTC](https://discuss.elastic.co/t/add-csv-data-to-elastic-search/59657/3 "2017-07-05T22:22:45Z")

</div>


