Importing addresses

This feature is available to Google Earth Pro and Google Earth EC customers only.

This tutorial describes how you can import addresses into Google Earth Pro or EC. You will import addresses from a sample electronic file and view them in Google Earth Pro or EC. You can also import latitude and longitude data - learn more.

About Importing Addresses into Google Earth Pro and EC

When you import addresses into Google Earth, each address is converted to a placemark on the earth that is displayed in the 3D viewer and in the Places panel.

At this time, Google Earth can only ingest such information for addresses located within the United States, United Kingdom, Canada, France, Italy, Germany, and Spain. Google Earth cannot place any address that contains a P.O. box.

Your data file can use street-level addressing to position each point on the Earth's surface. Google Earth can ingest georeferenced and non-georeferenced information. At this time, Google Earth can only ingest such information for addresses located within the United States, United Kingdom, Canada, France, Italy, Germany, and Spain. Google Earth cannot place any address that contains a P.O. box.

The following types of address formatting are supported:

  • Single-address field - You can define the street, city, state, country, and zip code in a single field. For example, a single field with the column label of 'address' might have the following value:

    123 Easy Street, San Jose, CA, 95330 Multiple address fields - You can also define street, city, state, country, and zip code in multiple fields. In this case, a field with a column label of 'street' would have as its value:

    123 Easy Street

    In this scenario, additional fields would be defined for city, state, and zip code.
  • Partial address default values - Because some of your points might have only partial addresses, you can use the data import wizard to define default values for missing fields, such as state or zip code.

     

 

Importing Address Data from the Sample File into Google Earth Pro and EC

Try importing data from a sample CSV file. To do this:

  1. Download the sample file. Save this file to a location on your hard drive (for example C:\SampleData\samplefile.csv).
  2. In Google Earth, click File > Import.
  3. Browse to the location of the the sample file and select it. Click Open. The Data Import Wizard appears. Note that this wizard only appears when you import addresses.

    Import wizard
     
  4. Choose the following options:

    Field Type - Choose Delimited
    Delimited - Choose Comma
  5. In the preview pane, look at the data. This pane depicts your data and how it will appear after it is imported. Notice that the city and state data are in the incorrect columns. This is because some of the addresses contain a second address (Address 2), while others do not. Google Earth is set to ignore consecutive commas as delimiters. To fix this, uncheck Treat consecutive delimiters as one.
  6. Click Next. Check This data does not contain latitude/longitude information...
  7. Click Next. Choose Addresses are broken into multiple fields...
  8. Under Select Address Fields, review the names given to each field.
  9. Click Next. Review the list of fields and the type of data selected for each. Note that this is an optional step. When you are finished, click Back.
  10. Click Finish. Google Earth begins geocoding your data.

    Geocoding
  11. A dialog box appears indicating that Google Earth could not geocode one of your addresses. This is the last address in the sample file and it is intentionally formatted incorrectly. This dialog box allows you to view exactly which addresses did not import correctly so that you can edit the data or refine how you import your data in Google Earth.
  12. A dialog box appears and asks you if you want to apply a style template. Click Yes. The Style Template Settings dialog box appears.

    Style template
  13. Click the Color tab. Choose Use single color and click the adjacent button to pick a color for the icon which depicts the addresses in the 3D viewer.
  14. Click the Icon tab. Choose Use same icon for all features and click the adjacent field to choose the icon (example icon) that will display at the location of each address in the 3D viewer.
  15. Click the Height tab. Choose Clamp feature to the ground. This sets the icons to display at ground level in the 3D viewer.
  16. Click OK. The Save Template dialog box appears. Save the template as a file (.kst) that you can use when you import and format data in the future.
  17. You are done! Google Earth displays your address data as icons in the 3D viewer. You can edit the properties of these placemarks as you would any other placemark.

Note - The imported data is located in the Temporary Places folder within the Places Panel. Before you exit Google Earth, you need to drag this data out of this folder and choose File > Save > Save My Places.

Updated on Jan 1 2010