Excel and Google Sheets · A finished text column
Turn a spreadsheet column into words
Have a column of figures and need the wording beside it? Copy up to 100 rows into our list converter, check the results and paste the words into a new column. No formula, macro or add-on to install.
Start with your existing spreadsheet
Your figures are converted in your browser; they are not uploaded to this site. The pasted words are fixed text. If the figures change, convert and paste them again. For GBP wording that updates automatically, choose the formula-only worksheet instead.
Copy, check, paste: the four steps
These instructions assume a desktop spreadsheet. Use Ctrl on Windows or Command (⌘) on Mac for copying and pasting.
- Copy only the figures. In Excel or Google Sheets, select the cells in one column, such as
A2:A7. Leave out the heading and select no more than 100 rows. Press Ctrl+C or ⌘C. Keep the original column. - Paste into Your amounts. Open the list converter, click the large Your amounts box and press Ctrl+V or ⌘V. Choose Currency for money or Plain words for ordinary numbers. For money, select the currency; under Language and formatting, choose British or US English if needed.
- Click Convert list and check every row. Compare Original input, Interpreted as and Status. A blank stays blank. An invalid value gets an explanation, rather than being removed or guessed. Correct any errors in the original sheet and copy the range again.
- Copy the words into an empty column. Click Copy words. Return to your spreadsheet and single-click the first destination cell, such as
B2—do not double-click into it. Press Ctrl+V or ⌘V. Check the first and last results and the rows around any blanks. Widen the column or turn on text wrapping to read long phrases.
Need a record of the checks? Use Copy full table and paste it into a separate empty area. It includes headings, original inputs, interpreted amounts, words and status. Copy words has no heading and keeps an empty destination cell for each blank or invalid row. An empty result is not approval of an invalid amount.
A worked example: keep the right words beside the right figure
With Currency → GBP — British pounds, British English and Sentence case, these six source rows produce the following results. The second row is deliberately empty; 12x is deliberately invalid. On a narrow screen, swipe across the table to read the wording.
| Sheet row | Original figure | Words pasted beside it |
|---|---|---|
| 2 | 1250.05 | One thousand two hundred and fifty pounds and five pence |
| 3 | Blank | Empty cell |
| 4 | 1.01 | One pound and one penny |
| 5 | 505.50 | Five hundred and five pounds and fifty pence |
| 6 | 12x | Empty cell—correct this error before using the list |
| 7 | -42.10 | Negative forty-two pounds and ten pence |
Do not remove a blank or error row from just one column: that would put later wording beside the wrong figures. Review the original/status table before using the words in a document.
Choose words for a number, or words for money
For a measurement such as 123.561, choose Plain words. It becomes One hundred and twenty-three point five six one. Digits after the point are read individually, up to 20 decimal places.
For 505.50 in pounds, choose Currency: the ending is fifty pence. 505.05 ends in five pence. Money accepts at most two decimal places; 123.561 is rejected in Currency mode, not silently rounded. Decide on any rounding in your source spreadsheet first.
Use a dot for decimals. A value such as 1,50 is rejected because it could be misread; change it to 1.50 only if that is the value you intend. Scientific notation such as 1E+3 is not accepted: copy an ordinary numeric display instead. The whole-number limit is 999,999,999,999,999.
The tool can only work with what you copy. If your sheet displays a rounded value, or has already changed a long number, it cannot recover the missing digits. Keep identifiers such as account numbers out of this workflow: it spells quantities, not individual identifier digits.
Have a file with several columns?
In the list converter, open Import a CSV or TSV file, then Choose file. Pick a local .csv, .tsv or text file, up to 256 KB and 100 data rows. An .xlsx workbook cannot be opened here; copy one column or export it as a text file first.
Check the separator and First row contains column names. Select Column to convert, read its five-value preview and click Use this column. Then choose the wording settings and click Convert list. The chosen file is read on your device, not uploaded.
If copying does not behave as expected
- All the words landed in one cell: undo the paste, single-click an empty cell so you are not editing its contents, then paste again.
- The tool says several columns were copied: go back and select just the figures in one column. For a CSV file, use the column preview instead.
- The browser blocks Copy: use the selected recovery text shown by the converter and your device’s Copy command. Check the pasted rows before using them.
- The numbers change later: the pasted words do not recalculate. Reconvert the updated range, or use the GBP Excel worksheet or GBP Google Sheets worksheet for linked wording.
What this walkthrough covers
This is a browser-to-spreadsheet text workflow, not an Excel extension or formula installation. The worked conversion and row-alignment checks use synthetic figures. Copy/paste was checked in native Google Sheets on 25 October 2026; Microsoft Excel itself has not been tested.
A spreadsheet user’s column-and-decimals question illustrates why ordinary decimals and money need different treatment. There are also formula and VBA solutions; choose those when the wording should recalculate inside your file. Microsoft documents that VBA macros cannot run in Excel for the web; this copy/paste route does not require them.
For money, check your organisation’s required wording before using a result. This tool spells figures; it does not calculate exchange rates or certify documents.