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!

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

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?

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

Originally Posted by MargoJournalist

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 😊

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

https://www.excelforum.com/excel-pro...ern-issue.html

A quick Google search
https://www.datanumen.com/blogs/crea...ses-excel-vba/

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?

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.