Single Task Tools

Spell Numbers: Amount in Words for Invoices

This add-on writes numbers as words in Google Sheets™, with or without the currency, the way each country writes its amounts: “one thousand five hundred dollars and fifty cents”, “Un mil quinientos pesos 50/100 M.N.”, “mil e quinhentos reais e cinquenta centavos”, “eintausendfünfhundert Euro und fünfzig Cent”. Six languages, ten currencies, one permission. Free.

Install it from the Google Workspace Marketplace™, or from Extensions › Add-ons › Get add-ons inside Google Sheets™.

How to use it

  1. Select the cells with your numbers (one column). The column to the right is where the words go.
  2. Open the Extensions menu, find Spell Numbers and choose Amount in words, with currency and the currency, or Number to words (no currency). The text appears to the right, row by row, as plain text that everyone can see, also people who do not have the add-on.
  3. Options in the same menu: UPPER CASE, in parentheses, «un mil» instead of «mil», cents as 50/100 (check style). Language of the words lets you write in a language other than the one of your account. Ctrl+Z (Cmd+Z on Mac) takes it back; with skipped cells it may take more than one press.

The formula

The formula only works for people who have the add-on installed: in a shared file, the others see an error in that cell. For files you share or export, use the menu, which writes plain text.

What it takes care of

Languages

The menus and messages follow the language of your Google account: English, Spanish, Portuguese, French, German and Italian. Any other language shows English. The words themselves can be written in any of the six.

Questions

Does anything leave my spreadsheet?
No. The add-on is a script that runs inside your Google account and only asks for permission to edit the spreadsheet it is open in. No servers of ours, no tracking, no account. See the privacy policy.
Why does my colleague see an error where I see the words?
Because the formula is provided by the add-on, and your colleague does not have it installed. Use the menu for shared files: it writes plain text that everyone sees, and it stays there even if the add-on is removed.
Comma or semicolon in the formula?
It depends on the locale of your spreadsheet (File › Settings). Spreadsheets that use a decimal comma (Spain, Brazil, France, Germany, Italy, Argentina, Colombia) separate arguments with a semicolon; those that use a decimal point (United States, Mexico, Peru, United Kingdom) use a comma.
Can I undo?
Yes. Ctrl+Z (Cmd+Z on Mac) puts the previous values back; if some cells were skipped, it may take more than one press.
Does it work in the mobile app?
No. Google Sheets™ add-ons run in the web version only.

Anything else: support@singletasktools.com.