Clicky

 _             _     _      _    _      _
(_)_ __    ___(_) __| | ___| | _(_) ___| | __
| | '_ \  / __| |/ _` |/ _ \ |/ / |/ __| |/ /
| | |_) | \__ \ | (_| |  __/   <| | (__|   <
|_| .__/  |___/_|\__,_|\___|_|\_\_|\___|_|\_\
  |_|
    

Using IP Sidekick geolocation API in Google Sheets

Using Javascript, you can lookup IP addresses in Google Sheets for geolocation

  1. In Google Sheets, under Tools, click Script editor...
  2. Paste the contents of this file.
  3. Hit the Save button. You may be asked to give the project a name.
  4. In your spreadsheet, click on the desired cell and enter something like =resolveIP(A1) where A1 is the cell you want to lookup.