Automate Google Sheets to strings.xml for localization

Question

I have a Google Sheets of the translations of all my strings.xml resources. Each language is a column. And the first column is the string resource ID.

Do you know of a tool that I can use to (or a macro or anything) that will let me re-export my spreadsheet into a strings.xml format with the appropriate territory suffix? (The suffixes are the first row of the spreadsheet.)

Answer 1

Use the formula =CONCATENATE("<string name=",char(34),A2,char(34),">",E2,"</string>") where A2 is the resource ID and E2 is the language you have translated

Copy the column and paste it inside your <resources>_</resources> tag