Importing Addresses in Google Earth Plus, Pro and EC
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 Pluus, Pro or EC. You can also import latitude and longitude data - learn more.
Note - You must have Google Earth Plus, Pro or EC to use the features described in this tutorial. Learn more here.
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. Google Earth Plus can import 100 addresses at a time. To learn more about what information Google Earth Plus, Pro or EC can import, see Using Addresses in the Google Earth User Guide.
Try importing data from a sample CSV file. To do this:
- Download the sample file. Save this file to a location on your hard drive (for example C:\SampleData\samplefile.csv).
- In Google Earth, click File > Import. If you are using Google Earth Plus, click File > Open.
- 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.
- Choose the following options:
Field Type - Choose Delimited
Delimited - Choose Comma
- 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.
- Click Next. Check This data does not contain latitude/longitude information...
- Click Next. Choose Addresses are broken into multiple fields...
- Under Select Address Fields, review the names given to each field.
- 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.
- Click Finish. Google Earth begins geocoding your data.
- 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.
- A dialog box appears and asks you if you want to apply a style template. Click Yes. The Style Template Settings dialog box appears.
- 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.
- Click the Icon tab. Choose Use same icon for all features and click the adjacent field to choose the icon (example
) that will display at the location of each address in the 3D viewer.
- Click the Height tab. Choose Clamp feature to the ground. This sets the icons to display at ground level in the 3D viewer.
- 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.
- 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.
