This extension also has google sheets and microsoft excel support, kinda
nice. http://trk.free.fr/ipcalc/
On 9/15/2025 5:29 PM, Trey Scarborough via NANOG wrote:
I do this a bunch for importing and exporting equipment in to
different systems. I have used the google ipfunctions, but I mainly
work in libre calc for that I used to have some of the functions
programed in a sheet then I found this and just added the macros
https://extensions.libreoffice.org/en/extensions/show/ip-calculator
On 9/15/25 1:30 PM, 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 :-)
_______________________________________________
NANOG mailing list
https://lists.nanog.org/archives/list/[email protected]/message/ZZQ6CQ7UIPZQLKNE6VBI3F56RNX3U2N5/
_______________________________________________
NANOG mailing list
https://lists.nanog.org/archives/list/[email protected]/message/5BTZL4XQTI3WVNFDOMPV2WZYDBM3TXHG/
