npm package discovery and stats viewer.

Discover Tips

  • General search

    [free text search, go nuts!]

  • Package details

    pkg:[package-name]

  • User packages

    @[username]

Sponsor

Optimize Toolset

I’ve always been into building performant and accessible sites, but lately I’ve been taking it extremely seriously. So much so that I’ve been building a tool to help me optimize and monitor the sites that I build to make sure that I’m making an attempt to offer the best experience to those who visit them. If you’re into performant, accessible and SEO friendly sites, you might like it too! You can check it out at Optimize Toolset.

About

Hi, 👋, I’m Ryan Hefner  and I built this site for me, and you! The goal of this site was to provide an easy way for me to check the stats on my npm packages, both for prioritizing issues and updates, and to give me a little kick in the pants to keep up on stuff.

As I was building it, I realized that I was actually using the tool to build the tool, and figured I might as well put this out there and hopefully others will find it to be a fast and useful way to search and browse npm packages as I have.

If you’re interested in other things I’m working on, follow me on Twitter or check out the open source projects I’ve been publishing on GitHub.

I am also working on a Twitter bot for this site to tweet the most popular, newest, random packages from npm. Please follow that account now and it will start sending out packages soon–ish.

Open Software & Tools

This site wouldn’t be possible without the immense generosity and tireless efforts from the people who make contributions to the world and share their work via open source initiatives. Thank you 🙏

© 2025 – Pkg Stats / Ryan Hefner

poxlsx

v0.0.1

Published

sync po files with google sheets

Downloads

7

Readme

poxlsx

NPM version NPM downloads

sync po files with google sheets

Install

yarn add poxlsx

Configuration

sample .poxlsxrc file

files:
  - language: fa
    po: fa.po
    xlsx: google://1ysPqvxVFJaRVSwPLwsj54xnGf5vULPQdVl7jf_qBWBo#fa
  - language: ar
    po: ar.po
    xlsx: google://1ysPqvxVFJaRVSwPLwsj54xnGf5vULPQdVl7jf_qBWBo#ar
key-file: key.json

files: an array of file config including

  • language: language code
  • po: po file path
  • xlsx: urls like google sheet id and sheet title
google://1ysPqvxVFJaRVSwPLwsj54xnGf5vULPQdVl7jf_qBWBo#ar
         |                              | ^^
         |                              | title
         ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
         file id from google sheet url:
         https://docs.google.com/spreadsheets/d/1ysPqvxVFJaRVSwPLwsj54xnGf5vULPQdVl7jf_qBWBo/edit

key-file: google service authentication key file. read more

Usage

sync po to google sheet

sync all po files to google sheet

poxlsx up

sync po file related to one language to google sheet

poxlsx up fa

options:

poxlsx up --help

  Description
    Sync po file to the google sheet

  Usage
    $ poxlsx up [language] [options]

  Options
    -c, --config-file    path to config file
    -k, --key-file       path to google key file
    -h, --help           Displays this message

sync google sheet to po

sync all google sheets to po files

poxlsx down

sync google sheet related to one language to po file

poxlsx down fa
sync down --help

  Description
    Sync google sheet to the po file

  Usage
    $ poxlsx down [language] [options]

  Options
    -c, --config-file    path to config file
    -k, --key-file       path to google key file
    -h, --help           Displays this message

help

poxlsx --help

Usage
$ poxlsx <command> [options]

Available Commands
help    Display help
up      Sync po file to the google sheet
down    Sync google sheet to the po file

For more info, run any command with the `--help` flag
$ poxlsx help --help
$ poxlsx up --help

Options
-c, --config-file    path to config file
-k, --key-file       path to google key file
-v, --version        Displays current version
-h, --help           Displays this message

google sheet columns

each google sheets has these columns (automatically added by poxlsx up)

| msgid | msgctxt | msgstr | po | | -------- | ------- | --------: | ------: | | Apple | | سیب | | | {n} days | | {n} روزها | {n} روز |

  • msgid: msgid from po file
  • msgctxt: msgctxt from po file if existed
  • msgstr: translations that should be applied to po file with poxlsx down command
  • po: translations from po file add with poxlsx up command if msgstr column and po file msgstr has a conflict