Create an excel file with i18n key and value. Then in the next cell apply the concatenate formula to create the i18 XML element from given key and value. Below is the concatenate formula.
=CONCATENATE("<",A2," jcr:primaryType=","""","sling:MessageEntry",""""," sling:key=","""",A2,""""," sling:message=","""",B2,"""","/>")
After applying the formula you will get the xml element as below. Now just copy and paste these elements in your i18n language.xml file.
<userName jcr:primaryType="sling:MessageEntry" sling:key="userName" sling:message="Rashid"/> |