Number Extractor
Pull all the numbers out of a block of text and see the list, the count and the sum.
What is the Number Extractor?
The Number Extractor finds every number in your text, including decimals, negatives and amounts with thousands separators, and lists them with a count and a total. It is useful for pulling figures from invoices, reports, messages and notes, or for a quick sum of values scattered through a paragraph.
How to use it
- Paste your text into the box.
- Choose whether commas are thousands separators or list separators.
- Tick the unique option to ignore repeated numbers.
- Read the count, the sum and the list of numbers.
Number Extractor — FAQ
How are amounts like 1,200 or 12,34,567 treated?
With the thousands option on, they are read as single numbers, 1200 and 1234567. Turn it off if commas in your text separate different numbers.
Does a hyphen make a number negative?
Only when it stands in front of a number on its own, as in -5. In a word such as COVID-19 or a range such as 3-5 the hyphen is ignored.
Why is the sum rounded?
Decimal sums are rounded to six places so that tiny computer rounding errors do not show up in the result.