En cours

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

Notes:

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.

Thanks

Compétences : Traitement de Données, Programmation de bases de données, Excel

en voir plus : 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

Concernant l'employeur :
( 0 commentaires ) Israel

Nº du projet : #16986603

Décerné à:

dungforever

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 Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 2 jours
(3 Commentaires)
3.8

11 freelance font une offre moyenne de $158 pour ce travail

zekovicm

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(67 Commentaires)
6.4
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(1 Évaluation)
4.6
tausy

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(2 Commentaires)
2.4
royalwebraisers

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(3 Commentaires)
2.0
davidngo817

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
sweta2317

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0
akweb2015

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
robbinpeng

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
gregorybliault

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
yolando123

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0