latitude longitude

[#1]

is the a free website I can load Address city and state data in excel and have it return the latitude longitude?

Currently I only have about 150 address.

[jpenuliar]

Hi Robert,

This code works to extract Lat&Long from google api:

Cities:

Load * Inline

[

    City, Qty

    DARDILLY,5

    ECOLE VALENTIN,56

    GENTILLY,2

    GOUSSAINVILLE,45

    LYON,8

    PARIS,98

    PERONNAS,56

    RILLIEUX LA PAPE,74

    SEYSSINET PARISET,54

    SOISSONS,25

    VILLEFRANCHE SUR SAONE,86

    Manila,52

];

let noRows = NoOfRows('Cities')-1;

for i=0 to $(noRows)

    let a = peek('City',$(i),'Cities');

    let b = peek('Qty',$(i),'Cities');

    LOAD  

            '$(a)' as CustomerCity,

            '$(b)' as CustomerQuantity,

            Replace([result/geometry/location/lat], '.', ',')         as latitude,

            Replace([result/geometry/location/lng], '.', ',')         as longitude

    FROM [https://maps.googleapis.com/maps/api/geocode/xml?address=$(a)] (XmlSimple, Table is [GeocodeResponse]);

next i;

Drop table Cities;

[MK9885 · Accepted solution]

Batch Geocode

https://www.doogal.co.uk/BatchGeocoding.php

[dandaanilreddy]

Hi Robert

Please find the attached zip below.

Thanks

Anil Danda !

[MK9885]

BTW, verify those latitude and longitude in google once you geocode it from that website.

Thanks.

[#6]

OK thank you for your help, really appreciate it.

Thank you,

Bob

[#7]

Yes, there are few out there.

You also try this one : CSV 2 Geo Data

It comes with free version and will allow you to insert flat file in csv format. All you have to do is save as csv your excel and import it or copy/paste the addresses in question.