Help center

Hanzi to Pinyin Support

Instructions and troubleshooting for the Hanzi to Pinyin add-on for Google Sheets.

Quick start

1. Open a Google Sheet containing Chinese text.
2. Use the Hanzi to Pinyin menu to open Settings or convert a selected range.
3. Alternatively, enter a PINYIN formula in an empty cell.
4. Review the generated Pinyin before using it in published or graded materials.

Formula examples

Convert one cell

=PINYIN(A2)

Convert a range

=PINYIN(A2:A15)

Choose an output style

• =PINYIN(A2, "marks") → nǐ hǎo
• =PINYIN(A2, "numbers") → ni3 hao3
• =PINYIN(A2, "none") → ni hao

Choose capitalization

=PINYIN(A2, "marks", "original") preserves the capitalization supplied by the romanization service. The default is lowercase.

Convert selected cells

1. Select one or more cells containing Chinese text.
2. Open Hanzi to Pinyin from the spreadsheet menu.
3. Choose Convert selection using settings or select a specific tone style.
4. The add-on writes plain-text results into the same-sized area immediately to the right.

Settings

Open Hanzi to Pinyin → Settings to choose:

• Tone marks, tone numbers, or no tones.
• Lowercase or original capitalization.
• Whether the add-on warns before overwriting destination cells.

Settings are saved separately for each Google user.

Troubleshooting

The menu does not appear

Refresh the spreadsheet. If the add-on was just installed, close and reopen the Sheet. Also confirm that the add-on is installed for the Google account currently active in Sheets.

Google asks for authorization

The add-on needs authorization to work with the active spreadsheet, remember preferences, and request romanization. Review Google’s permission screen and continue only if you are comfortable granting the listed access.

The formula is slow

Large ranges require network processing. Use one range formula, such as =PINYIN(A2:A50), instead of many separate formulas where practical. Recently converted results may be temporarily cached.

A result looks incorrect

Some Chinese characters have multiple context-dependent readings. Check names, specialized vocabulary, and ambiguous phrases against a trusted dictionary or instructor, then correct the cell manually if needed.

An API or parsing error appears

Wait briefly and try again. Temporary service limits, connectivity problems, or changes to the Google-hosted romanization response can interrupt conversion. If the issue continues, include the exact error message when requesting support—but do not send confidential spreadsheet content.

Privacy and safe use

The text you choose to convert is sent to a Google-hosted romanization service. Review the Privacy Policy for details, and avoid submitting confidential or highly sensitive information unless you are authorized to have Google process it.