Closed Thread
Results 1 to 11 of 11

Extract longitudes and latitudes from Google Maps link

  1. #1
    Registered User
    Join Date
    09-21-2019
    Location
    Seattle, WA
    MS-Off Ver
    Excel for Mac 16.29
    Posts
    6

    Extract longitudes and latitudes from Google Maps link

    Hello,

    I'm working with a document of over 5000 rows of addresses, and I'm hoping to be able to use Tableau to map them and sort them. However, I only have addresses that I can't manually Google to get all the longitudes/latitudes. I have used a formula that automatically looks the addresses up and adds a link to Google Maps in the excel sheet. I'm hoping to extract the longitude/latitudes from that link. I think there must be a way to get the full link, in which longitudes/latitudes are embedded, and thus extract them, but I have no clue how. I've also tried to use, in Google Sheets, Geocode by Awesome Table, which works great but is limited to 1000 geocode searches a day (and my document is much larger than that, my deadline soon). Can anyone help me out?

    For some reason, I can't attach the file (not even zipped), and I can't post anything with a link either, but I'll try in the responses.

    Thanks so much in advance for your help!

  2. #2
    Forum Contributor
    Join Date
    03-08-2018
    Location
    Denmark
    MS-Off Ver
    2016 for Windows
    Posts
    255

    Re: Extract longitudes and latitudes from Google Maps link

    I have made a application that includes typing an address to get the disstens. I use a Google API, I know you can get the longitudes and latitudes as well. I am not sure if there is a limitation on amount of searches per day on the free account.
    Try looking it up

  3. #3
    Registered User
    Join Date
    09-21-2019
    Location
    Seattle, WA
    MS-Off Ver
    Excel for Mac 16.29
    Posts
    6

    Re: Extract longitudes and latitudes from Google Maps link

    Hi there, thanks! How can I get access to your application? I think with Google API you can pay for more returns, and that's fine for me so that would be great. Does your application work on Mac? Or only Windows?

  4. #4
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,403

    Re: Extract longitudes and latitudes from Google Maps link

    At 5 posts or just after, you can attach files and urls.

  5. #5
    Forum Contributor
    Join Date
    03-08-2018
    Location
    Denmark
    MS-Off Ver
    2016 for Windows
    Posts
    255
    Quote Originally Posted by MargoJournalist View Post
    Hi there, thanks! How can I get access to your application? I think with Google API you can pay for more returns, and that's fine for me so that would be great. Does your application work on Mac? Or only Windows?
    I built the application for my work, so I can't upload it.
    But just Google API Google maps and it should come up.
    There are plenty of code out there for what you need.
    I am on mobile now so I can't look it up for you 😊

  6. #6
    Registered User
    Join Date
    09-21-2019
    Location
    Seattle, WA
    MS-Off Ver
    Excel for Mac 16.29
    Posts
    6

    Re: Extract longitudes and latitudes from Google Maps link

    I'm sorry, but I really have no clue how to find it (even if I google) or how to do this... Can you give me a couple more pointers? I'm not a coder so this is all new to me and I don't really know what you are talking about.

    Margo

  7. #7
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,403

    Re: Extract longitudes and latitudes from Google Maps link


  8. #8
    Forum Contributor
    Join Date
    03-08-2018
    Location
    Denmark
    MS-Off Ver
    2016 for Windows
    Posts
    255

    Re: Extract longitudes and latitudes from Google Maps link


  9. #9
    Registered User
    Join Date
    09-21-2019
    Location
    Seattle, WA
    MS-Off Ver
    Excel for Mac 16.29
    Posts
    6

    Re: Extract longitudes and latitudes from Google Maps link

    Thanks, but the problem is that my addresses are not structured that way -- they are just one cell, reading as such: 9000-blk 17 AV SW SEATTLE for example. Google Maps finds the correct locations, but I cannot use this application. Any other advice?

  10. #10
    Forum Contributor
    Join Date
    03-08-2018
    Location
    Denmark
    MS-Off Ver
    2016 for Windows
    Posts
    255

    Re: Extract longitudes and latitudes from Google Maps link

    You can split the address up in cells with formula and VBA, but that is not something that I am good at. But I am sure there someone else that can guides you.

  11. #11
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    22,625

    Re: Extract longitudes and latitudes from Google Maps link

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the thread in Commercial service, which takes precedence over the free forums.
    Glenn



Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1