IP calculator for Excel, LibreOffice and Google Sheets

online tools

IPv4

sort IP addresses sort networks and IP addresses
find opverlapping networks summarize networks or routes
divide network in smaller subnets - try this on the first line: 10.0.0.0/24, 2
convert IP range to 1 or more CIDR networks - try this : 10.0.0.1, 10.0.0.254

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: January 7th, 2017 ] [ contact: ipcalc(a)rohmer.fr ]