How to import/export Android string resource to Excel for localization?

Question

I use Android Studio in app development. I want to translate strings by exporting/importing the Android language resources (strings.xml) to Excel file (xlsx). What is the best way to do it?

Answer 1

If anyone else needed the answer,

from res -> strings -> right click-> Open Translations Editor. Select data/variable you need then copy and paste data from Translations Editor to excel . done.

Answer 2

Since CTRL+A not working now in the android studio. There is one way to convert the android strings file to CSV and then translate it with the help of google translator and then again convert back to XML.

https://www.skydevelopers.net/blog/2-best-ways-to-translate-the-android-strings-file/

here is a blog in detail

Answer 3

As many others pointed out, pressing Ctrl+A in the Translations Editor doesn't work since Android Studio 3.2

I work for a company that outsources translations constantly, so we need to convert android strings to and from xls files. The only solution that worked for us reliably is this fork of the older android-lang-tool. Just build with maven and run the jar.

It exports strings, string-arrays, plurals and their key-values to an xls file. It even exports the comments.

Answer 4

1. Export Strings resource file to csv
2. Get its content translated(probably from google translate)
3. convert back the Translated file to Strings.xml(android string resource file)

I used http://convertcsv.com/csv-to-xml.htm this website for converting csv file to strings resource file

need to mention Custom output template to convert it to strings resource file

<string name="{f1}">{f2}</string>

put this in template section provided

website also displays the desired converted output file