Delimiter.live
Extraction Tools Runs in your browser Free · no account

Number Extractor

The number extractor finds every numeric value in a block of text — integers, decimals, negatives, thousands separators, percentages and currency amounts — and returns them as a list along with the count, sum and average.

Options
Text to scan 0 characters
Numbers

Your result will appear here.

Not sure where to start? Use Load example.

Results update automatically and are calculated on your device. Nothing you type is sent to a server.

Runs in your browser. Processing happens entirely in your browser. Nothing you enter is sent to Delimiter.live.

How to use the Number Extractor

  1. Paste the text containing the numbers you need.
  2. Choose whether decimals, negatives and thousands separators should be handled.
  3. Read the extracted list plus the count, sum and average shown beneath it.
  4. Copy or download the values.

Example

Input
Revenue was 12,500.75 and costs were -3,200.
Output
12500.75
-3200

Count 2 · Sum 9300.75 · Average 4650.38

Common use cases

  • Adding up figures scattered through a report or an email.
  • Pulling prices or quantities out of a pasted invoice.
  • Extracting measurements from a specification document.
  • Getting numeric values out of log lines for a quick calculation.

Limitations and things to watch for

  • Thousands separators are ambiguous across locales: 1.234 means one thousand two hundred and thirty-four in Germany and one point two three four in the UK. The extractor uses the English convention — comma for thousands, full stop for decimals.
  • Numbers embedded in identifiers, dates or version strings are matched too, since they are numerically indistinguishable from data.
  • The sum and average use floating-point arithmetic, so results involving many decimal values can differ in the last digit from exact decimal maths.

Frequently asked questions

Does it add the numbers up?
Yes. Alongside the extracted list you get the count, the total and the average, which saves pasting the results into a calculator.
How are thousands separators handled?
The English convention is assumed: a comma groups thousands and a full stop is the decimal point. Turn off separator stripping if your text uses a different convention.
Will it extract numbers from dates and IDs?
Yes, because a pattern match cannot tell them apart from data. Extract dates or IP addresses with the dedicated tools first if you need to exclude them.

Share this tool