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:

1) Install the add-on from the G Suite Marketplace
2) Select the range of IP addresses you want to convert
3) Select Add-ons > IP Tools > Convert from the Google Sheets menu
4) Select the output format
5) Click Convert