Re: IP Address support in spreadsheets?

[Josh Luthman via NANOG <nanog () lists nanog org>]

Yes.  Some /20 and /24 subnets in Spreadsheet.  Not that it's great but
it's worked for ~18+ years.

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/RSAUPSVX6UFXQUMUAXRAYWP7QWZMVWWM/