30

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.

15

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

  • 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 '18 at 12:14
  • Having same issue here as vak, it actually tries to search for the URL, not import it – Maksim Luzik Sep 24 '18 at 14:36
  • 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 '18 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 '18 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.

5

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

  • 5
    link is already dead. – Jakuje Oct 21 '16 at 14:53
4

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/

2

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.

  • Hi @sonu, welcome to Web Applications! I cleared your post up a bit, hopefully making it a bit easier to read. – Vidar S. Ramdal Feb 6 '17 at 11:42
  • Note: Since the asker already has a CSV file, Excel is not needed :-) – nic Feb 4 at 4:44
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/

-1

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

  • Always include essential part of the link into answer. – serenesat Jan 26 '16 at 12:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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