Manage multiple languages using Google Spreadsheets

Nowadays, developing mobile apps that come with multiple languages is common. To support different languages in Android, the standard way is to create separate strings.xml files for each language.

1
res/
2
    values/
3
        strings.xml     # English
4
    values-fr/
5
        strings.xml     # French
6
    values-es/
7
        strings.xml     # Spain

If there is a request to replace a wording in the app that was different from the design. It will take time for developers to search and change the text, which may take 5 to 10 minutes for this simple work. Because no one can read the code but only the developer.

Solution

Google Spreadsheets is the platform that anyone can use, therefore the whole team can manage and make changes to this.

• Developers will refer to key strings column
• Others such as content editors or translators can modify the content in language columns

Then it can be exported to separate XML files by writing a script for this automatic job. Now, anyone can manage the app content in a single place.

Export Spreadsheets to XML

We can write the script to export it in any language. In this example, I use python and pygsheets, since it comes with a suitable way to achieve this.

1
import pygsheets
2
import xml.etree.ElementTree as ET
3
import xml.dom.minidom as minidom
4

5
# Replace your google spreadsheet url
6
spreadsheets_url = "https://docs.google.com/spreadsheets/d/1tPFOoIlY9II-di66tmyzYdcUM_5o_NpNIVdAfnYzCLU"
7
# Replace your google authorization credentials
8
credentials = "client_secret_770262086400-rmu5819knvu2rasoe9acp8elcodih4ce.apps.googleusercontent.com.json"
9

10
gc = pygsheets.authorize(credentials)
11
sh = gc.open_by_url(spreadsheets_url)
12
wks = sh.sheet1
13

14

15
def export(language_column, file_name):
16
    root = ET.Element("resources")
17
    for idx, row in enumerate(wks):
18
        if idx < 2:  # skip two rows on header
19
            continue
20
        ET.SubElement(root, "string", name=row[0]).text = row[language_column]
21
    xmlstr = minidom.parseString(ET.tostring(root)).toprettyxml(indent="    ", newl="\n", encoding="utf-8")
22
    with open(file_name, "w") as f:
23
        f.write(xmlstr)
24

25

26
export(1, "en.xml")
27
export(2, "fr.xml")
28
export(3, "es.xml")

How to use

• This was scripted with python 2.7, and requiring to install pygsheets
• Follow this instruction to get authorization credentials to make Google APIs requests
• Place the credentials in the same folder with exporter.py
• Execute the command from the terminal

1
python exporter.py

If this is the first time, the permission request will appear, and we need to grant it.

Result

As a result, it will generate 3 XML files en.xml, fr.xml, es.xml that declared in the sheet. Then developers just overwrite the new files in their project.

1
<?xml version="1.0" encoding="utf-8"?>
2
<resources>
3
    <string name="discover_people">Discover People</string>
4
    <string name="free_basics">Free Basics</string>
5
    <string name="find_friends">Find Friends</string>
6
    <string name="events">Events</string>
7
    <!-- ... -->
8
</resources>