Step 1: Open Google Earth Pro<\/h2>\n
Launch Google Earth Pro on your computer. Make sure you have the latest version installed for the best experience. Google Earth Pro is available free of charge from Google’s website.<\/p>\n
Step 2: Zoom into Your Area of Interest<\/h2>\n
Use the zoom controls or the search bar to navigate to the location you want to work with. In this example, we examine the runway at Geneva Airport.<\/p>\n
<\/p>\n
Step 3: Create a Folder for Your Points<\/h2>\n
Organising your data into folders before adding placemarks makes the export process much cleaner. In the Places panel on the left, right-click Temporary Places<\/strong>, choose Add > Folder<\/strong>, name it Points<\/em>, and click OK<\/strong>.<\/p>\n Click the Add Placemark<\/strong> button (the yellow pin icon in the toolbar) to drop your first point. Give it a descriptive name such as Point 1<\/em> and click OK<\/strong>. Repeat for each additional point, naming them Point 2<\/em>, Point 3<\/em>, and so on. Make sure each placemark is saved inside the Points<\/em> folder you just created.<\/p>\n If you also need to capture line features \u2014 for example, the centreline of a runway \u2014 create a second folder. Right-click Temporary Places<\/strong> again, choose Add > Folder<\/strong>, name it Polyline<\/em>, and click OK<\/strong>.<\/p>\n Click the Add Path<\/strong> button in the toolbar to draw your line. Click along the route to add vertices, then click OK<\/strong> when finished. You can change the line colour (for example, red) in the Style\/Colour tab of the path dialog to make it easier to see.<\/p>\n Google Earth Pro does not have a direct CSV or Excel export. Instead, you export to KMZ (a compressed KML file) and then convert it in the next step.<\/p>\n To export your points, right-click the Points<\/em> folder in the Places panel and choose Save Place As<\/strong>. Select a destination folder on your computer, give the file a name, and click Save<\/strong>. The file will be saved in KMZ format by default. Repeat this for the Polyline<\/em> folder if you created one.<\/p>\n KMZ files cannot be opened directly in Excel. Use the free online tool GPS Visualizer<\/strong> (gpsvisualizer.com) to convert your KMZ file into a tab-delimited plain-text file that Excel understands.<\/p>\n On the GPS Visualizer homepage, find the Convert a file<\/strong> section. Set the output format to Plain Text<\/strong>. Click Choose Files<\/strong>, navigate to your saved KMZ files, and select them. You can upload both the points and polyline files at the same time.<\/p>\n GPS Visualizer can enrich your data with elevation values sourced from a Digital Elevation Model (DEM). A DEM is a digital representation of terrain height. If you want elevation data added to your output, set the Add DEM elevation data<\/strong> option to Best available source<\/strong> before converting. Note that this elevation data comes from the DEM source, not directly from Google Earth Pro’s imagery.<\/p>\n Click the Convert<\/strong> button. When the conversion is complete, a download link will appear on the page. Click it to download the plain-text file containing your coordinates.<\/p>\n Open Excel and create a new blank workbook. Go to the Data<\/strong> tab and click From Text\/CSV<\/strong>. Navigate to the downloaded text file, select it, and click Import<\/strong>. Excel will display a preview of the data and automatically detect the tab delimiter used by GPS Visualizer. Click Load<\/strong> to bring the data into your spreadsheet.<\/p>\n Once the data is loaded, you will see columns for the point name, latitude, longitude, elevation, and possibly other GPS Visualizer metadata fields. Delete any columns you do not need and keep at minimum the name<\/strong>, latitude<\/strong>, and longitude<\/strong> columns. Your coordinates will be in decimal degrees format, which is the standard used by Google Earth Pro and GPS Visualizer.<\/p>\n No. Google Earth Pro exports placemarks and paths in KMZ or KML format only. To get coordinates into Excel you need an intermediate conversion step, such as using GPS Visualizer as described above. Alternatively, you can right-click a single placemark, open its properties, and manually copy the displayed latitude and longitude \u2014 but this is only practical for a small number of points.<\/p>\n KML (Keyhole Markup Language) is an XML-based file format for storing geographic data. KMZ is simply a ZIP-compressed version of a KML file. Both formats are supported by GPS Visualizer and many other GIS tools.<\/p>\n GPS Visualizer’s plain-text output includes latitude, longitude, and elevation in decimal degrees and metres. It does not automatically output UTM coordinates. If you need UTM values, you can convert decimal-degree coordinates to UTM using a formula in Excel or an online coordinate converter after importing.<\/p>\n A Digital Elevation Model is a digital representation of the Earth’s surface showing terrain height. GPS Visualizer can use DEM data to add elevation values to your coordinate output even if your original placemarks did not include altitude information.<\/p>\n Yes. GPS Visualizer accepts both KML and KMZ files. The conversion process is identical.<\/p>\n GPS Visualizer includes several metadata columns in its output that are useful for GPS applications but unnecessary for most coordinate analyses. Removing irrelevant columns makes the spreadsheet easier to read and reduces the risk of errors in downstream processing.<\/p>\n","protected":false},"excerpt":{"rendered":" In this tutorial, we walk you through the process of extracting latitude, longitude, and elevation data from Google Earth Pro and importing it into Excel. The workflow uses Google Earth Pro’s built-in KMZ export and the free online tool GPS Visualizer to convert that KMZ file into a plain-text format that Excel can read. Note:…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"episode_type":"","audio_file":"","podmotor_file_id":"","podmotor_episode_id":"","cover_image":"","cover_image_id":"","duration":"","filesize":"","filesize_raw":"","date_recorded":"","explicit":"","block":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-16053","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/mapscaping.com\/wp-json\/wp\/v2\/posts\/16053","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mapscaping.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mapscaping.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mapscaping.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mapscaping.com\/wp-json\/wp\/v2\/comments?post=16053"}],"version-history":[{"count":1,"href":"https:\/\/mapscaping.com\/wp-json\/wp\/v2\/posts\/16053\/revisions"}],"predecessor-version":[{"id":20459,"href":"https:\/\/mapscaping.com\/wp-json\/wp\/v2\/posts\/16053\/revisions\/20459"}],"wp:attachment":[{"href":"https:\/\/mapscaping.com\/wp-json\/wp\/v2\/media?parent=16053"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mapscaping.com\/wp-json\/wp\/v2\/categories?post=16053"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mapscaping.com\/wp-json\/wp\/v2\/tags?post=16053"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}<\/p>\n
Step 4: Add Placemarks to the Folder<\/h2>\n
<\/p>\n
Step 5: Create a Folder for Polylines (Optional)<\/h2>\n
<\/p>\n
Step 6: Draw a Polyline (Optional)<\/h2>\n
<\/p>\n
Step 7: Export Your Data as KMZ<\/h2>\n
<\/p>\n
Step 8: Convert KMZ to Plain Text Using GPS Visualizer<\/h2>\n
Upload your KMZ files<\/h3>\n
<\/p>\n
Add DEM elevation data (optional)<\/h3>\n
<\/p>\n
Convert and download<\/h3>\n
![\"Downloading](\"https:\/\/mapscaping.com\/wp-content\/uploads\/2024\/09\/image-209.png\")
<\/p>\nStep 9: Import the Text File into Excel<\/h2>\n
<\/p>\n
Step 10: Clean Up Your Data in Excel<\/h2>\n
![\"Cleaned](\"https:\/\/mapscaping.com\/wp-content\/uploads\/2024\/09\/image-210.png\")
<\/p>\nFAQ<\/h2>\n
Does Google Earth Pro export directly to CSV or Excel?<\/h3>\n
What is the difference between KMZ and KML?<\/h3>\n
Will the output from GPS Visualizer include UTM coordinates?<\/h3>\n
What is a Digital Elevation Model (DEM)?<\/h3>\n
Can I convert KML files as well as KMZ files?<\/h3>\n
Why should I clean up my Excel data after importing?<\/h3>\n