home Homebuild Toolsbug_report Errorsmenu_book Guideslightbulb Tipssmart_toy Promptsextension Extensionsfolder_open Resourcesinfo About
search
swap_horiz ID Converter

              
            

Quick Single Convert

How Salesforce IDs Work

Salesforce uses two ID formats: a 15-character case-sensitive format and an 18-character case-insensitive format. The 18-character version appends a 3-character checksum suffix to make the ID safe for use in systems that don't preserve case (like Excel or some databases).

0015000000Gf1AB
15-Character (Case-Sensitive)
0015000000Gf1ABAAE
18-Character (Case-Insensitive)
lightbulb

Tip: Always use 18-character IDs in formulas, reports, data migrations, and external integrations to avoid case-sensitivity bugs.

Conversion Algorithm

looks_one

Split into chunks

Divide the 15-char ID into three 5-character chunks.

looks_two

Map uppercase chars

For each chunk, build a 5-bit number where uppercase = 1, other = 0.

looks_3

Append suffix

Map each 5-bit number to a character (A-Z, 0-5) and append all three.