Extract Numbers from Text - Find Numbers and Get Sum, Average and More

Text Tools Free to use

Extract numbers from text in one step

Paste a report, an invoice, a chat log or any messy text and this tool will extract the numbers from it and list them one per line. It finds whole numbers, decimals, negative values, numbers with thousand separators such as 1,250.75, percentages, prices and values in scientific notation. It is a fast way to pull figures out of a long document without retyping them and without making a slip in the third digit.

Filter, sort and calculate

Choose whole numbers only or decimals only, keep values inside a range, remove duplicates and sort from small to large. A summary shows how many numbers were found, their sum, average, median, smallest and largest value, so you can sanity-check a column of prices in a few seconds.

How to use Extract Numbers from Text

  1. Paste your text into the box.
  2. Choose the number format, the type of numbers and any filters such as a minimum and maximum value.
  3. Solve the security check and press Extract.
  4. Read the sum, average and other results, then copy the numbers or download them as a text file.

About Extract Numbers from Text

The tool reads the text from left to right and takes every group of digits it finds as one number. With the US format, a comma between groups of three digits is a thousand separator and a dot is the decimal point; with the European format it is the other way round. With the plain format, commas and dots only count as a decimal point when a digit follows, and groups such as 1,234 are read as two numbers. A minus sign counts only when it comes right before the digits and is not stuck to the end of a word or another number, so 2020-2021 gives 2020 and 2021. The sum, average and median are worked out on the numbers that remain after your filters, using the value of each number, so 1,250.50 counts as 1250.5.

Purpose of Extract Numbers from Text Tool

Use it to total the amounts in an invoice or a chat, to pull measurements out of a lab report, to collect scores from a list of results, to clean a column of data copied from a web page, or to check which prices appear in a document.

Limitations of Extract Numbers from Text

  • Dates, phone numbers, times and version numbers are split into separate numbers. 12/05/2024 gives 12, 05 and 2024.
  • The sum and average use ordinary floating point numbers. Very large values, beyond about 15 digits, can lose precision.
  • Numbers written as words, such as "twenty", are not found.
  • Text over 5 million characters is refused to keep the page fast.

Privacy and data

Extract Numbers from Text runs entirely in your browser. What you type or select is processed on your own device and is never sent to or stored on our server. See our Privacy Policy for details.

Frequently asked questions

Does it find negative numbers and decimals?

Yes. A minus sign directly before a number makes it negative, and decimals such as 3.14 or .5 are found. Use the type option to keep only whole numbers or only decimals.

How are numbers like 1,234.56 handled?

With the US format selected they are read as one number, 1234.56. Choose the European format for 1.234,56, or the plain format if commas separate different numbers in your text.

Is the number extractor free and safe to use?

Yes. The number extractor is free to use and runs in your browser, so your text is not uploaded, stored or logged.

How do I extract only numbers from a string?

Paste the text and extract. Every number is listed in the order it appears, and you can filter by type, sort or remove duplicates before you copy.

Can I get the sum and average of the numbers?

Yes. The tool shows the sum and the average of the numbers it finds. Choose which types of number to keep before you read the total.

Rate Extract Numbers from Text

No ratings yet. Be the first to rate this tool.

Your rating

Report a bug or give feedback

Tell us about Extract Numbers from Text. The subject of your message will name this tool.