How to extract numbers from text
- Paste your text into Input: a report, an invoice, a bank statement or notes.
- Read the list in Numbers, one per line in the order they appear.
- Turn on Remove duplicates if you only want each value once, then copy or paste the column straight into a spreadsheet.
Common uses
- Pull the amounts out of a pasted receipt, invoice or bank statement to add them up in a spreadsheet.
- Collect measurements, scores or readings from notes written in sentences.
- Get the figures out of a report to check them against a source table.
- List the order or ticket numbers mentioned in a long email thread.
Nothing is uploaded, so financial text stays on your device.
What counts as one number
| In the text | Extracted |
|---|---|
$1,250.50 |
1,250.50 |
−4 °C |
-4 |
12.5% |
12.5 |
1,2,3 |
1, 2 and 3 (three numbers) |
10-20 |
10 and -20 |
1e5 |
1 and 5 |
Numbers are copied exactly as written, so thousands commas stay in. Spreadsheets set to English usually read 1,250.50 as a number. If yours doesn’t, remove the commas with Find and replace first. The duplicate check compares the text too, so 1,000 and 1000 count as different values.