IP calculator for Excel, LibreOffice and Google Sheets

subnet calculator and IP address functions for your spreadsheet

free download:

ip-calc for LibreOffice
ip-calc for Microsoft Excel
ip-calc for Google Sheets
Online tools

March 15th, 2023 update : code optimisation for operations on large lists

what ip-calc can do:

- increment an IP address
- sort IP address or networks
- calculate a net mask or a wildcard (i.e. inverse mask)
- check if an address is in a subnet
- match an address against a list of subnets (similar to Excel VLOOKUP and MATCH functions)
- subnetting (divide a network)
- find overlapping subnets
- sort and summarize subnets or routes
- convert an IP range to a list of networks in CIDR notation
- subtract subnets from a list of larger subnets
- calculate the difference between 2 IP addresses
- calculate the size of a subnet
- check if an address is public or private
- IPv4 and IPv6 (not all functions are available for IPv6 yet)
+ provide a set of helper functions for IP address parsing so you can easily write your own macro

view source code: Visual Basic for Excel or LibreOffice, Google Sheets JavaScript

[ >> online tools ] [ >> français ] [ last update: June 25th, 2023 ] [ contact: ipcalc(a)rohmer.fr ]