# Loading data from .csv file to elasticsearch using logstash on localhost

**URL:** <https://discuss.elastic.co/t/loading-data-from-csv-file-to-elasticsearch-using-logstash-on-localhost/164903>\
**Category:** Elasticsearch\
**Created:** [January 19, 2019, 3:51pm UTC](https://discuss.elastic.co/t/loading-data-from-csv-file-to-elasticsearch-using-logstash-on-localhost/164903 "2019-01-19T15:51:31Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hetal\_Parmar](https://avatars.discourse-cdn.com/v4/letter/h/f08c70/32.png) [@Hetal\_Parmar](https://discuss.elastic.co/u/Hetal_Parmar)\
**Post date:** [January 19, 2019, 3:51pm UTC](https://discuss.elastic.co/t/loading-data-from-csv-file-to-elasticsearch-using-logstash-on-localhost/164903/1 "2019-01-19T15:51:31Z")

</div>

hi  
i m new to elastic. so i m trying to upload data from .csv file to elasticsearch using logstash on my local desktop (windows10)  
the problem is only 10 data from excel is uploading on elasticsearch.  
no error in logstash logs , no errors in elasticsearch logs  
so what may be the issue ?

---

<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:** [January 19, 2019, 5:53pm UTC](https://discuss.elastic.co/t/loading-data-from-csv-file-to-elasticsearch-using-logstash-on-localhost/164903/2 "2019-01-19T17:53:47Z")

</div>

Are you sure that only 10 records are loaded?

What is the output of

```
GET /your_index/_search?size=0
```

---

<div class="post-metadata">

**Author:** ![Hetal\_Parmar](https://avatars.discourse-cdn.com/v4/letter/h/f08c70/32.png) [@Hetal\_Parmar](https://discuss.elastic.co/u/Hetal_Parmar)\
**Post date:** [January 20, 2019, 10:09am UTC](https://discuss.elastic.co/t/loading-data-from-csv-file-to-elasticsearch-using-logstash-on-localhost/164903/3 "2019-01-20T10:09:18Z")

</div>

> [@dadoonet](#):
>
> GET /your\_index/\_search?size=0

output is  
{  
"took": 520,  
"timed\_out": false,  
"\_shards": {  
"total": 5,  
"successful": 5,  
"skipped": 0,  
"failed": 0  
},  
"hits": {  
"total": 408,  
"max\_score": 0,  
"hits":   
}  
}

but when i query below in kibana and i varify data only10 data it shows  
GET /your\_index/\_search  
{  
"query": { "match\_all": {} }

}  
output is  
{  
"took" : 9,  
"timed\_out" : false,  
"\_shards" : {  
"total" : 5,  
"successful" : 5,  
"skipped" : 0,  
"failed" : 0  
},  
"hits" : {  
"total" : 408,  
"max\_score" : 1.0,  
"hits" : [  
{  
"\_index" : "your\_index",  
"\_type" : "your\_indextype",  
"\_id" : "S2q4ZmgB7K7vpgwX9wV3",  
"\_score" : 1.0,  
"\_source" : {  
(\*\*\*here it shows only 10 \_source data \*\*\*)  
}  
}  
]  
}

---

<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:** [January 20, 2019, 11:00am UTC](https://discuss.elastic.co/t/loading-data-from-csv-file-to-elasticsearch-using-logstash-on-localhost/164903/4 "2019-01-20T11:00:17Z")

</div>

Page size is 10 by default. Use from and size parameters. See [https://www.elastic.co/guide/en/elasticsearch/reference/6.5/search-request-from-size.html](https://www.elastic.co/guide/en/elasticsearch/reference/6.5/search-request-from-size.html)

---

<div class="post-metadata">

**Author:** ![Hetal\_Parmar](https://avatars.discourse-cdn.com/v4/letter/h/f08c70/32.png) [@Hetal\_Parmar](https://discuss.elastic.co/u/Hetal_Parmar)\
**Post date:** [January 20, 2019, 1:41pm UTC](https://discuss.elastic.co/t/loading-data-from-csv-file-to-elasticsearch-using-logstash-on-localhost/164903/5 "2019-01-20T13:41:02Z")

</div>

thanks for your reply . i can see all data now .

---

<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:** [February 17, 2019, 1:41pm UTC](https://discuss.elastic.co/t/loading-data-from-csv-file-to-elasticsearch-using-logstash-on-localhost/164903/6 "2019-02-17T13:41:02Z")

</div>

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