How to Generate Automatically Latitude and Longitude of Multiple Locations

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

[@Samikshya_25]

Wow.It's a great work. You saved my time & helped a lot .Thanks you

[@barbarag.4490]

Extremely helpful. Thank you.

[@erandiabigailramirezmunoz480]

Very useful, it works. Thanks

[@Spiritualbeing70]

Thank you! ❤️

[@roopatandel6590]

Thank you so much 👍

[@rajendraprasaddhakar1296]

Thank you sister ❤️❤️

[@businessdeals8654]

Great Thank you

[@rohitkumarchoudhary6791]

Thats really smart work...

[@cgeswa1319]

Very help full,Superb tx dear 👍🏻 mohsin,from Hyderabad,india

[@techbonustime]

Thanks my boss

[@user-yd2rd1bs2q]

Amazing! Thanks a ton for sharing!

[@Dayanand-ul7vq]

Amazing job , thank you

[@dr.svenugopal1456]

Help full video

[@engt.m4707]

I Love youuuuuuuuuuuu ♥
you saved me

[@SpreadLove1235]

Thank You

[@ameenrhamanm4679]

it is working great tq so much

[@abhijeetbollypop9255]

Great video

[@aschalewdukele2891]

tahnk UU!!

[@alishan9943]

AWESOME

[@mwaleedgeo]

Great method ♥️

[@GISRSSolution]

Thank you for your nice words. Best wishes.

[@amankumar-kw3xs]

i am highly obliged that I am accessing these videos. thank you

[@GISRSSolution]

Thank you.

[@manoharnookala4212]

Hello, it's awesome. is it possible to get address for given latitude and longitude in the same way that you showed.
TIA

[@anujawasthi8090]

It Was a great Help

[@Aadyaaaq]

if i have to pull list of ATMS or list of companies near one building,, how we will do using Google sheets

[@engahmadansari1972]

great work

[@GISRSSolution]

Thank you for your nice words. Best wishes.

[@athlete265]

Thanks

[@GISRSSolution]

Welcome

[@mohammedfaizan9672]

Please make a video on Weighted overlay analysis in ArcGIS

[@GISRSSolution]

I have a plan to make a video on AHP techniques/Weighted overlay analysis for identifying Environmental risk zone. But before that, I will upload ENVI tutorial series for image processing. Please keep in touch. Thank you.

[@augustineconteh17]

Great! Can I inbox you? thanks

[@md.monjurulhasan6819]

Please try to make a video on how to download Remote sensing data/image from NASA sentinel/AMODIS/.... Thanks.

[@GISRSSolution]

Thanks for your nice idea. I'll make a video on it. Please keep in touch.

[@doborkulabb2643]

Hi, how to convert an Address? Specific Address in a city?

[@lungelongiba6293]

help full video. let me say you are given large datasets with addresses and you want to generate them. how??

[@behzadsaeedktk2320]

some places it do not show . what to dowith that?

[@muhammadramzan6009]

HOW WE CAN GET SEVERAL COORDINATES OF A SPECIFIC CITY OF A COUNTRY?

[@primecorecore]

Microsoft xl দিয়ে করা যায় না ভাই?

[@mdnahidferdous6265]

please make a video on how to download image from sentimental 5

[@GISRSSolution]

Thank you for your interest. I'll make a video on it soon. Thanks.

[@YogeshKumar-tu6df]

hi how to get address by using Latitude and Longitude, can you help me on this

[@pandi9332]

=reverse_geocode1(A1,B1) use this formula in Excel then you will get address.put A1 cell lat and B1 cell Long

[@yeswecan4584]

Mam how to get current location

[@ms.gunasheela8168]

How to see the all four directions latitude and longitude

[@PengurusanAliranWang]

What many location can we generate for free?

[@farukkaracan3871]

İs there a limit?

[@nicoles.2149]

I encountered this error "Service invoked too many times for one day: geocode" when I wanted to geocode for a lot of addresses.

[@punitmaurya9287]

showing script error

[@vijayrd24]

it is paid service

[@mdranashake2671]

No it's free

[@itcltd]

Hi I have names of Hardware Dealers based in Kenya, is it possible that I can do a geo location search only on Kenya Map ?