Convert Salesforce Ids between 15 and 18 digit Ids
Listing updated:ā§¨ā§Š āϜ⧁āϞāĻžāχ, ⧍ā§Ļā§¨ā§Š
Works with:
No reviews
⧧⧝⧧
āĻāĻ• āύāϜāϰ⧇
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
PricingāĻĢā§āϰāĻŋ
Developer
āύāύ-āĻŸā§āϰ⧇āĻĄāĻžāϰ
āĻ—ā§‹āĻĒāĻ¨ā§€ā§ŸāϤāĻž āύ⧀āϤāĻŋ
āĻĒāϰāĻŋāώ⧇āĻŦāĻžāϰ āĻļāĻ°ā§āϤāĻžāĻĻāĻŋ
āϰāĻŋāĻĒā§‹āĻ°ā§āϟ āĻ•āϰ⧁āύFlag as inappropriate
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 :
āφāĻĒāύāĻžāϰ āϏāĻŦ Google Sheets āĻ¸ā§āĻĒā§āϰ⧇āĻĄāĻļāĻŋāϟ āĻĻ⧇āϖ⧇, āĻāĻĄāĻŋāϟ āĻ•āϰ⧇, āϤ⧈āϰāĻŋ āĻ•āϰ⧇ āĻāĻŦāĻ‚ āĻŽā§āϛ⧇ āĻĻā§‡ā§Ÿ
Google āĻāϰ āĻ…ā§āϝāĻžāĻĒā§āϞāĻŋāϕ⧇āĻļāύ⧇āϰ āĻĒā§āϰāĻŽā§āĻĒāϟ āĻāĻŦāĻ‚ āϏāĻžāχāĻĄāĻŦāĻžāϰ⧇ āϤ⧃āĻ¤ā§€ā§Ÿ āĻĒāĻ•ā§āώ⧇āϰ āĻ“ā§Ÿā§‡āĻŦ āĻ•āĻ¨ā§āĻŸā§‡āĻ¨ā§āϟ āĻĻ⧇āĻ–āĻžā§Ÿ āĻāĻŦāĻ‚ āϚāĻžāϞāĻžā§Ÿ
āφāĻĒāύāĻžāϰ āĻĒā§āϰāĻžāĻĨāĻŽāĻŋāĻ• āχāĻŽā§‡āϞ āφāχāĻĄāĻŋ āĻĻ⧇āϖ⧁āύ
āφāĻĒāύāĻŋ āϏāĻ°ā§āĻŦāϜāύ⧀āύāĻ­āĻžāĻŦ⧇ āωāĻĒāϞāĻ­ā§āϝ āĻ•āϰ⧇āϛ⧇āύ āĻāĻŽāύ āϝ⧇āϕ⧋āύāĻ“ āĻŦā§āϝāĻ•ā§āϤāĻŋāĻ—āϤ āϤāĻĨā§āϝ āϏāĻš āφāĻĒāύāĻžāϰ āĻŦā§āϝāĻ•ā§āϤāĻŋāĻ—āϤ āϤāĻĨā§āϝ āĻĻ⧇āϖ⧇
āϰāĻŋāĻ­āĻŋāω
Language:
āĻāχ āĻ…āύ⧁āϝāĻžā§Ÿā§€ āϏāĻžāϜāĻžāύ:
Google āϰāĻŋāĻ­āĻŋāω āĻ“ āϰ⧇āϟāĻŋāĻ‚ āϝāĻžāϚāĻžāχ āĻ•āϰ⧇ āύāĻžāĨ¤ āϰāĻŋāĻ­āĻŋāω āϏāĻŽā§āĻĒāĻ°ā§āϕ⧇ āφāϰāĻ“ āϜāĻžāύ⧁āύ
No comments
āϏāĻžāĻ°ā§āϚ āĻ•āϰ⧁āύ
āϏāĻžāĻ°ā§āϚ āĻŽā§āϛ⧁āύ
āϏāĻžāĻ°ā§āϚ āĻŦāĻ¨ā§āϧ āĻ•āϰ⧁āύ
Google āĻ…ā§āϝāĻžāĻĒā§āϞāĻŋāϕ⧇āĻļāĻžāύāϗ⧁āϞāĻŋ
āĻĒā§āϰāϧāĻžāύ āĻŽā§‡āύ⧁