Forum Discussion
How to import a KML Google Earth File to Excel and have it map individual locations to proper cells
Hello, I am probably looking for help doing something that will wind up complicated and truly be easier to just copy/paste the URL addresess for each geo location into the proper cell in Excel bu...
KLM is just XML file with lot of information but a direct link on the place. It could be parsed by Power Query, we may extract longitude and latitude from it, keep them in some helper table, after that generate links by formulae. Not easy way.
Easier to copy/paste URL.
One more way is to generate the link from the address, but you don't have separate cell with address only, lot of other information is in the same cell. For the address only links like
https://earth.google.com/web/search/1300+Macdade+Boulevard+Folsom+Pennsylvania
https://earth.google.com/web/search/401+east+1st+street+Sanford+Florida
https://earth.google.com/web/search/55+Broadway+New+York+NY+10006
etc
most probably could be generated by formulae.
They shall give the same as if we use the link with coordinates
