Search code examples
excelweb-servicesgoogle-mapsgpswaze

How can I add GPS data to an Excel with postal addresses


When I have an excel file that would include a postal address (street , postal code, city) departure and an arrival address, is there a web service or anything else directly to open its GPS or Google maps API kind .

Is this possible and where can I find information?


Solution

  • If you have Google Earth Pro (which is free now), you can import Excel file to GPS location. Save your Excel sheet as a CSV (or .txt, tab delimited). Then, in Google Earth, go to File --> Import, and choose your file. From there, follow the prompts.

    In the end, it should place the markers at your various locations on the globe.