Free tool
Extract numbers from text
Extract numbers from text: take the first number in each line (or every number), with decimals and minus signs. 1,299 is read as one number and the comma is dropped.
The example is loaded. Paste your own list to replace it.
→ 3 lines
From each line take
Allow decimals (12.50)
Allow minus signs (-3)
Read 1,299 as one number and drop the comma
Drop lines with no number
Your text
Result
What it does
Pull numbers out of text, like prices or counts.
Settings you can change
- From each line take: The first number, Every number (one per line)
- Allow decimals (12.50)
- Allow minus signs (-3)
- Read 1,299 as one number and drop the comma
- Drop lines with no number
When to use it
Prices came out as "From $1,299.00 per month". Keep only 1299.00 so a spreadsheet can add them up.
Example: extract numbers from text
Input
Result
Used in these recipes
Often used with
Total, average, smallest and largest of the numbers in the list (first number in each line).
A to Z, Z to A, or by number.
Keep (or remove) lines that are numbers, emails or links.
Your text stays on this computer
Got your list from a web page?
HeyScraper turns the page you’re on into a spreadsheet, so you can skip the copying and pasting. Free: 500 pages a month.
Get HeyScraper