Coordinates for addresses

[Naeaes]

I need to get latitude/longitude coordinates for a list of addresses. I figured I could just import my addresses into Google MyMaps from Google Sheets and then download a new file as .KML which would have the coordinated but that didn't work out. It turns out the .KML (which is just a renamed .XML) doesn't have the coordinates. It seems to me, google only includes the coordinates data for points that were manually added by clicking the map and not if they were imported in bulk. For the bulk data, there's only the info I uploaded myself.

 

Is there some other service that gives you coordinates for addresses or is there a way to force MyMaps to do this? 

 

EDIT: I found Google's API for this: https://developers.google.com/maps/documentation/geocoding/start?csw=1 
Looks like it'll take a line or two of code, which is a line or two more than what I have time for now. I'll look into it tomorrow. If anyone comes up with suggestions, I'm all ears, I'd rather not python in the morning. What with the If Coffee=False Then brainFunction=False

 

[Dissitesuxba11s]

Have you tried this website: https://www.gps-coordinates.net/

[Naeaes]

9 minutes ago, Dissitesuxba11s said:

Have you tried this website: https://www.gps-coordinates.net/

Something like that could be exactly what I need but I really have to be able to get the data in bulk. I'm dealing with about a thousand locations now and a few thousand more in a few weeks. So having to fill in text fields one by one is a no-go.  That API looks interesting thou...

To be exact, I only need the location data for doing some crude math on what location is closest to what other locations so it doesn't matter what standard the data is in, so long as it's uniform for all my locations. I'll be using excel or python for the math anyway so the website doesn't really have to have any functions for that. 

[Dissitesuxba11s]

10 minutes ago, Naeaes said:

Something like that could be exactly what I need but I really have to be able to get the data in bulk. I'm dealing with about a thousand locations now and a few thousand more in a few weeks. So having to fill in text fields one by one is a no-go.  That API looks interesting thou...

To be exact, I only need the location data for doing some crude math on what location is closest to what other locations so it doesn't matter what standard the data is in, so long as it's uniform for all my locations. I'll be using excel or python for the math anyway so the website doesn't really have to have any functions for that. 

Try this one out: https://www.mapdevelopers.com/batch_geocode_tool.php

It's limited to 100 addresses at a time.