Re: IP Address support in spreadsheets?

[Laris Beņķis via NANOG <nanog () lists nanog org>]

I wrote a VB library years ago to manipulate IP addresses in Excel.  Its 
documented in the tabs.

I hope someone finds it useful

https://www.dropbox.com/scl/fi/yijxbrkdluuo64o4wf1nn/TOC-1.4.xlsm?rlkey=2bwpylnfguznkszkxapuhr0hw&st=7md5q0hb&dl=0

Laris


On 2025-09-15 4:36 p.m., Tom Beecher via NANOG wrote:
> This is absolutely sadistic.
>
> And also I think correct , lol
>
>
> On Mon, Sep 15, 2025 at 3:17 PM Christopher Morrow<morrowc.lists () gmail com>
> 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/MNPJNZVCFDKCEBCMQ3YR3WP55DMZDJ6N/
_______________________________________________
NANOG mailing list 
https://lists.nanog.org/archives/list/nanog () lists nanog org/message/UMOL2QVO6AR426GBAXR734PFH5YVGMYV/