Extracting Addresses from Google Earth

In this video, you will learn how to extract address data from Google Earth to Microsoft Excel. To demonstrate the process of extracting the address data, we will be doing a quick search to find out the locations of Sainsbury’s supermarkets in Liverpool, United Kingdom. We will then save the search results provided by Google Earth search engine to a separate KML file.

As the first method, we will be using QGIS to import the KML file, inspect the attributes table and export the KML file into a ESRI Shapefile. Once an ESRI Shapefile is created, we will use a spreadsheet management software like Microsoft Excel/ Libreoffice to open the database file (.DBF), which contains the same attributes information, consisting of the full addresses of the Sainsbury’s stores. In the second method, we will not be using QGIS and instead, we will use the address data embedded in the original KML file and import it into Microsoft Excel as an XML table.

#googleearth #excel #geodeltalabs

[REMAXMaryCobbina]

Is it possible to extract roads within a postcode on Google Earth?

[nvhd]

Thank you so much for sharing. I can only see the first page, the second page shows an error "We couldn't understand this location". Do you have a way to fix it? Please help me. Thank you.

[maryamazeez]

Hi, Kindly recommend fro a beginner the specifications a Laptop has to have to run an ArcGIS effectively?. Thanks.

[ebrahimrastar]

Thank you so much for sharing, very useful for me 👍👍👍👌👌👌🙏🙏🙏

[lifehacker]

superb sir !
finished all google earth pro put some more videos on it !
waiting