# Wrong addressing **URL:** \ **Category:** Ask for Help\ **Created:** [May 17, 2020, 8:31pm UTC](https://community.glideapps.com/t/wrong-addressing/9312 "2020-05-17T20:31:21Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![dharmel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dharmel/32/7494_2.png) [@dharmel](https://community.glideapps.com/u/dharmel)\ **Post date:** [May 17, 2020, 8:31pm UTC](https://community.glideapps.com/t/wrong-addressing/9312/1 "2020-05-17T20:31:21Z")
Hello, I used “Google codes” to display adresses on the map =\> is this correct ? Some adresses are still well mapped (in US instead of Belgium). Example : 9489+CG Schaltin Otherwise, do you know how to have a nice map with all my addresses, what kind of information should I put in my googlesheet? My app link : [https://nduqe.glideapp.io/](https://nduqe.glideapp.io/) Thanks in advance ! ---
**Author:** ![Tim\_Sullivan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_sullivan/32/3461_2.png) [@Tim\_Sullivan](https://community.glideapps.com/u/Tim_Sullivan)\ **Post date:** [May 17, 2020, 8:57pm UTC](https://community.glideapps.com/t/wrong-addressing/9312/2 "2020-05-17T20:57:21Z")
This is probably the best answer to date for correct addresses in the map. Add the script to your sheet and point your map addresses to the lat/long field in your sheet. Thanks to @Dan_Liebeschutz for the well written article. > [@Showing addresses in Glide map component](https://community.glideapps.com/t/showing-addresses-in-glide-map-component/8980): > > Hi! I don’t know if you had a problem with putting addresses in the map component, but for me, the location pins were showing everywhere but the place I was aiming for. After figuring out how to make it work properly I wrote a very short story about it in Medium: [https://medium.com/@danliebeschutz/how-to-make-addresses-show-correctly-in-glide-app-map-component-d0dcd8dcfba4](https://medium.com/@danliebeschutz/how-to-make-addresses-show-correctly-in-glide-app-map-component-d0dcd8dcfba4) This is me trying to put 4 addresses in Tel Aviv: Before: [image] After: [image] Enjoy! ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [May 17, 2020, 9:59pm UTC](https://community.glideapps.com/t/wrong-addressing/9312/4 "2020-05-17T21:59:08Z")
I just upload my sheet to [https://www.geocod.io/upload/](https://www.geocod.io/upload/) Then just use the lat and long it generates. ---
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [May 17, 2020, 11:02pm UTC](https://community.glideapps.com/t/wrong-addressing/9312/5 "2020-05-17T23:02:52Z")
definitely use lat,long coordinates. ---
**Author:** ![Gliderrr](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gliderrr/32/5215_2.png) [@Gliderrr](https://community.glideapps.com/u/Gliderrr)\ **Post date:** [May 17, 2020, 11:07pm UTC](https://community.glideapps.com/t/wrong-addressing/9312/6 "2020-05-17T23:07:00Z")
+1 for geolocation with Lat & Long instead of an address to populate maps in Glide. (or any component that will require an address) You can be very, very accurate by setting a marker on Google maps then collecting the Lat & Long it returns. ---
**Author:** ![Dan\_Liebeschutz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_liebeschutz/32/3393_2.png) [@Dan\_Liebeschutz](https://community.glideapps.com/u/Dan_Liebeschutz)\ **Post date:** [May 18, 2020, 9:52am UTC](https://community.glideapps.com/t/wrong-addressing/9312/7 "2020-05-18T09:52:31Z")
Hi @dharmel! I just wrote an explanation article on [how to add a custom function script to google spreadsheet from a script source](https://medium.com/@danliebeschutz/how-to-add-a-custom-function-script-to-google-spreadsheet-from-a-script-source-db1bb8b0483b?sk=94d79be794bf91c6ef90cce1583f6452). Can you please check it out and tell me if it helped? It also has in it a video showing the steps. ---
**Author:** ![Dan\_Liebeschutz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_liebeschutz/32/3393_2.png) [@Dan\_Liebeschutz](https://community.glideapps.com/u/Dan_Liebeschutz)\ **Post date:** [May 18, 2020, 9:53am UTC](https://community.glideapps.com/t/wrong-addressing/9312/8 "2020-05-18T09:53:13Z")
Thanks for the shout out @Tim_Sullivan ---
**Author:** ![Tim\_Sullivan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_sullivan/32/3461_2.png) [@Tim\_Sullivan](https://community.glideapps.com/u/Tim_Sullivan)\ **Post date:** [May 18, 2020, 10:16am UTC](https://community.glideapps.com/t/wrong-addressing/9312/9 "2020-05-18T10:16:40Z")
I don’t think I could do any better than Dan’s explanation. It’s about as step-by-step ads it gets. ---
**Author:** ![dharmel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dharmel/32/7494_2.png) [@dharmel](https://community.glideapps.com/u/dharmel)\ **Post date:** [May 19, 2020, 10:03am UTC](https://community.glideapps.com/t/wrong-addressing/9312/10 "2020-05-19T10:03:16Z")
it works perfectly !!! Thanks a lot 🤩 ---
**Author:** ![dharmel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dharmel/32/7494_2.png) [@dharmel](https://community.glideapps.com/u/dharmel)\ **Post date:** [May 29, 2020, 5:59pm UTC](https://community.glideapps.com/t/wrong-addressing/9312/11 "2020-05-29T17:59:15Z")
I have a big problem with the script in googlesheet allowing geolocalisation ![2020-05-29 18_49_21-HappyKids - Google Sheets et 4 pages de plus - Travail - Microsoft​ Edge](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/923e418ec774650d3b9c547cda2f285c72ec73ed.png) ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [May 29, 2020, 7:02pm UTC](https://community.glideapps.com/t/wrong-addressing/9312/12 "2020-05-29T19:02:28Z")
Hi, Google Maps gives you a daily limit to your queries: 1.000 Beyond it, Google punishes you for 24 hours. Many of us have walked that lonely way before 🤣 Saludos @dharmel ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 29, 2020, 10:52pm UTC](https://community.glideapps.com/t/wrong-addressing/9312/13 "2020-05-29T22:52:49Z")
Have you ever tried another service besides Google Maps? I have seen some out there, not sure if they have higher limits daily. ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [May 30, 2020, 2:29am UTC](https://community.glideapps.com/t/wrong-addressing/9312/14 "2020-05-30T02:29:42Z")
Years ago I knew and worked with ArcGIS software a little, their GIS applications are amazing!! They had APIs very powerful but I don’t know if those are free yet. Here their web page: [https://www.arcgis.com](https://www.arcgis.com) Chao @ThinhDinh ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 30, 2020, 2:32am UTC](https://community.glideapps.com/t/wrong-addressing/9312/15 "2020-05-30T02:32:11Z")
Thank you I’ll have a look later. Here are some other options I have read about. > ---
**Author:** ![dharmel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dharmel/32/7494_2.png) [@dharmel](https://community.glideapps.com/u/dharmel)\ **Post date:** [June 1, 2020, 8:11am UTC](https://community.glideapps.com/t/wrong-addressing/9312/16 "2020-06-01T08:11:52Z")
thanks ! 😅 ---
**Author:** ![profechef](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/profechef/32/221_2.png) [@profechef](https://community.glideapps.com/u/profechef)\ **Post date:** [December 1, 2020, 6:25pm UTC](https://community.glideapps.com/t/wrong-addressing/9312/17 "2020-12-01T18:25:11Z")
Thanks @Dan_Liebeschutz. It’s a good solution to the problem of showing an address in its correct location on a map ---
**Author:** ![Mauronic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mauronic/32/21726_2.png) [@Mauronic](https://community.glideapps.com/u/Mauronic)\ **Post date:** [December 10, 2020, 4:41am UTC](https://community.glideapps.com/t/wrong-addressing/9312/18 "2020-12-10T04:41:13Z")
Great technique but unfortunately it fails if I try to process more than ~125 cells at a time in my arrayformula. ☹ ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 10, 2020, 4:42am UTC](https://community.glideapps.com/t/wrong-addressing/9312/19 "2020-12-10T04:42:36Z")
Scripts, scripts, scripts, scripts, scripts, scripts!!!Everbody!! (My new Lil Jon Parody) ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 10, 2020, 4:45am UTC](https://community.glideapps.com/t/wrong-addressing/9312/20 "2020-12-10T04:45:09Z")
Google…limits…psh, screw that. Make multiple accts on google, feed data to accts using import range, script runs, what do you do? That’s right you import those results right back into your Glide Google sheet using another import range, thats what you do.