# Importing CSV into Kibana and mapping geo\_point **URL:** \ **Category:** Kibana\ **Created:** [December 6, 2019, 9:00am UTC](https://discuss.elastic.co/t/importing-csv-into-kibana-and-mapping-geo-point/210848 "2019-12-06T09:00:16Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![davidmgm-ES](https://avatars.discourse-cdn.com/v4/letter/d/a8b319/32.png) [@davidmgm-ES](https://discuss.elastic.co/u/davidmgm-ES)\ **Post date:** [December 6, 2019, 9:00am UTC](https://discuss.elastic.co/t/importing-csv-into-kibana-and-mapping-geo-point/210848/1 "2019-12-06T09:00:16Z")
Hello ES Community. I'm fairly new to ES/Kibana 7.5. I have the following CSV file with 3 columns.; first\_seen, last\_seen and geom. [Dropbox link to the CSV file](https://www.dropbox.com/s/1mwkvvdw3c3mol0/test.csv) Type of the first two columns are `date` and type of the third column, "geom" is `geo_point` with valid POINT (lon lat) format according to the [ES document](https://www.elastic.co/guide/en/elasticsearch/reference/current/geo-point.html). ![CSV](https://us1.discourse-cdn.com/elastic/original/3X/7/e/7ea3444d2def46bf35a2514ba4cfbbc0fb5e603d.png) Issue is, when I import this test.csv file into the Kibana, in Advanced tab, in the mapping section, Kibana recognizes the "geom" column as `keyword`. Then I re-write/change the type to `geo_point` as shown below: ![Mappings](https://us1.discourse-cdn.com/elastic/original/3X/d/7/d71e45e1b7cf0f3026b7620f2bdabf5487710f8c.png) But upon import I get the following error and end up with empty fields: 0: failed to parse field [geom] of type [geo\_point] How can I get ES/Kibana to recognize/map "geom" column as `geo_point`? Thank you in advanced ---
**Author:** ![alisongoryachev](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alisongoryachev/32/111352_2.png) [@alisongoryachev](https://discuss.elastic.co/u/alisongoryachev)\ **Post date:** [December 19, 2019, 5:23pm UTC](https://discuss.elastic.co/t/importing-csv-into-kibana-and-mapping-geo-point/210848/2 "2019-12-19T17:23:02Z")
Welcome @davidmgm-ES! Just a guess, but have you tried putting the `geo_point` field in quotation marks? I also see that there was an issue with the `geo_point` field that was fixed `7.3.1`. See: [https://github.com/elastic/kibana/issues/46675](https://github.com/elastic/kibana/issues/46675). However, from your comment it looks like you're on `7.5` ---
**Author:** ![davidmgm-ES](https://avatars.discourse-cdn.com/v4/letter/d/a8b319/32.png) [@davidmgm-ES](https://discuss.elastic.co/u/davidmgm-ES)\ **Post date:** [December 19, 2019, 7:02pm UTC](https://discuss.elastic.co/t/importing-csv-into-kibana-and-mapping-geo-point/210848/3 "2019-12-19T19:02:33Z")
Hi Alison, Thank you for replying, I have figured out the solution to my own problem. Problem was that the coordinates were in SRID EPSG:25832. I used the `ST_Transform(geom, 4326)` command in PostGIS DB to transform to EPSG:4326 And exported the table as a csv and was able to correctly map the geom columns as `geo_point` with ES/Kibana 7.5. ---
**Author:** ![alisongoryachev](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alisongoryachev/32/111352_2.png) [@alisongoryachev](https://discuss.elastic.co/u/alisongoryachev)\ **Post date:** [December 19, 2019, 7:04pm UTC](https://discuss.elastic.co/t/importing-csv-into-kibana-and-mapping-geo-point/210848/4 "2019-12-19T19:04:12Z")
Great! Glad you were able to figure it out. Thanks for sharing the solution. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [January 16, 2020, 7:04pm UTC](https://discuss.elastic.co/t/importing-csv-into-kibana-and-mapping-geo-point/210848/5 "2020-01-16T19:04:21Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.