Pull the numbers out of a report

Figures buried in paragraphs — paste the text, get every number with its context, plus a total and count.

Tools used in this guide

The job

A report or email mentions a dozen figures scattered through prose and you need them all — to sum a budget, check a total, or copy them into a sheet.

Extract

Paste the text and every number is listed with its surrounding context — enough to tell '12 attendees' from '12 laptops'. Decimals, negatives, and thousands separators are recognised; each match shows the line it came from.

  • The summary line gives count and sum — the quick sanity check for 'does this add up'.
  • Copy the result as a plain list, one number per line, ready to paste into a spreadsheet column.

Worked example

An expense email: 'hotel 34,500, train 8,270, taxi 2,150' — the extractor lists the three figures and totals 44,920 without you re-typing anything.

Where it stops

It finds numbers, not meaning — dates come back as separate numbers (2025-04-01 → 2025, 4, 1), and phone numbers are just digits. Nothing is summed twice; overlapping matches report once. Up to 200,000 characters.