localize-with-spreadsheet - GitLite

KO | EN

gitlite — search

#javascript #python #hacktoberfest #react #typescript #llm #go #android #deep-learning #java #kubernetes #pytorch #ios #mcp

localize-with-spreadsheet

(★ 127)

Create a localization file in Android or iOS format from a Google Spreadsheet

File Explorer

Download Latest Version (.zip)

- Line.js
- LineReader.js
- Transformer.js
- Writer.js
- result-android.png
- result-ios.png
- spreadsheet-example.png
- - nodeunit
  - nodeunit.cmd
- - index.js
  - package.json
  - README.md
  - UNLICENSE
- - .npmignore
  - COPYING.MIT
  - index.js
  - package.json
  - README
  - tags
- - .npmignore
  - LICENSE
  - mkpath.js
  - package.json
  - README.md
- - .npmignore
  - CONTRIBUTORS.md
  - index.js
  - LICENSE
  - Makefile
  - nodelint.cfg
  - package.json
  - README.md
- - LICENSE
  - package.json
  - q.js
  - queue.js
  - README.md
- - ios-fr.txt
  - ios-nl.txt
  - strings.xml
- - strings-fr.xml
  - strings.xml
- - strings.xml
- example1.js
- example2.js
- example3.js
- all.js
- AndroidTransformerTests.js
- GSReaderTests.js
- iOSTransformerTests.js
- LineTests.js
- WriterTests.js
.gitignore
.npmignore
index.js
package.json
README.md

# Installation Guide

1. Get the code

git clone https://github.com/xvrh/localize-with-spreadsheet

Downloads the entire project code from GitHub to your computer.

cd localize-with-spreadsheet

Moves into the project folder you just downloaded.

2. Node.js

Easy Recommended

Prerequisites

Git Needed to download the project code from GitHub.
Node.js Node.js must be installed to use npm. The LTS version is recommended.

npm install localize-with-spreadsheet

Downloads and installs the libraries listed in package.json.

✅ After running the command, open the address shown in the terminal (usually something like http://localhost:3000) in your browser.

Pulled directly from this repo's README.

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# Convert a Google Spreadsheet to a localization file

## Installation
	npm install localize-with-spreadsheet

## Example
Given a Google Spreadsheet like this:  
![Spreadsheet example](https://github.com/xavierha/localize-with-spreadsheet/raw/master/doc/spreadsheet-example.png)

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

![Result android](https://github.com/xavierha/localize-with-spreadsheet/raw/master/doc/result-android.png) ![Result iOS](https://github.com/xavierha/localize-with-spreadsheet/raw/master/doc/result-ios.png)

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