How do I convert a 15 to 18 digit Salesforce ID?

Create a text formula field on the object with the formula CASESAFEID(Id). In Apex, assign the 15-character string to an Id variable and use String.valueOf(). In Excel or Google Sheets, use the checksum formula shown above or an add-in.

What is the difference between a 15 and 18 digit Salesforce ID?

The 15-digit ID is case-sensitive, while the 18-digit ID adds a three-character checksum suffix that makes it case-insensitive. Both point to the same record. Use the 18-digit version in Excel, integrations and any tool that ignores letter case.

How do I convert an 18 digit Salesforce ID to 15 digits?

Keep the first 15 characters. Use LEFT(CASESAFEID(Id), 15) in a formula, =LEFT(A2,15) in Excel, or Id.to15() in Apex. Do not paste the short form into a case-insensitive tool, because two records can then look identical.

Why does VLOOKUP return the wrong record with 15 digit Salesforce IDs?

VLOOKUP ignores upper and lower case, so two different 15-digit IDs that differ only by case look the same to it. Convert both lists to 18-digit IDs before matching. The three suffix characters keep each ID unique.

How do I convert the Salesforce org ID from 15 to 18 digits?

Treat it like any record ID: apply the same checksum to the 15-character 00D value, or call UserInfo.getOrganizationId() in Apex, which returns the 18-character form. See how to find your org ID .

Do reports show 15 or 18 digit Salesforce IDs?

Standard report columns usually show the 15-character ID, while the API and Data Loader return 18 characters. To get 18 digits in a report, add a CASESAFEID(Id) formula field to the object and include it as a column.

15 to 18 Digit Salesforce ID: Convert with CASESAFEID

To convert a 15 to 18 digit Salesforce ID, create a formula field on the object with the formula CASESAFEID(Id). The difference between a 15 and 18 digit record ID is only a three-character suffix, and this formula returns the 18-character version for every record, so you can reuse the field in reports, exports and list views.

The 15 to 18 digit Salesforce ID conversion matters because the two formats are not the same string. The 15-digit ID is case-sensitive, so 001D000000IqhSL and 001d000000iqhsl point to different records. The 18-digit ID adds three characters that make it safe to compare in tools that ignore case, such as Excel.

In this tutorial, I will explain the difference between the two formats, then show every way to convert them: a formula field, Apex, Excel and Google Sheets, plus the checksum behind the extra three characters. We will also cover going back from 18 to 15 digits, the org ID, and the report and Data Loader pitfalls that trip people up.

This Tutorial Covers: