Skip to content

Salesforce ID Converter

Convert 15-character IDs to 18-character case-safe IDs, one at a time or in bulk.

Runs in your browser. Nothing is uploaded.

Salesforce IDs

1 ID

15 or 18 characters, letters and numbers only. Separate several IDs with new lines, commas or spaces. Results update as you type.

Example input

Result

18-character ID

001A0000006Vm9rIAC

Converted
Detected format
15-character ID. Converted from 15 to 18 characters.
15-character ID
001A0000006Vm9r
Key prefix
001 is the standard prefix for Account.

How the last three characters are calculated

001A0

01000 = 8I

00000

00000 = 0A

6Vm9r

00010 = 2C

A well-formed ID is not proof that a record exists. Only Salesforce can tell you whether an ID belongs to a real record in your org.

How to use the Salesforce ID Converter

  1. Paste one Salesforce ID, or a whole column of IDs, into the input. Separate IDs with new lines, commas or spaces.
  2. Read the result. It updates as you type and shows the 18-character and 15-character form of every ID.
  3. Copy a single ID, copy the full list of 18-character IDs, or download the results as a CSV file.

Why Salesforce IDs come in two lengths

A Salesforce record ID is case-sensitive in its 15-character form: 001A0000006Vm9r and 001a0000006vm9r identify different records. Many tools, including spreadsheets and some databases, compare text without regard to case, which makes distinct IDs look identical. The 18-character form solves this by adding three characters that record which letters are uppercase. It is safe to use anywhere.

How the 15 to 18 character conversion works

  1. Split the 15 characters into three groups of five.
  2. For each group, note which positions hold an uppercase letter.
  3. Treat those positions as a 5-bit number, with the first character as the lowest bit.
  4. Map the number (0 to 31) to one character of ABCDEFGHIJKLMNOPQRSTUVWXYZ012345.
  5. Append the three characters to the ID.

For 001A0000006Vm9r, the groups 001A0, 00000 and 6Vm9r give 8, 0 and 2, which map to I, A and C. The 18-character ID is 001A0000006Vm9rIAC. Enter a single ID above to see this breakdown for your own ID.

When you need 18 characters

  • Matching records in Excel or Google Sheets with VLOOKUP, XLOOKUP or MATCH.
  • Loading data with tools that compare IDs case-insensitively.
  • Storing Salesforce IDs in an external database or data warehouse.
  • Comparing an ID from a report or URL (often 15 characters) with one from the API (always 18).

Example

Example
Input (15)    001A0000006Vm9r
Output (18)   001A0000006Vm9rIAC

Input (18, casing lost)   001A0000006VM9RIAC
Restored                  001A0000006Vm9rIAC

Getting 18-character IDs inside Salesforce

In a formula field, CASESAFEID(Id) returns the 18-character ID, which is useful in reports. In Apex, an Id value converted with String.valueOf is 18 characters long. Data Loader and the REST and SOAP APIs always return 18 characters.

Features and limitations

What it does

  • Converts 15-character IDs to 18-character case-safe IDs using Salesforce’s checksum algorithm.
  • Detects the format automatically: 15 characters are converted, 18 characters are verified.
  • Shows the 15-character form of any 18-character ID.
  • Restores letter casing from the suffix when an 18-character ID was upper-cased or lower-cased.
  • Batch mode: paste thousands of IDs at once, then copy or download the results.
  • Names the object for well-known key prefixes, such as 001 for Account.

What it does not do

  • It cannot tell you whether a record exists. A correctly formed ID is only a correctly formed ID.
  • It does not connect to Salesforce, so it cannot look up record names, owners or the org an ID belongs to.
  • Key prefixes of custom objects differ in every org and are not identified.
  • A 15-character ID whose casing has already been lost cannot be repaired, because the casing is the missing information.

Questions about the Salesforce ID Converter

No. It is the same record ID with a three-character checksum added. Salesforce accepts either form anywhere an ID is expected.

Yes. The 15-character ID is simply the first 15 characters of the 18-character ID. The converter shows both.

The last three characters of an 18-character ID describe which letters are uppercase. If a spreadsheet or another system changed the casing, the converter uses the suffix to put it back.

No. The checksum only describes letter casing. Whether a record with that ID exists, and in which org, can only be checked in Salesforce.

There is no fixed limit. Conversion happens on your device, and tens of thousands of IDs take well under a second on a typical laptop. The on-screen table shows the first 300 rows; copy and download include every row.

No. The conversion is a small calculation that runs in your browser. Nothing you paste leaves your device.