convert

Extract Numbers

Extract all numbers — integers, decimals and negatives — from text into a list, one per line.

Runs on your deviceBatch readyPaste textNew

Paste or drop

Paste text below, or drop a file instead.

0 chars · 0 lines
…or drop a file
Drag and drop, or choose files
TXTMDCSVTSVLOGJSONXML+10

Choose an output

Extract all numbers — integers, decimals and negatives — from text into a list, one per line.

Fine-tune

Optional — sensible defaults are already set.

About Extract Numbers

Pull every number out of text into a list, one per line. It recognises whole numbers, decimals, negative numbers, numbers with comma thousands separators and scientific notation such as 1.5e3. This is useful when figures are buried in prose, reports or copied web tables.

When it helps

  • Getting prices or amounts out of an invoice, receipt or bank statement copied as text.
  • Pulling measurements or results from a report so you can paste them into a spreadsheet.
  • Collecting order numbers, IDs or phone fragments from a list of messages.
  • Turning a sentence full of statistics into a column you can add up.

Tips

  • 'Remove thousands separators' turns 1,000 into 1000 so spreadsheets read it as a number. Turn it off to keep the original format.
  • European formats such as 1.000,50 use a dot for thousands and a comma for decimals and will be split into separate numbers. Convert them first with find and replace.
  • Numbers attached to letters are still extracted, so 'MP4' gives 4. Phone numbers and dates are split at dashes and slashes into their separate parts.
  • 'Sort ascending' orders by numeric value, so 9 comes before 10.

Good to know

Quick answers about extract numbers in your browser.

Excel needs complex formulas to do this. Paste the cells here instead, convert, and paste the list back into a column. Leave thousands separators removed so Excel treats the values as numbers.

No. Only the number is extracted, so '$19.99' becomes 19.99 and '45%' becomes 45.

Yes. There is no sign-up, no watermark and no limit on how many files you process.

No. Files are read and processed locally in your browser, so they never leave your device.

Related tools

DEVURL EncodePercent-encode the contents of a text file for safe URLs.TXTNewWord CounterCount words, characters, sentences and paragraphs, and estimate reading and speaking time, with a top-words list.TXTNewWord Frequency CounterList every word in your text with how often it appears, ranked and exported as a CSV spreadsheet.TXTNewCase ConverterConvert text to UPPERCASE, lowercase, Title Case, Sentence case, camelCase, snake_case, kebab-case and more.TXTNewFind and ReplaceFind and replace words or patterns in text, with optional regular expressions, case matching and whole-word search.TXTNewText Compare (Diff)Compare two texts line by line and get a unified diff showing exactly what was added, removed or changed.TXTNewReverse TextReverse text backwards character by character, flip the order of lines or words, or mirror each line.TXTNewFancy Text GeneratorTurn plain text into bold, italic, script, gothic, bubble, small caps or upside-down Unicode text you can paste anywhere.TXTNewRemove AccentsStrip accents and diacritics from text (é → e, ñ → n, ü → u) and optionally expand ligatures like ß and æ.

Part of the Text Tools collection.