Converting street addresses to lat-lon coordinates using Google Earth

  1. First step, you'll need the Desktop version of Google Earth Pro app. Go to this link and click "Download Earth Pro on desktop". Download and install it.

    google1

    google2

  2. If your table is in XLSX format, you need to save it as CSV first.

  3. Open Google Earth Pro and select File / Import. Select your CSV file.

  4. On the first screen, the defaults are usually OK. If not, adjust until the columns are nicely separated. Click Next.

  5. On the next screen, select "This dataset does not contain lat/lon information...". Click Next.

    import

  6. On the next screen, choose which option describes your address format better.

    import2

  7. On the last screen, you can keep the defaults and click Finish.

  8. If there is any mistake, it'll ask you to fix the results.

  9. When asked about style template, click No:

style
  1. Right click on the csv file in Temporary Places and select Save Place As. You can use the default KMZ option.
save_place_as

  1. Go to MapHub and import the KMZ file into a map.

  2. The addresses will now display correctly, with coordinates.

    map

Congratulations for converting your addresses to coordinates.