I have excel file with 1 column of address , city and country.
I want to "import" it into Google Earth and get placemarks of the addresses (2800 POI).
How can I do it ?
[GIS] How to show excel file with addresses inside in Google Earth
excelgoogle earthimport
Related Solutions
The GEOCONTEXT-PROFILER will create an elevation profile just like Google Earth and you can import a KML and export a CSV. It should give you the same results as Google Earth.
This is the license restriction page that the tool links to.
You can often make a WKT (Well Known Text) column in Excel without too much fiddling, which effectively creates a spatial definition for points, lines or polygons within a single field.
What you want to do is create a WKT string, in the format:
POLYGON((X1 Y1, X2 Y2, X3 Y3, X4 Y4, X1 Y1))
You can create new columns in Excel with the below formulas. The first ('clean') substitutes the commas for spaces, then the semicolons for commas; the second ('wkt') creates a WKT string (concatenating text with &) - the only tricky part is finding and repeating the first coordinate pair to close the polygon:
clean:
=SUBSTITUTE(SUBSTITUTE(B2, ",", " "), ";", ",")wkt:
="POLYGON(("&C2&","&MID(C2,1, FIND(", ",C2)-1)&"))"
This can be saved as CSV, and the WKT field selected for import.
Best Answer
You can load your Excel file into a Google Fusion Table, Geocode, then use the share option to create the KML.
https://support.google.com/fusiontables/answer/2562055?hl=en&topic=2573107&ctx=topic