Instantly convert case-sensitive 15-character Salesforce IDs to the case-insensitive 18-character format. Paste one ID or hundreds.
Salesforce originally used 15-character IDs — case-sensitive alphanumeric strings. When external tools (Excel, case-insensitive databases, ETL tools) couldn't reliably preserve case, IDs would be mismatched. The fix: a 3-character checksum appended to every ID that encodes the case of each letter, producing the 18-character case-insensitive format safe for any system.
Use 18-char IDs when working with the Salesforce REST/SOAP API, doing VLOOKUP or MATCH in Excel, loading data via Data Loader or MuleSoft, storing IDs in an external database with case-insensitive collation, or writing SOQL to prevent subtle case-mismatch bugs.
Each group of 5 characters is treated as a 5-bit number where uppercase = 1 and everything else = 0. That number indexes into the lookup string ABCDEFGHIJKLMNOPQRSTUVWXYZ012345. Three groups → three suffix characters.
No. All conversion runs in JavaScript in your browser. Your IDs never leave your device.
Yes — just take the first 15 characters of any 18-char ID. The tool detects 18-char input, validates the checksum, and returns it unchanged if correct.
The tool handles each line independently — 15-char IDs are converted, 18-char IDs are validated and passed through, invalid lengths are flagged with an error.
We specialise in Salesforce implementations, integrations, and AI-powered RevOps solutions.
Let's talk →