Simple Python scripts converting Android xml resources with translations to csv file and backwards

In international projects sometimes there's a need to send resource files to the client in order to have translated strings. Client doesn't have to understand XML notation and editing two or more files at the same time is inconvenient. It's easier to send file which can be edited in MS Excel or Libre Office Calc.

Scripts in this repository are able to convert Android xml resources to a single *.csv file ready to open in software for common users. In addition, there's another script, which can generate xml resource files from *.csv file. Scripts were tested on Linux (Ubuntu 14.04 LTS)

To satisfy requirements, run the following command:

$ pip install -r requirements.txt

$ ./xml2csv.py <directory_with_xml_files>

Example

$ ./xml2csv.py resources

Sample output

translations.csv

key strings_english.xml strings_polish.xml
hello_world Hello World!    Witaj Świecie!
app_name    My application  Moja aplikacja

Note: These "space" delimiters are fine and can be modified in the script. Nevertheless, Libre Office Calc reads it properly.

$ ./csv2xml.py <file_with_translations>.csv

Example

$ ./csv2xml.py translations.csv

Sample output

strings_english.xml

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<resources>
  <string name="hello_world">Hello World!</string>
  <string name="app_name">My application</string>
</resources>

strings_polish.xml

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<resources>
  <string name="hello_world">Witaj Świecie!</string>
  <string name="app_name">Moja aplikacja</string>
</resources>

• Scripts may bahave differently on MS Windows system and may need some adjustments
• Output of the scripts may be different on MS Windows system and may need some adjustments