How to get Latitude and Longitude of Multiple Addresses

Hope you find it helpful. Discover more cool things you can do with ChatGPT and Google Sheets www.botsheets.com
BTW - The Geocode Add-on shown in the video is no longer available, but I found a better one and it works the same exact way:
gsuite.google.com/u/0/marketp...

[@michacassola]

The video and most of all the link to the addon in the description are awesome! Thanks so much!

[@plavali_znaem]

That was GENIUS! No silenium, nominatim or web scraping! you saved me days!!

[@kirinde]

This was amazing. Thank you @Botsheets :D

[@bo-gyungkim1848]

My first comment on CZcams ever. THANK YOU so much for sharing this video.

[@donovansmith5117]

Thank you for the video, very helpful - they changed the icon and the steps a little but your video helped me figure it out. Thanks again!

[@kellibowers7055]

This was AMAZINGLY helpful!!! Thank you!!

[@Snoopy4382]

God Bless you for making this video! :-)

[@compilationvideos368]

Thank you so much for the video and the botsheets link

[@jordanh51]

Very helpful! What if you wanted to grab the full addresses by using the lat and long coordinates? Basically doing the reverse of this? Any ideas?

[@RizalIsmail]

This is really helpful, thanks a lot.

[@unknown-ve1tp]

I'm impressed! Thank u man

[@hewang7400]

Thank you for sharing. This is so useful!

[@sheikhishakahmed1013]

Thanks man! You saved my hours!

[@tetianahumeniuk8012]

Honestly, God bless you!

[@user-oy8oe7kz4i]

This was so helpful! Thank you

[@prasathp7051]

Really helpful, Thanks !

[@gunjansharma2332]

Can you please explain it for reverse geocoding as well?

[@Harshcustoms]

This is awesome. Thank you.

[@GLTSA]

Great video Dude

[@llrecova]

Very good information. Thanks for sharing.

[@melb5524]

thanks very much , this video is awesome , i d like to know if this is possible to have a reverse geocoding , from latitude and longitude to get adresses. thanks for your reply . greetings from france

[@sanjanatarekar5942]

Works!! Amazing. Thanks

[@suleymanali_76]

Awesome. Thank you very much

[@user-yz9xx9hn9d]

Thank you very very much, very helpful

[@user-ec4gs9zc8k]

this helped me alot, thanks

[@informationalarm360]

so useful. Super amazing

[@ashimagupta9494]

Hey, Thanks really helpful

[@user-sk8vw7gw8i]

Thank You. This works

[@anitakrisniyanti9489]

Why my number format is different from you? And also I try to import it to orange app I can see the numbers but when I use geomaps, lat lng can't be found 😭

[@gj4king1]

This is awesome

[@abdullahharis3888]

Thanks a lot man

[@gagu231]

This tools is not working for me. No add-on button or links appeared after an installation

[@alisontobin6527]

Thank you!

[@Devangsurti1092]

Thanks a lot.

[@user-ep5vs6jg8p]

Legend.

[@Schxndr]

You know if this works if the city is in another cell?

[@SHANISHANI986]

ok i problem i click on add one my optio have been gecode cell guiad me

[@pickles2791]

thank you!!

[@harshshah3797]

I got limit exceeded at 850.I got 10000 rows. is there any alternative?

[@anniemilakovic7683]

came to the comments to find out the limits...i've got about 50,000 addresses lol it seems there's no way to handle so many without a commercial subscription

[@janvincentwa-ay1039]

thanks man!!!!!!!!

[@eddsumantri]

ada cara khusus kah untuk mendapatkan ge longitude dan latitude?

[@ifeanyiokwuazu3225]

Great, but only works for a few rows...not for big data

[@cesarsanchez4713]

seems to work perfect but data download with 3 digits interval, example: 000.000.000 -000.000.00

[@consciousplanet2500]

How can I get lat lon when I have google map links instead of full address?

[@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. Currently I have tens of thousands of addressed wanted to geocode, but this error came up.

[@thashingovender8318]

did you manage to find a solution around this? i also need to geocode another 10000 addresses.

[@leocapuzzi]

Shoutout to Fogo de Chão Stakehouse!

[@hanisamaliasaputri5562]

Cool!

[@farisankamestiawarapratama805]

i don’t have add ons buttonon the header. do you guys have any idea?

[@michaelbrant1755]

Are you the owner of the sheet? I would just google search that

[@duarterodriguespereira7120]

Does this also work if i only have the post code?

[@KhakhuMrMK]

Can you please send the link again, because it is not working

[@botsheets]

It looks like the Add-on I used is no longer available. But I found a better one that works the same way + it shows a cool map.
gsuite.google.com/u/0/marketplace/app/geocode_by_awesome_table/904124517349?hl=en&pann=sheets_addon_widget

[@samfubar90]

Is there a way to do the reverse of this? i.e. take Lat/Long and convert to addresses?

[@baldwinyinkore9441]

Did you figure this out? I need some help with this as well.

[@880701565900]

me too.. kindly help to share

[@tet4384]

i love you

[@bibekghalay5577]

plz help me with the opposite "How to get Multiple Addresses using Latitude and Longitude?""

[@proferoger]

Yes! Help us with this, please!!!!!

[@sauravshukla7391]

Guys have you found any solutions for reverse geocoding?

[@sauravshukla7391]

Please help

[@herreradouglas19]

Salvou Brother

[@vinitkamble4068]

Respected Sir, my name is Vinit & I want to drag down addresses in Excel from longitude and latitude. Can you share your number for further discussion? Is there any free service provide from Google? related to above process

[@TheMelinci]

Dear, this tool is limited to 900 lines. Is there anyway to push this limit forward ? Please

[@mythology_hits]

same problem I have facing... can u please tell me a solution

[@lucafeme7]

Have you found a way to solve this issue?

[@madhav5217]

any fix for this

[@madhav5217]

@@lucafeme7 any fix for this

[@madhav5217]

@@mythology_hits any fix for this

[@nuskierwithcaptainbob2102]

Very easy to install and use. Too bad you have to subscribe if you are doing more than 100 rows. Guess I didn't watch that far into the video...lol

[@webdesign_kansas_city]

You rule

[@proferoger]

Really! Help us with the opposite "How to get Multiple Addresses using Latitude and Longitude?".... (reverse geocode???)

[@ConsulthinkProgrammer]

Try this one...
Google Sheets: Reverse Geocode | Latitude dan Longitude to "formatted_address" - Part 1
czcams.com/video/_ShpO1TH560/video.html