Sedang Disiapkan

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.


Kemahiran: Pemprosesan Data, Pengaturcaraan Pangkalan Data, Excel

Lihat lagi: 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

Tentang Majikan:
( 0 ulasan ) Israel

ID Projek: #16986603

Dianugerahkan kepada:


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 Lagi

$120 USD dalam 2 hari
(3 Ulasan)

11 pekerja bebas membida secara purata $158 untuk pekerjaan ini


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 Lagi

$155 USD dalam 3 hari
(61 Ulasan)
$250 USD dalam 3 hari
(1 Ulasan)

A proposal has not yet been provided

$222 USD dalam 7 hari
(2 Ulasan)

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 Lagi

$133 USD dalam 3 hari
(3 Ulasan)

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 Lagi

$155 USD dalam 3 hari
(0 Ulasan)

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 Lagi

$200 USD dalam 7 hari
(0 Ulasan)

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

$222 USD dalam 3 hari
(0 Ulasan)

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 Lagi

$155 USD dalam 3 hari
(0 Ulasan)

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 dalam 3 hari
(0 Ulasan)

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 Lagi

$55 USD dalam sehari
(0 Ulasan)