Collecting quantities
Pull out the quantities and measurements in a note or purchase order before entering them in a spreadsheet.
Number extractor
Find the numeric values in a block of text – integers, decimals and signed numbers – and get a list ready to check and reuse, without uploading anything.
- Clipboard
Data not sent
Result
Was this tool useful?
How does this tool work?
Extract the numbers from a text (quantities, prices, measurements, percentages) and get them one per line, ready to paste into a spreadsheet. The tool spots runs of digits; it does not know what they stand for, performs no calculation and does not interpret units. The text is analysed in your browser.
The tool recognises whole numbers and decimals written with a comma or a point (3,5 or 3.5). A “-” or “+” sign is kept only if it is not attached to a letter or a digit: “-3.5” is negative, but in “A-12” or “2026-08-23” the hyphen is a separator. Numbers are returned in order of appearance, duplicates included, without unit or currency symbols.
Only one separator is accepted per number. With a thousands comma, “1,250.50” gives two values, 1,250 and 50; with a thousands space, “1 250” gives 1 and 250. Likewise, “1,2,3” without spaces is read as 1,2 then 3. Digits in dates, references, phone numbers or version numbers are extracted like any others.
The result is therefore a list to check, not a dataset ready to add up. In “order 204, 12 units at 3.50 each”, 204 identifies an order, 12 is a quantity and 3.50 a price: adding them would make no sense. Keep the source text so you can trace what each number means.
How to use this tool
Paste the text
Paste the text that contains the numbers.
Run the extraction
Click “Extract numbers”: each value appears on its own line.
Check the values
Check thousands separators, signs and digits coming from dates or references before using them.
Use cases
Checking amounts
List the prices in a quote or an email to compare them one by one with an invoice.
Preparing an analysis
Gather the values from a plain-text report, then check separators and signs before calculating.
Examples
Whole number
Input
Stock: 12 units.Result
12Dates, references and negative numbers
A hyphen attached to a letter or a digit is not a minus sign: only “-3.5”, preceded by a space, is negative.
Input
Order A-12 of 2026-08-23: -3.5 °CResult
12
2026
08
23
-3.5Thousands separators
Thousands separators split the number: remove them from the text before extracting if you need the full amount.
Input
Total: $1,250.50 or 1 250Result
1,250
50
1
250Tips and best practices
- Before extracting amounts, remove thousands commas or spaces (find and replace) so each number comes out whole.
- Digits in dates, postcodes, phone numbers and references are extracted too: drop them from the list if they are not measurements.
- When pasting into a spreadsheet, check that its decimal separator matches the values; “3,5” may be read as text in an English-language spreadsheet.
Frequently asked questions
Are numbers inside codes detected?
Yes. “A-12” gives 12 and “2026-08-23” gives 2026, 08 and 23: the tool cannot tell a reference from a quantity.
Does the result calculate a total?
No. The tool lists the numbers without adding them up or averaging them; use a spreadsheet or a calculator after checking them.
Are both comma and point accepted?
Yes, as a decimal separator, but only one per number: a thousands separator splits the number into several values.
Are units and currencies kept?
No. Only digits, the decimal separator and the sign are kept; “15 %” or “$3.50” give 15 and 3.50.
Are numbers written in words recognised?
No. “twelve” or “three hundred” are not extracted, and neither are Roman numerals.
Related tools
Keep going with these tools
Tools similar or complementary to this one.
Similar tools
Extract every email address found in a text and remove the duplicates.
Text & writingUse this tool
Automatically extract the numeric dates found in a text and get them back as a list.
Text & writingUse this tool
Analyse a text and get its number of words, characters, lines, sentences and paragraphs.
Text & writingFeaturedUse this tool