IP calculator for Excel, LibreOffice and Google Sheets

online tools


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:, 2
convert IP range to 1 or more CIDR networks - try this :,


sort IPv6 addresses expand IPv6 addresses shorten IPv6 addresses

valid IPv4 networks are:

a valid IPv4 route is a network followed by any character sequence such as a next hop or route parameters
some valid routes: anything here is fine
[ >> ip-calc home ] [ last update: January 7th, 2017 ] [ contact: ipcalc(a)rohmer.fr ]