Convert Salesforce Ids between 15 and 18 digit Ids
Listing updated:July 23, 2023
Works with:
No reviews
117
Overview
Use this tool to convert salesforce Ids in Google Sheets™ to 15 or 18 digit Ids.  Salesforce has both case sensitive(15 digit) and case insensitive(18 digit) Ids.  It is common to have to convert between the two depending on how you are manipulating or importing the data. This tool will automatically detect the salesforce ID format and use the correct conversion strategy based on your output format selection. Instead of having to create a formula or copy and paste your data into another formatter, you can simply upload your file and the tool will do the conversion for you. 
            For those who don't know, a single salesforce Id has two versions, a 15 and an 18 digit version. When processing files in Google Sheets™, you normally want to use the 18 digit id so that vlookups and any other formulas that match text, matches correctly.  Normally Google Sheets™ does not distinguish between upper and lower cases so it can cause errors when matching.  Sometimes tools also want the 18 or 15 digit input and only accept that format (including Salesforce Analytics). 
Additional information
PricingFree of charge
Developer
Non-trader
Privacy policy
Terms of service
Salesforce Id Converter will ask for the permissions shown below. Learn more
Salesforce Id Converter will need access to your Google account
This will allow Salesforce Id Converter to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
No comments
Search
Clear search
Close search
Google apps
Main menu