Google Earth: KML File Creator - How to export locations from Excel to Google Earth

Описание

In this video I will show you how to export point location data from Excel to Google Earth Pro using the KML File Creator, an Excel Tool with a VBA engine which I made about 12 years ago. We will use some water well data from the Kharga Oasis in the Western Desert of Egypt, where I used to work. You will learn:
- How to adjust the macro settings in Excel.
- How to create a Google Earth (KML) file using the KML File Creator
- How to include pictures in Google Earth.
- How to export the final product as a KMZ file, for sharing by e-mail.

You should always use Google Earth Pro before you start investing time into setting up a GIS. Google Earth Pro is a powerful tool to help us understand a project area quickly, easily and cheaply.

Source of data: Mustafa El-Rawy and Florimond De Smedt (2020): Estimation and Mapping of the Transmissivity of the Nubian Sandstone Aquifer in the Kharga Oasis, Egypt; Water 2020, 12, 604; doi:10.3390/w12020604

Link to paper: https://bit.ly/2FWEFXf
Link to processed Excel sheet: https://bit.ly/2TtDh1j
Link to Kharga Oasis Wells KMZ: https://bit.ly/2HcnPEq
Link to Kharga Oasis KML File Exporter: https://bit.ly/371W9v5
Link to KML File Creator V1.7: https://bit.ly/2HhbtLo (used in this video)
Link to KML File Creator V2.0: https://bit.ly/37MuD5i

Note: 28 May 2021. I have updated the KML file creator so that it should work also in those countries where you use a comma instead of a point for the decimal separator.

Note 15 August 2021. I have made a new KML file creator, where you can select other colours for the PushPin icon. Here is the link: https://bit.ly/37MuD5i

This video is part of the online QGIS 101 course.

#KML #GoogleEarth #ExportDatatoGoogleEarth