IP calculator for Excel, LibreOffice and Google Sheets

online tools

IPv4

sort IP addresses sort networks and IP addresses
convert IP addresses to numbers convert numbers to IP addresses
find opverlapping networks summarize networks or routes
divide network in smaller subnets
convert IP range to 1 or more CIDR networks
subtract subnets to a list of networks

IPv6

sort IPv6 addresses expand IPv6 addresses shorten IPv6 addresses

valid IPv4 networks are:
10.0.0.0/24
10.0.0.0 255.255.255.0

a valid IPv4 route is a network followed by any character sequence such as a next hop or route parameters
some valid routes:
10.0.0.0/24 1.2.3.4
10.0.0.0 255.255.255.0 1.2.3.4
1.2.3.128/25 anything here is fine
[ >> ip-calc home ] [ last update: October 5th, 2017 ] [ contact: ipcalc(a)rohmer.fr ]