Skip to content
NMSnabbit.

Number Extractor From Text

Extract all numbers from text — integers, decimals and thousands.

Extractors Runs in your browser

What is a number extractor?

Every figure in your text ends up on its own line: integers, decimals like 2.5, negatives like -14 and grouped thousands like 1,234.50 all come through with their formatting intact. Prose, units and currency symbols are discarded. Handy when a report mixes narrative and numbers and you only want the numbers, ready to paste into a spreadsheet column.

How to use the Number Extractor

  1. 1 Paste prose, a report or a data dump into the box.
  2. 2 Numbers line up one per row, decimals and minus signs intact.
  3. 3 Thousands separators, like the comma in 1,299, are preserved.
  4. 4 Move the column of figures into your spreadsheet.

What you can use it for

  • Pulling prices or quantities out of a description.
  • Extracting figures from a pasted report for a sum.
  • Collecting IDs or codes that are purely numeric.
  • Distilling stat-heavy prose into a number list.

Frequently asked questions

Are decimals and negative values captured whole?
Yes. -3, 2.5 and 1,234.50 each come through as one token, minus sign, decimal part and thousands commas included.
What about digits embedded in codes like A12?
The digit run is extracted, so A12 contributes 12. If you only want standalone figures, clean obvious codes out of the input first.
Can I total the extracted numbers here?
Not in this tool. The output is one number per line, though, which pastes directly into a spreadsheet column where a SUM takes one cell.

Related tools

String Extractor Extract quoted strings from code or text, quotes stripped. Phone Number Extractor Extract phone numbers from any text, formatting preserved, de-duplicated. Word Counter Live counts of words, characters, sentences, lines and paragraphs as you type.

More Extractors

More tools like this:

All Extractors