Skip to main content
FixLines

Extract numbers from text

List every number found in a text, one per line.

Editor

Ln 1, Col 10 lines0 words0 characters

Extract numbers from text: what it does

Pull the figures out of a report, an invoice or a block of notes. Integers, decimals written with a dot, and negative numbers are found. Each distinct number appears once, in the order it was first seen.

Extract numbers from text: how to use it

  1. Paste the text that contains numbers.
  2. Select Apply.
  3. Copy the list of numbers.

Extract numbers from text: when to use it

  • Pull the amounts out of an invoice, a receipt or a bank statement to add them up.
  • Collect the figures mentioned in a report or an article into a list for a spreadsheet.
  • Get the measurements or scores out of a text to chart them.

Extract numbers from text: examples

Collect the figures

Input

Paid 12.50 for 3 items, balance -4

Result

12.50
3
-4
Amounts from a receipt

Input

Coffee 3.20, bagel 2.75, tip 1, total 6.95

Result

3.20
2.75
1
6.95

Extract numbers from text: questions and answers

Are decimals with a comma found?

Decimals written with a dot are found as one number. A comma is read as a separator, so 12,50 gives 12 and 50.

Are repeated numbers listed twice?

No. Each number is listed once, in the order it first appears.

Are numbers with thousands separators found?

A number such as 1,250 is read as two numbers, 1 and 250. Remove the separators with Find and replace text first.

Are percentages and currency signs kept?

No. Only the number is listed; symbols such as % or € are left out.

Is my text sent to a server?

No. Everything runs in your browser on your own device, so your text never leaves it.

Tools people often use together with this one.

More in ExtractBrowse all text tools