Share your code. npm Orgs help your team discover, share, and reuse code. Create a free org »

    localize-with-spreadsheetpublic

    Convert a Google Spreadsheet to a localization file

    Installation

    npm install localize-with-spreadsheet
    

    Example

    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');
    
    transformer.save("values/strings.xml", { valueCol: "NL", format: "android" });
    transformer.save("values-fr/strings.xml", { valueCol: "FR", format: "android" });
    
    transformer.save("nl.lproj/Localizable.strings", { valueCol: "NL", format: "ios" });
    transformer.save("fr.lproj/Localizable.strings", { valueCol: "FR", format: "ios" });
    

    Run it with

    node update-localization.js
    

    Advanced

    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]);
    

    Notes

    • 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

    Keywords

    none

    install

    npm i localize-with-spreadsheet

    Downloadslast 7 days

    25

    version

    0.2.1

    license

    none

    repository

    github.com

    last publish

    collaborators

    • avatar