Extract numbers from text
Paste a receipt, a report or any messy text and get the numbers in it, one per line, with their sum and average. Choose how thousands and decimals are written, sort the list and drop repeats.
Runs in your browser: nothing you enter is sent anywhere.
How to use it
- Paste the text and choose the number style it uses.
- Read the list of numbers and the summary line under it: count, sum, average, smallest and largest.
- Sort the list or remove repeated values if you need to, then press Copy.
How it works
A pattern finds each number: an optional minus sign, digits (grouped in threes if the style allows it) and an optional decimal part. Each match is converted to a value by removing the grouping marks and, for the European style, turning the decimal comma into a dot. The list shows the numbers exactly as written; the summary uses their values.
Worked example
In “Apples 3, pears 12 and 4.5 kg” the numbers are 3, 12 and 4.5. The sum is 19.5 and the average 6.5. The comma after 3 is not a thousands separator, because no three digits follow it.
Tips
When “Remove repeated values” is on, 5 and 5.0 count as the same value and the summary covers only the numbers listed. If a decimal point is written in front of the digits (.5), only the 5 is found.
Frequently asked questions
Which number styles are understood?
Three. "1,234.56" uses commas for thousands and a dot for decimals; "1.234,56" does the opposite; "Plain digits" ignores grouping, so 1,234 becomes the two numbers 1 and 234. Pick the one your text uses, as the tool does not guess.
How are negative numbers found?
A minus sign counts when it is not glued to a letter or digit before it. So "-45.5" is negative, while the dashes in 2024-0117 are separators and give 2024 and 0117.
Why do I get numbers from words like mp3 or A4?
Every run of digits is a number, wherever it sits. Dates, versions such as 1.2.3 and codes are split the same way, so check the list for numbers you do not want.
Are numbers with spaces as thousands separators, such as 1 234 567, supported?
No. A space ends a number, so 1 234 567 gives three numbers. Replace those spaces first with the find and replace tool.
How accurate is the sum?
The sum is rounded to 10 decimal places to hide the tiny errors of computer arithmetic (0.1 + 0.2). Very large numbers beyond about 15 digits lose precision.