Re: IP Address support in spreadsheets?

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

As someone doing it in practice, I just drag and drop 255 rows for the
IPs.  It's not that big of a deal.  One time I had to do a whole 2048 rows
and it probably took me a minute.

On Mon, Sep 15, 2025 at 3:29 PM Brian Knight via NANOG <
nanog () lists nanog org> wrote:

> On 2025-09-15 13:30, 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 :-)
>
> If you're not allergic to MS Excel, you could use Python for Excel to
> convert back and forth with the excellent ipaddress module.
>
> https://www.google.com/?q=google%20sheets%20ip%20functions turned up an
> interesting add-on, have you looked into IP Functions at all?
>
> Could also just roll your own inet_aton() in your columns for the dotted
> quads using LEFT(), MID(), RIGHT(), and FIND().
>
> Or just spin up Netbox and load your prefixes into that and be done.
>
> -Brian
> _______________________________________________
> NANOG mailing list
>
> https://lists.nanog.org/archives/list/nanog () lists nanog org/message/QIZBM4KIRQRM22MRRZB2XXZMPX7JQB2Z/
_______________________________________________
NANOG mailing list 
https://lists.nanog.org/archives/list/nanog () lists nanog org/message/ZRQN2X6TX77BE4RGUTXHZSNNB4YQN6YU/