Re: IP Address support in spreadsheets?

[Aaron1 via NANOG <nanog () lists nanog org>]

For about 20 years, I’ve been using an Excel spreadsheet for IPv4 address documentation, even more, subnet 
calculations.  Lately, I’ve been using it for IPv6 as well, kind of painful, but I can make it work.  As mentioned, I 
actually have an in-line breakout section of binary to make the subnetting more visual and easier to track with 
applicable formulas in the cells to cause it to calculate the dotted decimal equivalent.

My v6 spreadsheet doesn’t have similar underlying formals, because I don’t do under-the-hood binary-level subnetting, 
but rather only face-value hex subnetting.

Aaron

> On Sep 15, 2025, at 2:17 PM, Christopher Morrow via NANOG <nanog () lists nanog org> wrote:
>
> =TEXT(BITAND(A1,4278190080)/16777216,"0")&"."&TEXT(BITAND(A1,16711680)/65536,"0")&"."&TEXT(BITAND(A1,65280)/256,"0")&"."&TEXT(BITAND(A1,255),"0")
>
> apparnetly is inet_ntoa maybe? :)
>
> > On Mon, Sep 15, 2025 at 2:52 PM Tom Beecher via NANOG
> > <nanog () lists nanog org> wrote:
> >
> > If you had to in GSheets, I would just recreate inet_aton and inet_ntoa in
> > Apps Script. It's just bit shifts and ORs, shouldnt be hard.
> >
> > On Mon, Sep 15, 2025 at 2:31 PM Bryan Fields via NANOG <
> > nanog () lists nanog org> 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 :-)
> > >
> > > --
> > > Bryan Fields
> > >
> > > 727-409-1194 - Voice
> > > http://bryanfields.net
> > >
> > > _______________________________________________
> > > NANOG mailing list
> > >
> > > https://lists.nanog.org/archives/list/nanog () lists nanog org/message/VDO2LGNHKC3XXZQEL2ATCRELA6RUFY5H/
> > _______________________________________________
> > NANOG mailing list
> > https://lists.nanog.org/archives/list/nanog () lists nanog org/message/D7ZEVMHZ77EJIVKUGVA26CRYQLW3J3PE/
> _______________________________________________
> NANOG mailing list
> https://lists.nanog.org/archives/list/nanog () lists nanog org/message/D6EDM4QAZJSGASO3FNT7OC33ZGLEKCMV/

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