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.
11 freelancers are bidding on average $158 for this job
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