Salesforce Dictionary - Free Salesforce GlossarySalesforce Dictionary
Record IDs

Salesforce 15 to 18 Character ID Converter

Convert case-sensitive 15-character Salesforce record IDs to their case-safe 18-character form, in bulk. Paste one ID per line.

15-char IDs (one per line)

18-char IDs

Output appears here.

Related dictionary terms

§

About this tool

Salesforce shows 15-character record IDs in the UI and the URL bar, but those IDs are case-sensitive, so they break the moment a system lowercases them (Excel, a CSV import, a case-insensitive database). The 18-character ID appends a 3-character checksum suffix that makes the ID safe to compare without worrying about case. Paste a list of 15-character IDs, one per line, and this tool returns the 18-character equivalent for each, ready to drop into a data load or a script.

How it works

For each 15-character ID the tool splits the value into three 5-character chunks. Within each chunk it walks the characters and sets a bit for every position that is an uppercase A to Z, producing a number from 0 to 31. That number indexes into the alphabet "ABCDEFGHIJKLMNOPQRSTUVWXYZ012345" to pick one suffix character per chunk, and the three suffix characters are appended to the original 15 to make 18. IDs that are already 18 characters are passed through untouched and blank lines are skipped, so you can paste a mixed column straight from a spreadsheet.

When to use it
  • Normalising a column of 15-character IDs exported to Excel before a Data Loader upsert, so VLOOKUPs and dedupe keys stop missing case-variant matches.
  • Turning an ID copied from the Salesforce URL bar into the 18-character form an external system or webhook expects.
  • Cleaning a batch of IDs pulled from a debug log or a colleague's message before pasting them into a SOQL IN clause.
§

Frequently asked questions

Why does the 18-character ID matter if both point to the same record?
They reference the same record, but the 15-character form is case-sensitive. Any tool that treats text as case-insensitive (Excel, many databases, some CSV pipelines) can collapse two different IDs into one or fail to match. The 18-character form is safe to compare as plain text.
Can I paste IDs that are already 18 characters?
Yes. Anything already 18 characters is returned unchanged, so you can paste a mixed list of 15- and 18-character IDs and get a clean 18-character column back.
Does the conversion ever call Salesforce?
No. The checksum is computed entirely in your browser from the ID itself, so nothing is sent anywhere and it works offline.