IP Converter: IP to Decimal, Binary, Hex & Back

How to use this tool

1. Paste an IP address, a number or a link. The format is detected as you type.
2. Read every representation side by side, including octal and each octet in binary.
3. Convert a whole list at once, or copy the formula for Excel, SQL, Python or JavaScript.

Read the result

An IPv4 address contains 32 bits; an IPv6 address contains 128. Different text formats can represent the same value. Canonical IPv6 uses lowercase hexadecimal and compresses the longest run of zero groups, choosing the first run when lengths tie. Expanded form shows all eight groups. Decimal conversion uses exact integers rather than floating-point rounding. Conversion does not identify a device, locate an IP or make an IPv4-only connection support IPv6.

IP to decimal in Excel, SQL and code

The same conversion in tools you already use. Each example turns 192.168.1.1 into 3232235777 and back.

=SUMPRODUCT(--MID(SUBSTITUTE(A1,".",REPT(" ",99)),{1,100,199,298},99)*256^{3,2,1,0})

=SUMPRODUCT(SPLIT(A1,".")*256^{3,2,1,0})

SELECT INET_ATON('192.168.1.1'), INET_NTOA(3232235777);

SELECT '192.168.1.1'::inet - '0.0.0.0'::inet, '0.0.0.0'::inet + 3232235777;

import ipaddress
int(ipaddress.ip_address('192.168.1.1'))  # 3232235777
str(ipaddress.ip_address(3232235777))     # '192.168.1.1'

'192.168.1.1'.split('.').reduce((n, o) => n * 256 + Number(o), 0); // 3232235777
[24, 16, 8, 0].map(s => (3232235777 >>> s) & 255).join('.');      // '192.168.1.1'

Questions and answers

Other address tools