Free Geo IP API: Excel and Google Apps Script. The Daily REST library entry | Geo Ip |

Geo code from ip and host names

Today's API is a straightforward query per row, meaning that data is retrieved from the API using the contents of a column as the query. In this case the host column provides the query data. The freegeoip API will take a host name and ip address and provide geolocation data for it. Here's how to do it in bulk directly from Excel or Google Apps Script.


Via brucemcpherson