I recently blogged on how to convert Salesforce.com IDs using Apex and Visualforce, but as it turns out, many readers are more interested in actually converting IDs, and less interested in understanding how it works. ;)
So by popular demand, I've made a converter in Excel that takes your 15-character Salesforce.com IDs and converts them to the 18-character IDs.
Download the file, paste up to 25 15-character IDs at a time, and the sheet will give you the 18-character version using Salesforce's conversation algorithm.
It's protected (to avoid unintentionally overwriting a formula), but no password, so if you're Excel-savvy, feel free to pick it apart and modify it (for instance, if you want to do 5000 IDs at a time).
Enjoy - and click here to download.
Posts
