+ Start a Discussion
miko Leemiko Lee 

How to retrieve the translations text of multiple language that exiting from custom labels and put the translation text in excel???

Hi guys,

I have some problem in retrieve translation text and put in excel file. I got a list of Custom Label Name in excel file that need to be translate to multiple language (PS: I got hundred plus of custom label need to be translate in 10 languages). I do not want to open each of the custom label then copy and paste the translation text in the excel file. It there any way for me to code it out and then add the translation in the excel filer?

Thank you for advance .

Best Answer chosen by miko Lee
Karan Shekhar KaulKaran Shekhar Kaul
Hi Miko,

Follow below steps.

1) Open .stf file in notepad.
2) Copy & paste all text in excel file.
3) You will get two columns in excel, Key & label.
4) Use text to column feature under Data menu of excel.
5) Use delimter as "." & convert it to columns,
6) This will result in 3 columns
7) Now, put a filter on first column & select custom label.

Voilà you have custom label translations now. If you want, I can help you with excel. Send that .stf file over.

All Answers

Karan Shekhar KaulKaran Shekhar Kaul

Hi Miko,
If I am not wrong, you are looking for functionality to import & export translations, right? 

If yes, you can export & import translations in bulk using below feature. Works based on .stf file. 

https://help.salesforce.com/articleView?id=workbench_export.htm&type=0

Hope this helps.

Regards,

Karan

miko Leemiko Lee

Hi Karen,

For example this is the only selected custom labels that I want to get translation. Then I got use the link that u shared for me but that one is retrieve all source. If there anyway for me just want to export selected custom label only? And how to open .stf file in MS Excel?

User-added image

Thanks.

Karan Shekhar KaulKaran Shekhar Kaul
Hi Miko,

Follow below steps.

1) Open .stf file in notepad.
2) Copy & paste all text in excel file.
3) You will get two columns in excel, Key & label.
4) Use text to column feature under Data menu of excel.
5) Use delimter as "." & convert it to columns,
6) This will result in 3 columns
7) Now, put a filter on first column & select custom label.

Voilà you have custom label translations now. If you want, I can help you with excel. Send that .stf file over.
This was selected as the best answer
miko Leemiko Lee

Hi Karen,

Is ok. Thank for ur step by step explanation. I know how to do already.