Extract every number from text, with sum, min, max and average

How to use the number extractor

1. Paste your text into Your text. Reports, invoices, chat logs and web page copy all work.
2. Keep Read 1,250,000 as one number ticked if the text uses commas as thousands separators. Untick it when commas separate values, as in “100,200,300”.
3. Tick Remove duplicates if each value should appear only once.
4. Read the stats (Numbers found, Sum, Smallest, Largest, Average) and copy the list under One per line.

What it does and when to use it

Numbers buried in prose are hard to work with. This tool pulls them out so you can paste them into a spreadsheet, check a total, or spot the highest and lowest value without reading every line.

Good uses:

• Totalling amounts quoted in an email or a meeting note.
• Collecting measurements from lab notes or a product description.
• Pulling order or ticket numbers out of a log.

For other things hidden in text, the email extractor and URL extractor work the same way. To delete the numbers instead of collecting them, use remove numbers.

How it works

The tool scans the text with a pattern that matches:

• whole numbers and decimals with a dot, such as 3 and 12.5;
• a leading minus sign, but only when no letter or digit is right before it;
• with the thousands option on, groups such as 1,250,000, where every group after the first has exactly three digits.

Symbols such as $, % and °C are ignored, so $1,250,000 gives 1,250,000. Digits joined to letters are still found, so “A12” gives 12. For the stats, commas are removed and each value is read as a number. The list keeps the numbers as they were written. Everything happens in your browser.

Worked examples

These outputs come from the tool’s own function.

A business sentence. “Revenue rose 12.5% to $1,250,000 in 2025, with 3 new offices and -4 °C winters.” gives five numbers: 12.5, 1,250,000, 2025, 3 and -4. The tool reports Sum: 1,252,036.5, smallest -4, largest 1,250,000 and an average of 250,407.3.

Duplicates removed. “Rooms 101, 102, 101 and 205” with Remove duplicates ticked gives 101, 102, 205, with a sum of 408.

Dates. “Dates: 2024-01-05, temp -3” gives 2024, 01, 05 and -3. The hyphens inside the date are not read as minus signs, but -3 after a space is.

Limits and tips

• Leading zeros stay in the list (01), but count as 1 in the sum.
• Fractions like 3/4 come out as 3 and 4.
• Scientific notation such as 1e6 is read as 1 and 6.