ZapKit

Number extractor

Pull the figures out of a report, receipt, chat or web page and add them up, without retyping a single one.

What is a number extractor?

A number extractor finds every numeric value in a block of text and lists it on its own, so you can total, compare or paste figures into a spreadsheet. It saves retyping numbers from statements, emails, reports and web pages, and the typos that come with it.

Paste text and choose whether to keep percentages and thousands separators, remove duplicates and sort smallest first. The list comes out one per line or comma separated, with the count, sum, average, smallest and largest number shown above it.

How to use the Number extractor

  1. 1.Paste the text

    Anything with numbers in it.

  2. 2.Choose options

    Percentages, separators, duplicates and sort order.

  3. 3.Copy the list

    With the sum and average already worked out.

Example: a sales update

"Q3 revenue was ₹1,24,500 from 38 orders, up 12.5% on Q2 (₹1,10,700). Refunds: -2,300. Average basket 3,276.32; 4 returns."

Numbers
124500, 38, 12.5%, 110700, -2300, 3276.32, 4
Sum (without the %)
236,218.32
Smallest / largest
-2,300 / 124,500

Every figure is captured correctly, including the Indian-style lakhs, while Q3 and Q2 are ignored.

Reads numbers the way people write them

Thousands separators in both international (124,500) and Indian (1,24,500) styles are understood, as are decimals, minus signs and percentages. Labels like Q3 or A5 are ignored because the digit is part of a word, and ranges like 2020-2021 give two positive years rather than a negative number.

The sum, average, smallest and largest leave out percentages, since adding 12.5% to money makes no sense; untick Include percentages to drop them from the list too.

Frequently asked questions

Does it handle European commas like 3,5?

No. A comma is read as a thousands separator, so convert decimal commas first.

Are currency symbols removed?

Yes. ₹, $ and similar symbols aren't part of the number, so only the digits are kept.

Can I keep the original formatting?

Tick Keep thousands separators to output 124,500 instead of 124500.

Is the text stored anywhere?

No. It's processed on this page.

More Utilities tools