Why does Salesforce have 15-character and 18-character IDs?

The 15-character ID is case-sensitive and used internally in Salesforce. The 18-character ID appends a 3-character case-insensitive checksum suffix so that spreadsheet programs like Excel and database integrations do not confuse records.

Why do 15-character IDs fail in Microsoft Excel VLOOKUP?

Microsoft Excel is strictly case-insensitive in lookup functions. If two Salesforce IDs differ only by capitalization, Excel will mistakenly match the first row it encounters, corrupting your CRM data.

How does the 15-to-18 conversion algorithm work?

The algorithm divides the 15 characters into three blocks of 5 characters. Each uppercase letter generates a binary 1, and each lowercase letter generates a binary 0. The resulting 5-bit numbers are mapped to alphanumeric checksum characters.

Can I convert 10,000+ Salesforce IDs at once?

Yes. This tool processes up to 10,000 IDs client-side in seconds with zero rate limits or file uploads.

Salesforce 15 to 18 ID Converter — Free Bulk SFID Tool

15-Character Salesforce IDs (One per line)

Step-by-Step Instructions

How to Convert 15 to 18 Character Salesforce IDs

1

Copy 15-char IDs

Copy your column of Salesforce Lead, Contact, or Account record IDs from reports, DataLoader, or spreadsheets.

2

Paste & Convert

Paste them into the box and click "Convert to 18-Character IDs". The checksums are generated client-side in milliseconds.

3

Copy or Download

Copy the case-safe 18-character IDs to your clipboard or download clean results ready for Excel VLOOKUP.

Why 15-Character Salesforce IDs Break Excel & How the Checksum Works

Salesforce record IDs are base-62 identifiers consisting of numbers (0-9), lowercase letters (a-z), and uppercase letters (A-Z). Because Salesforce is case-sensitive, two distinct records can have the exact same sequence of characters in different capitalization:

The Case-Sensitivity Trap

Excel VLOOKUP Corruption

Microsoft Excel and Google Sheets do not distinguish uppercase from lowercase in formulas. Matching 15-character IDs causes Excel to misidentify records, attaching opportunities to the wrong accounts.

The Solution

18-Character Case-Safe IDs

The 18-character ID appends a 3-character suffix representing the capitalization bitmap of the original 15 characters. Even if Excel converts the string to all lowercase, the 3-letter suffix preserves uniqueness.

Frequently Asked Questions

What happens if I paste an already converted 18-character ID? ▼

The tool automatically validates ID lengths. If a line is already 18 characters, it remains untouched, ensuring your dataset is not corrupted.

Can I use this for Salesforce Data Loader imports? ▼

Yes! Salesforce Data Loader, Workbench, MuleSoft, and third-party ETL tools all natively accept 18-character IDs, making them the safest choice for bulk upserts.

Is this tool secure for enterprise CRM data? ▼

100% secure. Conversion runs purely in your browser's JavaScript engine. None of your Salesforce record IDs are sent to external servers or logged anywhere.

Technical Guide

Salesforce 15 vs 18 Character IDs

Read our complete technical breakdown of why case sensitivity breaks Excel VLOOKUPs and how the checksum algorithm works.

Read Full Guide →

SALESFORCE ARCHITECTURE SERVICES

Fix Salesforce Data Chaos for Good

Enrichverx designs custom Salesforce pipelines that automatically deduplicate records, enrich missing buyer data, and track champion job changes.

Salesforce Services arrow_forward Free Salesforce Audit