Re: IP Address support in spreadsheets?

[Mark Wiater via NANOG <nanog () lists nanog org>]

This extension also has google sheets and microsoft excel support, kinda 
nice.  http://trk.free.fr/ipcalc/



On 9/15/2025 5:29 PM, Trey Scarborough via NANOG wrote:
> 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/

_______________________________________________
NANOG mailing list 
https://lists.nanog.org/archives/list/nanog () lists nanog org/message/5BTZL4XQTI3WVNFDOMPV2WZYDBM3TXHG/