Here’s how you do it in five easy steps:
1. Have your coordinates ready, in a text file, Excel, csv file, on paper etc.
2. Download a csv/text/Excel to KML converter. I used this one by simon_a and it worked like a charm. It is all in Excel so you don’t need to install anything. Check the three tabs in the file, you need to:
a) On Tab 1, enter your longitude and latitude coordinates (copy and paste or use import data from your existing coordinates file) In the example coordinates are on a format with comma (,) I needed to change these to use dot (.) to make the import to Google Maps work. (just do search and replace, ctrl+h)
b) Set the output file name on tab 2
c) Make sure Excel security settings allow you to run the macro. Press Alt+F8 to run the Generate KML macro. It does not tell you when it’s ready but it runs real quick.
3. Go to Google Maps – http://maps.google.com Make sure you sign in so you can save your new map.
4. Create a new map and select Import to import your .kml file
View Fordonsgas, Biogas tankställen (CNG in Sweden) in a larger map
I have a biogas (CNG) car and it’s always a hassle to find a place to fill it up. There is a public site that let’s you download coordinates for your GPS but they don’t provide anything but that .csv file and a pdf to print. Now I finally have it imported into so I can access from my cellphone with Google Maps and GPS. Wish I would have done this a couple of years ago…