Re: IP Address support in spreadsheets?

[Brian Knight via NANOG <nanog () lists nanog org>]

On 2025-09-15 13:30, Bryan Fields via NANOG wrote:
> Has anyone found a solution to represent IPv4 addresses in a 
> spreadsheet, preferably Google Sheets?  I'm not here to debate the use 
> of spreadsheets for tracking IP addresses, just find something better 
> than storing v4 dotted decimal as text in a spreadsheet.  We don't need 
> v6 at this time; we're using a spreadsheet for tracking addressing, v6 
> is beyond us.
>
> At minimum we need to store it as a 32 bit INT, and display as dotted 
> decimal.  If there's some way to make it aware of subnet slash 
> notation, so much the better.  I'm a bit at a loss as to why there's no 
> IPv4 number format with how often spreadsheets are the source of truth 
> in some rather large service providers.
>
> Again, not looking for non-spreadsheet solutions to this, and ideally a 
> web interface spreadsheet would be best for sharing.  We don't need a 
> real database if it's on the web :-)

If you're not allergic to MS Excel, you could use Python for Excel to 
convert back and forth with the excellent ipaddress module.

https://www.google.com/?q=google%20sheets%20ip%20functions turned up an 
interesting add-on, have you looked into IP Functions at all?

Could also just roll your own inet_aton() in your columns for the dotted 
quads using LEFT(), MID(), RIGHT(), and FIND().

Or just spin up Netbox and load your prefixes into that and be done.

-Brian
_______________________________________________
NANOG mailing list 
https://lists.nanog.org/archives/list/nanog () lists nanog org/message/QIZBM4KIRQRM22MRRZB2XXZMPX7JQB2Z/