What is a number extractor?
A number extractor finds every numeric value in a block of text and lists it on its own, so you can total, compare or paste figures into a spreadsheet. It saves retyping numbers from statements, emails, reports and web pages, and the typos that come with it.
Paste text and choose whether to keep percentages and thousands separators, remove duplicates and sort smallest first. The list comes out one per line or comma separated, with the count, sum, average, smallest and largest number shown above it.
How to use the Number extractor
1.Paste the text
Anything with numbers in it.
2.Choose options
Percentages, separators, duplicates and sort order.
3.Copy the list
With the sum and average already worked out.
Example: a sales update
"Q3 revenue was ₹1,24,500 from 38 orders, up 12.5% on Q2 (₹1,10,700). Refunds: -2,300. Average basket 3,276.32; 4 returns."
- Numbers
- 124500, 38, 12.5%, 110700, -2300, 3276.32, 4
- Sum (without the %)
- 236,218.32
- Smallest / largest
- -2,300 / 124,500
Every figure is captured correctly, including the Indian-style lakhs, while Q3 and Q2 are ignored.
Reads numbers the way people write them
Thousands separators in both international (124,500) and Indian (1,24,500) styles are understood, as are decimals, minus signs and percentages. Labels like Q3 or A5 are ignored because the digit is part of a word, and ranges like 2020-2021 give two positive years rather than a negative number.
The sum, average, smallest and largest leave out percentages, since adding 12.5% to money makes no sense; untick Include percentages to drop them from the list too.
Frequently asked questions
Does it handle European commas like 3,5?
No. A comma is read as a thousands separator, so convert decimal commas first.
Are currency symbols removed?
Yes. ₹, $ and similar symbols aren't part of the number, so only the digits are kept.
Can I keep the original formatting?
Tick Keep thousands separators to output 124,500 instead of 124500.
Is the text stored anywhere?
No. It's processed on this page.
Related tools
Phone number extractor
Pull every phone number out of text, tidied and de-duplicated.
Average Calculator (Mean, Median, Mode)
Mean, median, mode, range and sum of a list of numbers.
Email Extractor
Pull every email address out of text, deduplicated and ready to copy.
Word Counter
Words, characters, sentences, paragraphs and reading time.
Character Counter
Characters against X, Instagram, SMS and SEO limits.
Case Converter
UPPER, lower, Title, Sentence, camelCase, snake_case and more.
More Utilities tools
Dates & time
Percent & price
Unit converters
Text tools
Generators
Share & collaborate
Maths
- Ratio calculator
- Weighted average calculator
- Standard deviation calculator
- Percentile calculator
- Fraction calculator
- GCD and LCM calculator
- Prime number checker
- Quadratic equation solver
- Golden ratio calculator
- Roman numeral converter
- Number to words
- Number base converter
- Scientific calculator
- Factorial calculator
- Exponent calculator
- Logarithm calculator
- Modulo calculator