Extract Numbers from Text

Extract numbers from text

Spreadsheets and invoices often bury the figures you need inside prose, logs or pasted reports. This tool scans any text and lists every number it contains — integers, decimals, negatives, thousands-grouped values and scientific notation — then cleans, sorts and totals them so you can drop the result straight into a spreadsheet.

How it works

The extractor matches numeric tokens including 42, 3.14, -42, 1,299.50 and 4.0e2. The matches then pass through your options: strip separators removes thousands commas so 1,299.50 becomes 1299.5; de-duplicate keeps each value once; sort numerically orders them ascending; and the separator toggle joins them with newlines or commas. Above the list it shows a running sum of every number found.

Example

Paste:

Invoice total 1,299.50, discount -50, tax 4.0e2.

With strip-separators on, the tool extracts:

Everything runs in your browser — nothing is uploaded.