Importing Addresses in Google Earth Plus, Pro and EC
This tutorial describes how you can import addresses into Google Earth Plus, Pro or EC. You will import addresses from a sample electronic file and view them in Google Earth Plus, 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 this information for addresses located in 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 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. The Open dialogue box appears.
- Browse to the location of 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. Note 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, un-tick Treat consecutive delimiters as one.
- Click Next. Tick This data does not contain latitude/longitude information...
- Click Next. Choose Addresses are broken into multiple fields...
- Under Select Address Fields, review the names assigned 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 have finished, click Back.
- Click Finish. Google Earth begins geocoding your data.
- A dialogue 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 formatted incorrectly intentionally. This dialogue 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 into Google Earth.
- A dialogue box appears and asks if you want to apply a style template. Click Yes. The Style Template Settings dialogue box appears.
- Click the Colour tab. Choose Use single colour and click the adjacent button to pick a colour 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 (sample
) that will be displayed 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 dialogue box appears. Save the template as a file (.kst) that you can use when you import and format data in the future.
- That's it! 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.
