Number Extractor
Pull every number out of text: decimals, negatives, English or European thousands separators, percentages and scientific notation, plus sum, average, min and max.
| Statistic | Value |
|---|---|
| Count | 7 |
| Sum | 2,223,089.85 |
| Average (mean) | 317,584.264286 |
| Median | 12.5 |
| Smallest | -2,300 |
| Largest | 1,284,000 |
| Range | 1,286,300 |
| # | As written | Value | Line |
|---|---|---|---|
| 1 | 12.5% | 12.5 | 1 |
| 2 | 1,284,000 | 1284000 | 1 |
| 3 | 940,500 | 940500 | 1 |
| 4 | -2,300 | -2300 | 2 |
| 5 | -1,150 | -1150 | 2 |
| 6 | 3.5e-1 | 0.35 | 2 |
| 7 | 2027 | 2027 | 2 |
Copy a report, an invoice, a chat log or a web table and get just the numbers out of it, ready to paste into a spreadsheet or calculator. The extractor understands thousands separators in English (1,234.56) and European style (1.234,56), negative numbers, percentages and scientific notation, and it shows the count, sum, average, median, smallest and largest value of what it found.
How to use this tool
- Paste the text.
- Choose how numbers are written in it: English, European or plain.
- Optionally keep whole numbers only, convert percentages to fractions, remove duplicates or sort.
- Copy the list (one per line, or tabs for a spreadsheet row); the summary table has the sum and average.
Formula
Sum = x₁ + x₂ + … + xₙ · Average = Sum ÷ n · Median = middle value after sorting
In English style, commas must group exactly three digits (1,234,567) and a dot marks decimals; a comma followed by other digits separates two numbers. European style swaps them and also accepts a no-break space as the thousands separator. A minus or plus sign counts only after a space, bracket or symbol, so “10-20” is the range 10 and 20. Digits glued to letters before them, as in mp3 or A4, are skipped; units after a number (5kg) are fine. Scientific notation such as 2.5e-3 is read as 0.0025.
Example
The sample text gives 7 numbers: 12.5, 1284000, 940500, -2300, -1150, 0.35 and 2027. Their sum is 2,223,089.85 and the average about 317,584.26. “Q3” is skipped because the 3 is part of a word; switch percentages to fractions and 12.5% becomes 0.125.
Frequently asked questions
How do I extract numbers into Excel or Google Sheets?
Keep “New lines” to paste them down a column, or choose tabs to paste them across one row. Use “as plain numbers” so the spreadsheet does not misread thousands separators.
Why is a number split in two?
The number style probably does not match the text. 1.234,56 read in English style gives 1.234 and 56; choose European style. In English style a comma must be followed by exactly three digits to count as a thousands separator.
Are dates and phone numbers extracted?
Yes, their parts are numbers too: 2026-11-08 gives 2026, 11 and 8. Remove them first, or use the phone number extractor for phone numbers.
Last updated:
Page address with these inputs: https://kakao.mobile/tools/number-extractor/
Cite or embed this tool
kakaoCalc. (2026, November 8). Number Extractor. https://kakao.mobile/tools/number-extractor/
“Number Extractor.” kakaoCalc, 8 Nov. 2026, kakao.mobile/tools/number-extractor/.
Paste this code into your page. The widget runs in your visitors' browsers, shows no ads and keeps a link back to this page. Embedding terms