IP Converter is a Google Sheets Add-on that allows you to convert IP addresses to a variety of other formats like lat/long, city/state/country, ASN, integer, hex, and more...
This add-on supports the conversion of both IPv4 and IPv6 addresses. To use it:
Install the add-on from the G Suite Marketplace
Select the range of IP addresses you want to convert
Select Add-ons > IP Converter > Convert from the Google Sheets menu
Select the output format
Click Convert
Your account will be debited the appropriate number of credits after each conversion. See the table below for examples of the types of conversions that are available.
Each IP address conversion costs a single credit. Your account is automatically granted 10,000 credits each day and you can purchase additional credits as necessary.
No Purchase Necessary