export google earth places to excel

Export Google Earth Places to Excel: Seamless Guide & Tips

By Kevin Walker
AD

Ever found yourself buried in Google Earth, marking multiple points of interest, wishing you could easily export these locations to Excel for planning, visualization, or further analysis? You're not alone. Google Earth offers a feature-rich experience, but exporting data isn't always intuitive. Fortunately, there's a way to export Google Earth places to Excel in a few simple steps.

Before we dive into the process, let's ensure you have the Google Earth Pro version (available for purchase) or the free Google Earth 7.3 version or later, as the following methods require these specific platforms.

Using Google Earth Pro

Google Earth Pro provides advanced features, including the ability to export places to a KML/KMZ file, which can then be converted to an Excel-friendly format.

AD
how to Export any Drawing in Google Earth
how to Export any Drawing in Google Earth
10 Google Earth Tips for Power Users
10 Google Earth Tips for Power Users
Learn to place your models in Google Earth
Learn to place your models in Google Earth

Here's how to do it:

Exporting to KML/KMZ

1. First, ensure all desired placemarks are added and visible in your Google EarthMap. You can create a new map or use an existing one.

Ingresar coordenadas UTM a Google Earth, desde Excel ! - Geofumadas - GIS - CAD - BIM resources
Ingresar coordenadas UTM a Google Earth, desde Excel ! - Geofumadas - GIS - CAD - BIM resources
How to View Lot Lines in Google Earth
How to View Lot Lines in Google Earth
10 Google Earth Tips for Power Users
10 Google Earth Tips for Power Users

2. Click on the 'File' menu, then select 'Export' to open the 'Export' dialog box.

Converting KML/KMZ to Excel

1. After exporting your KML/KMZ file, download and install Google's KML/KMZ to Excel Add-in if you haven't already. This tool allows you to convert KML/KMZ files to Excel.

AD

2. Open the KML/KMZ file in Excel using the 'Data' tab and the 'Get External Data' button. Choose 'From Map (KML), From My Data Sources', then select the file and click 'Import'.

an aerial view of a small island in the middle of a body of water with buildings on it
an aerial view of a small island in the middle of a body of water with buildings on it
How to plot GPS Coordinates from excel to Google earth
How to plot GPS Coordinates from excel to Google earth
the google earth - new placemap is displayed in this screenshot
the google earth - new placemap is displayed in this screenshot
Google Earth Keeps Crashing? Here's How to Fix It Quickly!
Google Earth Keeps Crashing? Here's How to Fix It Quickly!
an aerial view of a city with lots of red buildings
an aerial view of a city with lots of red buildings
The Google Earth Time Machine - Google Earth Blog
The Google Earth Time Machine - Google Earth Blog

Using Google Earth's built-in features

For those using Google Earth 7.3 or later, you can export placemarks directly as a CSV file, which can then be opened in Excel.

Here's how:

AD

Direct Export to CSV

1. Open Google Earth and create a new folder for your placemarks. Right-click on the folder, select 'Properties', then check the 'Wrapper' box and apply the changes.

How To Record Google Earth On Windows/ Mac/ Online
How To Record Google Earth On Windows/ Mac/ Online

2. Click on the small arrow next to the folder to expand its contents. Right-click on the folder again and select 'Save Place As'. Choose 'File format' as 'Comma-separated values (.csv)', name your file, and click 'Save'.

Now that you know how to export Google Earth places to Excel, you can breeze through planning, data analysis, and visuzlization tasks. Happy mapping!

AD
AD