Extract Numbers — Find and Extract All Numbers from Any Text
Paste any text — a financial report, a scraped data table, a research paper full of statistics — and this extract numbers tool pulls every numeric value into a clean list instantly. Integers, decimals, percentages, and negative numbers are all captured. No regex, no spreadsheet formula, no scripting needed. Copy the output straight into Excel, a calculator, or a data pipeline. No signup, no character limit.
What Is Extract Numbers?
An extract numbers tool scans your text and pulls out every number it finds — integers, decimals, percentages, negative numbers — leaving only the numeric values in the output. Instead of manually hunting through paragraphs or writing a regex, paste your text and get a clean list of numbers in one click.
This is especially useful when working with reports, scraped data, or copy-pasted tables where numbers are embedded in descriptive text. You get a clean, copy-ready list of values ready for spreadsheets, calculators, or further analysis — without needing to write code or use a spreadsheet formula.
Price: $19.99, Tax: $1.50→19.99
1.50Before & After: Extract Numbers Examples
Real input → output pairs showing exactly what this tool does to your text.
| Input | Extract Numbers Output |
|---|---|
Revenue grew by 23% to $4.5 million. | 23
4.5 |
Temperature: -12 degrees Celsius | -12 |
Score: 98/100 | 98
100 |
Section 2, page 47, line 3 | 2
47
3 |
Version 3.14.159 | 3.14
159 |
Key Features
Captures integers (42), decimals (3.14), negative numbers (-12), and percentage values (85% → 85) in one pass — equivalent to Python's re.findall(r"-?\d+\.?\d*", text) pattern used in data extraction pipelines.
Scans sentences, table captions, and report copy to find every embedded number — no need to manually locate each value. Feed a whole report paragraph and get a clean column of numbers ready for Excel or a calculator.
Results are newline-separated, making them immediately paste-able into an Excel column or a Number Sorter for ranking. No additional splitting or parsing required.
Zero server round-trip, no account required. Runs the same pattern-matching logic used in data science workflows — available without a Python or R environment.
When to Use Extract Numbers
Use when scraping prices, quantities, measurements, or any numeric data from unstructured text or web content.
Extracts integers, decimals, and negative numbers. Duplicate numbers are kept — each occurrence appears separately in the output.
Who Should Use This Tool?
Pull numeric values out of text reports, survey responses, or scraped data before importing to Excel or running calculations.
Extract measurement values, statistics, and percentages from academic papers or data exports for further analysis.
Test data parsing logic by quickly extracting numbers from sample text without writing a regex from scratch.
Key Use Cases
- →Extract all prices from a product description page scraped from a competitor site.
- →Pull out all statistics and percentages from a research report to build a summary table.
- →Extract phone numbers, zip codes, and ID numbers from a list of mixed contact records.
- →Get all numeric values from a CSV that was accidentally exported as plain text with labels mixed in.
- →Extract timestamps and version numbers from log files for analysis.
Extract Numbers vs Other Formats
How this tool compares to related approaches and methods
| Method / Format | Best For |
|---|---|
| THISExtract Numbers (this tool) | One-off extraction of numeric values from free text without scripting |
| Remove Numbers | Stripping digits from text (inverse operation — keep text, not numbers) |
| Number Sorter | Sorting an existing list of numbers — use after Extract Numbers |
| Python pandas str.extract() | Extracting numbers from specific DataFrame columns in a data pipeline |
Extract Numbers Rules: How It Works
- →Integers: 42, 1000, -5
- →Decimals: 3.14, 99.9, -0.5
- →Percentages: the number part of "85%" → 85
- →Numbers embedded in sentences extracted individually
- ×Currency symbols ($29.99) — the number is extracted; $ is left behind
- ×Numbers inside words ("MP3") may or may not be extracted (check tool behavior)
- ×Does not preserve units — "50 kg" → 50 (kg dropped)
- ×No mathematical operations — extraction only, not calculation
How to Use Extract Numbers
- Paste or type your text into the Input Text box.
- The result appears instantly on the right.
- Click Copy to copy the output to your clipboard.
- Click Clear to reset and process new text.
This Converter vs Manual Methods
Why use this tool instead of doing it by hand?
| Method | Limitation |
|---|---|
| Ctrl+F numbers by hand in document | Can't find every number — only those you think to look for |
| Python re.findall(r"-?\d+\.?\d*", text) | Requires Python environment and regex knowledge |
| Excel: extract numbers from cells formula | Complex array formulas; doesn't handle mixed free text with multiple numbers |
| VS Code regex search (\d+\.?\d*) | Returns matches in-file highlights; manual copy to list required |
| ✓ BESTThis converter | None |
Common Mistakes & Pro Tips
- !Assuming all extracted numbers are standalone values — some numbers appear inside words or codes (like "ISO9001" or "Section3") and may need manual review after extraction.
- !Not specifying the number format — if your text contains European-style decimals (commas as decimal separators like "1.234,56"), the extractor may split them incorrectly.
- !Using extraction output as a calculation input without validation — extracted numbers from prose may include numbers you didn't intend (page numbers, footnote references, years). Always review the extracted list before using it in a SUM, AVERAGE, or statistical calculation to remove non-data values.
Frequently Asked Questions
Everything you need to know about Extract Numbers
What types of numbers does this tool extract?
+
The tool extracts integers (42), decimals (3.14), negative numbers (-100), percentages (85%), and numbers with commas (1,000). It identifies numeric patterns in context, so "Chapter 4" yields 4, and "$29.99" yields 29.99.
Does it extract numbers from inside words?
+
Numbers embedded inside alphanumeric strings like "ISO9001" or "v2.4.1" may be extracted depending on the pattern. For version strings and codes, review the output and manually exclude values that were part of identifiers.
Can I extract only integers, not decimals?
+
The default mode extracts all numeric values. If you only want integers, copy the output list and use a filter step to remove entries containing a decimal point — or use the number sorter after extraction to organize the values.
What is the best way to use extracted numbers in Excel?
+
Copy the extracted numbers from the output, then paste into a single column in Excel. Each number will be on its own line. Excel will recognize them as numeric values. From there you can SUM, AVERAGE, or sort them directly.
Is this the same as a regex number extractor?
+
Functionally yes — the tool runs a numeric pattern match similar to the regex \d+(\.\d+)? internally. The difference is you don't need to write or test the regex yourself. For custom patterns (like extracting only 4-digit years or 10-digit phone numbers), the Regex Tester tool lets you write and test your own pattern.
Does the extractor handle European decimal formats (comma as decimal separator)?
+
Most extractors target the period as the decimal separator (3.14), matching the convention in English-language text and most programming languages. European-format numbers using a comma as the decimal separator (3,14) may be treated as two integers (3 and 14) rather than one decimal. If your source text uses European formatting, replace decimal commas with periods first — using Find and Replace (comma → period) — before running the extraction.
How do I extract numbers from text in Python, JavaScript, and Google Sheets?
+
Python: import re; numbers = re.findall(r"-?\d+\.?\d*", text) — returns a list of strings; convert with [float(n) for n in numbers]. JavaScript: const numbers = text.match(/-?\d+\.?\d*/g) || []; — also returns strings; convert with .map(Number). Google Sheets: =REGEXEXTRACT(A1, "-?\d+\.?\d*") extracts the first match per cell; for all matches in a range, use a custom Apps Script with .match(). Excel: no native formula for extracting multiple numbers from a cell; use Power Query's Extract Numbers transform or a VBA User Defined Function.