35

I've got a list of hundreds of lat/long coordinates and I want to plot them on Google Maps. What is the easiest way to do this? The data is currently in CSV format.

1

10 Answers 10

16

I think the easiest way to do this is to create a KML file with all your lat/long coordinates and open them using Google Earth or Google Maps (http://maps.google.com/maps?q= "YOUR KML FILE URL HERE")

Some info on creating a valid KML file: http://code.google.com/apis/kml/faq.html#howtocreate

and here you can find an Excel to KML converter:

http://freegeographytools.com/2007/another-excel-to-kml-converter

4
  • 1
    "YOUR KML FILE URL" doesn't seem to work at least not with https URL. I tried with this maps.google.com/maps?q=https://raw.githubusercontent.com/google/…
    – vak
    May 17, 2018 at 12:14
  • Having same issue here as vak, it actually tries to search for the URL, not import it Sep 24, 2018 at 14:36
  • 2
    It has been a while since I answered this, I think you should take a look at GeoJSON, it is the new standard and it is easy to use or import with lots of map providers (you don't have to use Google with their new expensive price if you don't want to). Here is an example: developers.google.com/maps/documentation/javascript/examples/…
    – Fortes
    Sep 24, 2018 at 17:39
  • You should also check out geojson.io there you have a way to import, export and convert different formats including KML and GeoJSON
    – Fortes
    Sep 24, 2018 at 22:13
9

This is a 10 second solution to put the points on Google Map - you will need either excel or CSV data which you just copy/paste here: http://www.hamstermap.com and then choose Quick Map.

There is also a more complicated map on the website with fancy markers but you will probably need just the quick map.

2
  • 1
    unfortunately google maps have stopped supporting the free api version so you can't view the map property anymore
    – atreeon
    Apr 25, 2020 at 8:25
  • It would appear that hamster map is defunct now.
    – dir
    Aug 16, 2021 at 17:22
8

One of the simplest way is to copy your coordinates in Excel file.

  1. Go to My Google Maps.
  2. Find/create the map you want the points to appear on.
  3. In Excel, export your file as CSV
  4. Upload/import the CSV file in My Google Maps.

It will plot all of your points on the map.

4
  • Hi @sonu, welcome to Web Applications! I cleared your post up a bit, hopefully making it a bit easier to read. Feb 6, 2017 at 11:42
  • 1
    Note: Since the asker already has a CSV file, Excel is not needed :-)
    – nic
    Feb 4, 2019 at 4:44
  • This worked for me
    – atreeon
    Apr 25, 2020 at 8:29
  • Worth pointing out google maps upload allows 2k rows at a time - so if you have a large data set you'll need to break it up into 2k-large layers and upload each one at a time. May 24, 2021 at 13:12
4

Create a map from a published Google Spreadsheet. The sample spreadsheet has lat/long columns.

1
  • 8
    link is already dead.
    – Jakuje
    Oct 21, 2016 at 14:53
3

This web tool can do it. It takes a list of comma separated latitude and longitude pairs and puts them on Google Maps. http://www.darrinward.com/lat-long/

1

There are lots of ways to visualize geographic data out there, but for what you're looking to do, give this geographic heatmapping tool a try. Since you've got 100's of data points, a heat map may be better suited to visualizing your data since a bunch of cluttered pins may be hard to read You just need to copy and paste your CSV contents into the textbox, and the service is free. It also supports geocoding smaller datasets if you don't know the coordinates of your locations.

1

https://www.easymapmaker.com/ enables copy-pasting data directly from excel, AND to include columns other than lat-long and render those to the marker title, label etc so that we can make sense out of what we've plotted.

0

You can use GPS point plotter. Simply copy-paste the lat long list and you will have a map. https://gpspointplotter.com/

0

https://www.easymapmaker.com/ enables copy-pasting data directly from excel, AND to include columns other than lat-long and render those to the marker title, label etc so that we can make sense out of what we've plotted.

-1

Try zeemap. You can plot your data in csv and import them and then map each field into their pre-defined attributes.

1
  • Always include essential part of the link into answer.
    – serenesat
    Jan 26, 2016 at 12:41

Not the answer you're looking for? Browse other questions tagged or ask your own question.