# Can not upload csv with coordinates to kibana

**URL:** <https://discuss.elastic.co/t/can-not-upload-csv-with-coordinates-to-kibana/252629>\
**Category:** Kibana\
**Created:** [October 20, 2020, 5:19am UTC](https://discuss.elastic.co/t/can-not-upload-csv-with-coordinates-to-kibana/252629 "2020-10-20T05:19:55Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![4T14S](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/4t14s/32/63108_2.png) [@4T14S](https://discuss.elastic.co/u/4T14S)\
**Post date:** [October 20, 2020, 5:19am UTC](https://discuss.elastic.co/t/can-not-upload-csv-with-coordinates-to-kibana/252629/1 "2020-10-20T05:19:55Z")

</div>

Greetings!

Hope you are well, I am trying to add this csv data to Elastic but throws error on every single line I try to add. I am loading it from ML / DataVisualizer, I have read documentation but I can´t see where is the error.

Error on every line:  
`0: failed to parse field [latitude] of type [geo_point]`

MOCK DATA CSV file:

```auto
5/10/2016,1,Kaiser,Davidovics,kdavidovics0@yahoo.com,Male,013XX S SAWYER AVE,BATTERY,DOMESTIC BATTERY SIMPLE,APARTMENT,TRUE,TRUE,A,5,59.6313435,39.72516
5/10/2016,2,Shauna,Coultas,scoultas1@seattletimes.com,Female,061XX S DREXEL AVE,BATTERY,DOMESTIC BATTERY SIMPLE,RESIDENCE,FALSE,TRUE,A,,-15.3612378,-70.3628516
5/10/2016,3,Rebeka,Bigg,rbigg2@issuu.com,Female,053XX W CHICAGO AVE,PUBLIC PEACE VIOLATION,RECKLESS CONDUCT,STREET,FALSE,FALSE,A,,37.9854094,23.7419512
5/10/2016,4,Kalila,Wolfendell,kwolfendell3@ucla.edu,Female,049XX W FULTON ST,BATTERY,SIMPLE,SIDEWALK,FALSE,FALSE,A,,47.1792078,9.5678116

```

Mapping:

```auto
{
  "Arrest": {
    "type": "keyword"
  },
  "Block": {
    "type": "text"
  },
  "Date": {
    "type": "keyword"
  },
  "Description": {
    "type": "text"
  },
  "Detention Time": {
    "type": "long"
  },
  "Domestic": {
    "type": "keyword"
  },
  "Group": {
    "type": "keyword"
  },
  "Location Description": {
    "type": "keyword"
  },
  "Primary Type": {
    "type": "keyword"
  },
  "email": {
    "type": "keyword"
  },
  "first_name": {
    "type": "keyword"
  },
  "gender": {
    "type": "keyword"
  },
  "id": {
    "type": "long"
  },
  "last_name": {
    "type": "keyword"
  },
  "latitude": {
    "type": "geo_point"
  },
  "longitude": {
    "type": "geo_point"
  }
}

```

I will appreciate any help you can give me!

Thanks in advance!

---

<div class="post-metadata">

**Author:** ![ylasri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ylasri/32/86120_2.png) [@ylasri](https://discuss.elastic.co/u/ylasri)\
**Post date:** [October 20, 2020, 1:01pm UTC](https://discuss.elastic.co/t/can-not-upload-csv-with-coordinates-to-kibana/252629/2 "2020-10-20T13:01:02Z")

</div>

Check the [geo\_point](https://www.elastic.co/guide/en/elasticsearch/reference/current/geo-point.html) type here  
You should merge latitude & longitude  
For example your CSV can be like this

```
5/10/2016|1|Kaiser|Davidovics|kdavidovics0@yahoo.com|Male|013XX S SAWYER AVE|BATTERY|DOMESTIC BATTERY SIMPLE|APARTMENT|TRUE|TRUE|A|5|59.6313435,39.72516
5/10/2016|2|Shauna|Coultas|scoultas1@seattletimes.com|Female|061XX S DREXEL AVE|BATTERY|DOMESTIC BATTERY SIMPLE|RESIDENCE|FALSE|TRUE|A||-15.3612378,-70.3628516
5/10/2016|3|Rebeka|Bigg|rbigg2@issuu.com|Female|053XX W CHICAGO AVE|PUBLIC PEACE VIOLATION|RECKLESS CONDUCT|STREET|FALSE|FALSE|A||37.9854094,23.7419512
5/10/2016|4|Kalila|Wolfendell|kwolfendell3@ucla.edu|Female|049XX W FULTON ST|BATTERY|SIMPLE|SIDEWALK|FALSE|FALSE|A||47.1792078,9.5678116

```

Or use an ingest processor to define your geo\_point

```
{
   "set":{
      "field":"position",
      "value":"{{latitude}},{{longitude}}"
   }
}
```

---

<div class="post-metadata">

**Author:** ![4T14S](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/4t14s/32/63108_2.png) [@4T14S](https://discuss.elastic.co/u/4T14S)\
**Post date:** [October 21, 2020, 2:39am UTC](https://discuss.elastic.co/t/can-not-upload-csv-with-coordinates-to-kibana/252629/3 "2020-10-21T02:39:25Z")

</div>

Thank you! 😃

---

<div class="post-metadata">

**Author:** ![thomasneirynck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/thomasneirynck/32/23313_2.png) [@thomasneirynck](https://discuss.elastic.co/u/thomasneirynck)\
**Post date:** [October 22, 2020, 3:24pm UTC](https://discuss.elastic.co/t/can-not-upload-csv-with-coordinates-to-kibana/252629/4 "2020-10-22T15:24:57Z")

</div>

thx @4T14S @ylasri

Short FYI related to this:

Uploading .csv with points will be supported automatically (without requiring manual config) when 7.10 version of the stack will be released. [https://github.com/elastic/kibana/issues/76996](https://github.com/elastic/kibana/issues/76996)

---

<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:** [November 19, 2020, 3:24pm UTC](https://discuss.elastic.co/t/can-not-upload-csv-with-coordinates-to-kibana/252629/5 "2020-11-19T15:24:58Z")

</div>

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