How to use
01
Paste the source text
Drop your report, log, or article into the box labeled Paste text containing numbers. Results appear immediately in the output pane, no button press required.
02
Verify the figure list
Each value sits on its own line in the order it appeared. Click Try sample to watch a sentence about unit sales and prices turn into a clean numeric column.
03
Copy into your spreadsheet
Hit the copy button and paste the column straight into Excel or Sheets. Because one line holds one value, it lands as a single tidy column ready for formulas.
Why Extract Numbers
- Pulls every integer and decimal out of text.
- Handles negative numbers and decimals.
- Listed in order of appearance, duplicates kept.
Common questions
How does the number extractor treat decimals and negative values?
The pattern matches an optional leading minus, digits, and an optional decimal part. So -12, 3.14159, and 980000 all come through exactly as written. A minus sign directly before digits is treated as part of the number.
Why does 1,234 split into two entries when extracted?
Commas aren't part of the numeric pattern, so 1,234 is read as 1 followed by 234. Strip thousands separators first with the Find and Replace tool, replacing commas with nothing, and the value extracts as one number.
Does Extract Numbers keep duplicate values in the output?
Yes, unlike the email and URL extractors on this site, which dedupe. Every occurrence is listed so you can count repeats, spot patterns in logs, or preserve row alignment against the source text.
Can I extract numbers from text containing currency symbols?
Yes, the digits survive and the symbol is dropped. $799 becomes 799 and 45.50 EUR becomes 45.50. If you need to keep track of which currency each figure used, note it before extracting, because units never make it through.
What happens to dates and version strings during extraction?
They get split at the non-numeric characters, and hyphens are read as minus signs. The date 2024-07-02 produces 2024, -07, and -02, and version 2.5.1 produces 2.5 and 1. Watch for these when your source mixes prose with identifiers.
Is there a way to grab only certain numbers, like prices?
Not directly; every numeric value is captured with no filtering options. The practical workaround is to narrow the input first: paste only the paragraph or table section you care about, then extract from that smaller chunk.
Where does the number extraction actually run?
In your browser, on your machine. Financial reports and internal metrics never leave the page, which makes it fine for pre-release earnings text or confidential dashboards you've copied as text.
How do I pull numbers from copied data in a spreadsheet column?
Copy the column, paste it into the input, and every figure lands on its own line in the output. The tool will pull numbers from copied data whether it came from a spreadsheet, a report, or a log, keeping duplicates so your counts stay honest. Paste the result straight back into a fresh column.
Does the online number extractor work on data pasted from a PDF table?
Yes. Once the text is on your clipboard, the online number extractor treats a PDF table the same as any other text and lists each value it finds. Watch for figures that were split by the PDF's line wrapping, since a number broken across two lines reads as two numbers.