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/VDO2LGNH...