Remove Accents
Convert accented letters to their plain forms without losing the word.
Number Extractor
Pull every number out of a text and total them.
| As written | Value | Kind |
|---|
Quick Tool Overview
The Number Extractor pulls every figure out of a text — decimals, negatives, thousands separators, currency and percentages — and reports them in order with a sum, an average and a range, which is usually the whole reason for extracting them.
- What it does
- Extracts numbers and totals them
- You give it
- An invoice, report, log or pasted table
- You get back
- Every number with sum, average and range
- Best for
- Auditing figures in a document
About the Number Extractor
Getting the figures out of a document — an invoice pasted as text, a report, a set of log lines, a table copied without its structure — is a job that keeps recurring and has no obvious home outside a spreadsheet.
This pulls out every number, in the forms they are actually written: decimals, negatives, thousands separators, currency amounts, percentages and numbers in scientific notation. They are listed in order with a running total, a sum, an average and a range, which is usually the whole reason for extracting them. Values can also be filtered to a range, which is how you pull the amounts over a threshold out of a long document.
Key features of the Number Extractor
Real number formats
Decimals, negatives, thousands separators, currency amounts, percentages and scientific notation.
Totals calculated
Sum, average, minimum and maximum, which is what you were going to do in a spreadsheet anyway.
Range filtering
Show only values above or below a threshold, to pull the large amounts out of a long document.
Currency symbols reported
Kept alongside each value so you can see which currency it is, without breaking the arithmetic.
Standalone numbers only
The 2 in "H2O" is excluded by default, since it is a digit rather than a figure you wanted.
How to use the Number Extractor
-
1
Paste your text
An invoice, a report, a log or a pasted table.
-
2
Set what counts as a number
Decimals, negatives, thousands separators, currency and percentages are each recognised.
-
3
Filter by range if you need to
Show only values above or below a threshold.
-
4
Read the totals
Sum, average, minimum and maximum are calculated for everything extracted.
Frequently asked questions
A comma between digit groups is treated as a separator, so 1,250.75 is read as one number rather than two. It is a switch, because in some European formats the comma is the decimal point instead.
No. "Twenty-five" is a word, and recognising it reliably would need to understand the sentence. The tool works on numerals.
The symbol is reported alongside the value so you can see which currency each figure is in, but the number itself is extracted cleanly so it can be summed.
The 2 in "H2O" is a digit but not usually a number you want. There is a switch for standalone numbers only, which is on by default.
Reviews of the Number Extractor
What people who use the Number Extractor think of it. Reviews come from visitors and are posted as written.
No ratings yet
Yours would be the first.
- 5 0 reviews rated 5 stars
- 4 0 reviews rated 4 stars
- 3 0 reviews rated 3 stars
- 2 0 reviews rated 2 stars
- 1 0 reviews rated 1 star
0 reviews
Newest first
No reviews yet
Be the first to rate the Number Extractor. It takes half a minute and no account.
Write the first reviewMore text tools
Add Prefix
Put the same text at the start of every line.
Word Counter
Count words, characters, sentences and reading time as you type.
Remove URLs
Delete web links from text, or replace them with a placeholder.
Uppercase Converter
Turn any text into capital letters in one click.
Split Text
Break text into chunks by delimiter, length, lines or words.
Flesch-Kincaid Calculator
Get the US school grade level your text requires.
Bubble Text Generator
Turn text into ⓑⓤⓑⓑⓛⓔ letters in circles.