For about 20 years, I’ve been using an Excel spreadsheet for IPv4 address documentation, even more, subnet calculations. Lately, I’ve been using it for IPv6 as well, kind of painful, but I can make it work. As mentioned, I actually have an in-line breakout section of binary to make the subnetting more visual and easier to track with applicable formulas in the cells to cause it to calculate the dotted decimal equivalent. My v6 spreadsheet doesn’t have similar underlying formals, because I don’t do under-the-hood binary-level subnetting, but rather only face-value hex subnetting. Aaron
On Sep 15, 2025, at 2:17 PM, Christopher Morrow via NANOG <nanog@lists.nanog.org> 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/VDO2LGNH...
_______________________________________________ NANOG mailing list https://lists.nanog.org/archives/list/nanog@lists.nanog.org/message/D7ZEVMHZ...
NANOG mailing list https://lists.nanog.org/archives/list/nanog@lists.nanog.org/message/D6EDM4QA...