Welcome to GIS and RS solution channel. Today I will show you how to generate Automatically Latitude and Longitude of Multiple Locations using Google sheets and ezGeocode. Before that, if you are a first-time viewer, you can consider subscribing this channel to get weekly videos on GIS and remote sensing.
At first, login your Gmail account and then click on google sheets. And then click on this new blank spreadsheet.
You will see Add on . Click on it. In search box, write ezGeocode and you will get it as an extension of it. Install this add on.

Then again click on Add on and from the list select ezGeocode and click on open.
Then you will get an interface of ezGeocode. Click on setup for geocode address.
Enter your locations in column A that you need to find Latitude and longitude. I have written some locations as example for this video. After writing locations, click on geocode to generate Latitude and Longitude.
Then you will get Latitude and Longitude has generated automatically. Besides that, others several information like Postal code, city, country, region has produced in this process.

You can also download the file for further mapping or any other tasks that you need.
Hope you will like this video. If you do so, please SUBSCRIBE this channel. Thank you for watching.

Tags: Automatic Latitude and Longitude create of multiple locations, Latitude and longitude for any locations, how to generate coordinates automatically of any locations, google sheets, ezGeocode

#generate_automatic_coordinates_of_any_locations #Latitude_longitude #GISRSSOLUTIONS

свернуть