Re: IP Address support in spreadsheets?

[borg--- via NANOG <nanog () lists nanog org>]

Well. Im using .txt files for years to handle network stuff.
So, I will ask question.. How much addresses you need to keep track of?

Im small shop, but if you scale is not big I can hand you my tools ;)

% blgrep -c -a - hosts.txt
+ Sum (Aggregated)
Count: 5313

Pros of .txt files. VCS (SVN or GIT) friendly. You can have history,
generate diffs :) They will run anywhere.

Cons: well, its CLI and some people are alergic to it..

Regards,
Borg


---------- Original message ----------

From: Bryan Fields via NANOG <nanog () lists nanog org>
To: nanog () lists nanog org
Cc: Bryan Fields <Bryan () bryanfields net>
Subject: IP Address support in spreadsheets?
Date: Mon, 15 Sep 2025 14:30:52 -0400

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