Em Andamento

ip to city/state/country

I would like a script (that can run on google sheets or excel) that can take an ip in column A and extract the geolocation data of that ip including city/state/country.

So the start result would be

Column A :ip

The end result would be

Column A: ip, Column B: city, Column C: State, Column D: Country


1. This will be done for an initial list of about 15k ip's and then on a monthly basis for around 2k ip's/month

2. If needed - paying for an external geolocation database is an option.

See attached xls for Before/After desired outcome example.

i.e I'm not looking for someone to extrct the list for me, i'm loking for a method that will enable me to do it myself on a regular basis with a growing list of ip's.

In your proposal, please write how you plan to approach this, and if use of an external database is required, and if so is there a cost to it.


Habilidades: Processamento de dados, Programação de Banco de Dados, Excel

Veja mais: ip location, geo ip, track ip address exact location, free ip location, check ip, ip 2 location, ip addresses by state, ip map, i am looking for someone to write a google apps script in google sheets, list indian cities state wise excel, list indian cities state wise, list cities india state wise, list cities india state wise excel, service php geo ip city, php code dropdown list selecting countrythe state display

Acerca do Empregador:
( 0 comentários ) Israel

ID do Projeto: #16986603

Concedido a:


Hi, bro I am a well-experienced and talented full-stack web developer. I have rich experiences with this kind of project. I am going to use [login to view URL] api to get geoloaction. Not so much efforts! I can Mais

$120 USD em 2 dias
(3 Comentários)

11 freelancers estão ofertando em média $158 para esse trabalho


Hi there,I am Miljan,Python expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I can make you this script ! I can start immediately and finish it within the agreed deadli Mais

$155 USD in 3 dias
(67 Comentários)
$250 USD in 3 dias
(1 Comentário)

A proposal has not yet been provided

$222 USD in 7 dias
(2 Comentários)

HI, I can provide you the list of city, state, country using IP address. Also, if possible will provide you the latitude, longitude also. Please let me know when we can start working. Looking forward for y Mais

$133 USD in 3 dias
(3 Comentários)

Hello, I am very interested in your project. I have extensive experience in this field. As a developer with rich experience, I am confident about your project. I will provide perfect results in a short time. If you Mais

$155 USD in 3 dias
(0 Comentários)

My plan to do this job. you can read or message me i can explain if you dont understand. I can do one php scripting. there you can upload the excel file you want to read the ips. the script will read your excel a Mais

$200 USD in 7 dias
(0 Comentários)

I can use API to fetch location based on IP address. I know some apis that does that. Ready to start.

$222 USD in 3 dias
(0 Comentários)

I am a professional developer, from my point, your requirement is very easy to realize, the only question is you have to buy a IP-Information database or service. We can discuss to which one to use, and all the other t Mais

$155 USD in 3 dias
(0 Comentários)

Hi how are you? so I can do this job, I will make a script that will lookup on internet (there is some plateforme that does it,) the geoloc of the address and then write this in the file

$66 USD in 3 dias
(0 Comentários)

Hello, I already have such a script and it works on google sheets. It uses the ipstack api to get the geolocation of the ip address. If you award me the project. I can send you the script today itself. Please note th Mais

$55 USD em 1 dia
(0 Comentários)