Extract Numbers from Text

Pull every number out of mixed text into a clean list, one per line.

100% private. Everything runs in your browser. Your data never leaves your device.

Extract Numbers

What does this tool do?

This tool extracts all the numbers from mixed text, returning them as a clean list. Useful when amounts, IDs, or codes are buried inside words. It runs entirely in your browser.

How to use Extract Numbers from Text - Free Online Tool

  1. Paste your text, or click "Try with sample data".
  2. Choose whether to include decimals and negative signs.
  3. Click Extract Numbers.
  4. Copy or download the resulting list of numbers.

Example

Pulling amounts out of text:

Before

Text
Invoice 302 total 1,250.50 due

After

Numbers
302
1250.50

Numbers are extracted; surrounding words are dropped.

Excel formula alternative

Prefer a formula? You can achieve a similar result with TEXTJOIN + IFERROR:

complex array formula required

Extracting numbers in Excel needs long array formulas or VBA. This tool handles it instantly.

When should I use this tool?

Pulling amounts from invoice text
Extracting IDs embedded in strings
Cleaning measurements out of notes
Getting phone or order numbers
Turning messy text into numeric data
Preparing numbers for calculations

Frequently Asked Questions

Yes. You can choose to keep decimal points and negative signs.

No. Everything runs in your browser.

Commas used as thousands separators are handled so 1,250.50 is read as 1250.50.

Yes. Copy them or download as a file.

Related tools

Extract Email Addresses
Split Text (Text to Columns)
Trim, Clean & Convert Case
Word & Character Counter
Excel Formula Generator

Related Tools

Compare Excel Files Excel Formula Generator Merge Excel Workbooks Trim, Clean & Convert Case Remove Duplicates Compare Two Excel Columns Excel ↔ JSON Converter Excel ↔ XML Converter EMI Calculator Age Calculator Excel ↔ CSV Converter Split Excel Sheets Remove Blank Rows/Columns Format Data Income & Expense Tracker Find Duplicates Split Text (Text to Columns) Extract Email Addresses Word & Character Counter Change Text Case Find & Replace Text Combine Columns Remove Special Characters Add Prefix / Suffix Reverse Text Convert Text to Numbers Split Full Names Remove Extra Spaces Extract URLs Extract Text Between Characters Add Serial Numbers Transpose Data Sort Data Delete / Keep Columns CSV Viewer CSV to JSON JSON to CSV CSV to SQL CSV to Markdown Table Markdown Table to CSV Excel / CSV to HTML Table Count Unique Values Data Profiler & Health Check Percentage Calculator Percentage Change Calculator Profit Margin Calculator CAGR Calculator Discount Calculator GST Calculator