# Import CSV file to Logstash on windows

**URL:** <https://discuss.elastic.co/t/import-csv-file-to-logstash-on-windows/74979>\
**Category:** Elasticsearch\
**Created:** [February 14, 2017, 7:33am UTC](https://discuss.elastic.co/t/import-csv-file-to-logstash-on-windows/74979 "2017-02-14T07:33:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Uma\_Ananthu](https://avatars.discourse-cdn.com/v4/letter/u/bbce88/32.png) [@Uma\_Ananthu](https://discuss.elastic.co/u/Uma_Ananthu)\
**Post date:** [February 14, 2017, 7:33am UTC](https://discuss.elastic.co/t/import-csv-file-to-logstash-on-windows/74979/1 "2017-02-14T07:33:48Z")

</div>

Hi,  
I am trying to import CSV file to Logstash and pass to elastic search. I am using the below config

input {  
file {  
path =\> ["D:/AnalyticsTool/Exe/logstash-5.2.0/logstash-5.2.0/bin/GWT\_new.CSV"]  
type =\> "core2"  
start\_position =\> "beginning"  
sincedb\_path =\> "/dev/null"  
}  
}  
filter {  
csv {  
separator =\> ","  
columns =\> ["Issue id", "Custom field (Requesting Market)","Summary","Priority", "Issue Type", "Status", "Created", "Custom field (Requested Completion Date)  
", "Time Spent"]  
}  
}

output {

elasticsearch { hosts =\> ["localhost:9200"]  
index =\> "NewIndex"  
user =\> elastic  
password =\> changeme  
}  
stdout { codec =\> rubydebug }  
}

CSV Sample Input:  
Issue id Custom field (Requesting Market) Summary Priority Issue Type Status Created Custom field (Requested Completion Date) Time Spent  
19000 Global Campaign Hub - Image size validation and display tiles without blank 5 Bug Closed 1/4/2016 7:06 2/28/2017 0:00 126900  
19005 Global Request Ongoing (MONTHLY) GWT K5 Transaction Extract 5 Task Open 1/4/2016 13:42 1/29/2016 0:00

In kibana , I am not able to create Index. Please let me know if i am missing any.

Thanks in Advance

---

<div class="post-metadata">

**Author:** ![anhlqn](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/anhlqn/32/5454_2.png) [@anhlqn](https://discuss.elastic.co/u/anhlqn)\
**Post date:** [February 14, 2017, 8:11am UTC](https://discuss.elastic.co/t/import-csv-file-to-logstash-on-windows/74979/2 "2017-02-14T08:11:03Z")

</div>

> [@Uma\_Ananthu](#):
>
> csv { separator =\> ","

The separator does not match your sample input. Is it space delimited?

> [@Uma\_Ananthu](#):
>
> In kibana , I am not able to create Index. Please let me know if i am missing any.

You mean you can't add index pattern in Kibana? If yes, did you see events successfully parsed in Logstash? If there is no index in Elasticsearch, you can't add index pattern in Kibana.

---

<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:** [March 14, 2017, 8:11am UTC](https://discuss.elastic.co/t/import-csv-file-to-logstash-on-windows/74979/3 "2017-03-14T08:11:50Z")

</div>

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