Create a localization file in Android or iOS format from a Google Spreadsheet
Switch branches/tags
Nothing to show
Latest commit d04b29c Nov 6, 2013 @xavierha fix json
Failed to load latest commit information.
core fix json Nov 6, 2013
node_modules - Replace ... with ellipsis in android transformer Jun 26, 2013
samples Modify dart & json transformers Nov 6, 2013
tests - Replace ... with ellipsis in android transformer Jun 26, 2013
.npmignore Doc improvement Mar 21, 2013
package.json fix json Nov 6, 2013

Convert a Google Spreadsheet to a localization file


npm install localize-with-spreadsheet


Given a Google Spreadsheet like this:
Spreadsheet example

The tool fetch the spreadsheet and write the result to a file in the Android or iOS format:

Result android Result iOS

Create a file update-localization.js

var Localize = require("localize-with-spreadsheet");
var transformer = Localize.fromGoogleSpreadsheet("0Aq6WlQdq71FydDZlaWdmMEUtc2tUb1k2cHRBS2hzd2c", '*');
transformer.setKeyCol('KEY');"values/strings.xml", { valueCol: "NL", format: "android" });"values-fr/strings.xml", { valueCol: "FR", format: "android" });"nl.lproj/Localizable.strings", { valueCol: "NL", format: "ios" });"fr.lproj/Localizable.strings", { valueCol: "FR", format: "ios" });

Run it with

node update-localization.js


You can filter the worksheets to include with the second parameter of 'fromGoogleSpreadsheet' Ex:

Localize.fromGoogleSpreadsheet("<Key>", '*');
Localize.fromGoogleSpreadsheet("<Key>", ['HomeScreen, 'ContactScreen']);
Localize.fromGoogleSpreadsheet("<Key>", [0, 2]);


  • The script will preserve everything that is above the tags: < !-- AUTO-GENERATED --> or // AUTO-GENERATED
  • Your spreadsheet should be "Published" for this to work
  • You need to have git installed for the installation