Re: IP Address support in spreadsheets?

[Trey Scarborough via NANOG <nanog () lists nanog org>]

I do this a bunch for importing and exporting equipment in to different 
systems. I have used the google ipfunctions, but I mainly work in libre 
calc for that I used to have some of the functions programed in a sheet 
then I found this and just added the macros 
https://extensions.libreoffice.org/en/extensions/show/ip-calculator

On 9/15/25 1:30 PM, 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 :-)
_______________________________________________
NANOG mailing list 
https://lists.nanog.org/archives/list/nanog () lists nanog org/message/ZZQ6CQ7UIPZQLKNE6VBI3F56RNX3U2N5/