Number Extractor
Paste any text and get every number in it, with an exact sum, average, low and high.
Try before you buy.
- Free preview: every count, with the first numbers found (up to 100) and where they are; the sum, average and every other total are hidden.
- Locked until you unlock it: download and copy.
- Unlock: Pro pass, ₹179 for 30 days or ₹79 for 1 week, a one-time payment unless you choose automatic renewal. Unlock: Pro pass, $5.99 for 30 days or $2.99 for 1 week, a one-time payment unless you choose automatic renewal.
Ways to unlock shows how to get the full result.
Printing this result is locked in the free preview.
Nothing is uploaded: the numbers are found in your browser.
How numbers are read
Auto reads the decimal mark from the numbers in your text.
Numbers
By type
| Type | Count | Total |
|---|
Where each number is
| # | As written | Value | Type | Line |
|---|
Locked in the free preview. Opens the ways to unlock this result.
Locked in the free preview. Batch runs unlock with a pass.
Locked in the free preview. Query results unlock with a pass.
About the Number Extractor
Paste a bank statement, an invoice, a chat, a report or any other text, or open a text or CSV file, and every number in it is listed: whole numbers, decimals, negatives, percentages and money amounts such as ₹12,34,567.50, USD 4,250.75 or 1.234,56 €. You get the count, sum, average, median, smallest and largest value, totals per currency, and the numbers as a column you can paste straight into Excel or Google Sheets.
Digit grouping is read the way people write it: international (1,234,567.89), Indian (12,34,567.89) and European (1.234.567,89 or 1 234 567,89). Totals are worked out exactly in decimal, so 0.1 + 0.2 is 0.3, not 0.30000000000000004. Nothing you paste is uploaded.
Without a pass you see a free preview: every count, with the first numbers in the order they were found and where each one is; another filter, order or format shows the same numbers, and the sum, average and the other totals stay hidden. A Pro pass unlocks every number with its totals, in every filter, order and format, with Copy and Download.
How to use it
- Paste your text, or use Open file for a
.txt,.csvor other text file. - Check Decimal mark: Auto reads it from the text; choose 1,234.56 or 1.234,56 yourself if a number is read the wrong way.
- Pick what counts: negatives, accounting brackets, scientific notation, lakh/crore/million words, and whether to skip dates, times, phone numbers or numbers inside words such as A4.
- Use Show to keep only plain numbers, percentages or amounts in one currency, then sort, remove duplicates and choose the format.
- Without a pass you see a free preview of the first numbers and the count. With a pass, or after unlocking this result, read the totals above the list and Copy or Download it.
Examples
Rent ₹25,000, deposit ₹1,50,000 and maintenance ₹2,350.50
25000 150000 2350.5
Sum ₹1,77,350.50. The grouping 1,50,000 is read as one number, one lakh fifty thousand.
Brot 2,49 €, Käse 12,90 € und Wein 1.299,00 €
2.49 12.9 1299
Auto detects the decimal comma from 1.299,00 and from the euro amounts.
Budget ₹2.5 crore, spent ₹40 lakh so far
25000000 4000000
Seats 12,14,16 and a 3.5 m gap
12 14 16 3.5
12,14,16 is not a valid way to group digits, so it is read as three numbers.
Common uses
- Adding up the amounts in a pasted bank statement, bill or expense message.
- Getting the figures out of a report or email into a spreadsheet column.
- Checking a total: the sum, average and count of the numbers in a paragraph.
- Listing every percentage or every rupee amount mentioned in a document.
How numbers are recognised
- Grouping: a comma (or, in the decimal-comma style, a dot) groups digits in threes, as in 1,234,567. The Indian system groups the last three digits and then twos, as in 12,34,567, and is read too. No-break spaces, thin spaces, apostrophes (1'234'567, Swiss style) and underscores also group digits. Plain spaces join groups only when you switch that on, because "page 2 345" could be two numbers.
- Lists: digits separated by commas that are not a valid grouping, such as 10,20,30 or 1,2, are separate numbers.
- Decimals: the decimal mark is detected from numbers that can only be read one way (1,234.56 or 3.75 for a point; 1.234,56, 1.234.567 or two prices such as 12,50 € for a comma). A number written in the other style, such as 1.234,56 in an English text, is still read correctly when it uses both marks.
- Signs: a minus (-, −) or plus counts only at the start of a number, after a space, a bracket or a currency symbol: in 10-20 and COVID-19 the hyphen is not a minus.
- Not numbers: version numbers and IP addresses (1.2.3, 192.168.0.1), dotted dates (03.10.2026 with a decimal point), hex values (0x1F) and colour codes (#1e90ff) are skipped.
- Other scripts: digits such as Devanagari १२३ and Arabic-Indic ١٢٣ are read as 123.
Money, percentages and big-number words
- Currency symbols and codes before or after the amount are recognised: ₹, Rs, Rs., $, US$, €, £, ¥, and the other common symbols, and three-letter ISO 4217 codes such as INR, USD and EUR. Codes that are also English words in capitals (ALL, TOP, TRY and a few others) count as money only after the amount, as in 500 TRY, so TOP 10 stays a plain number. Indian Rs. 500/- is read as 500. Symbols that several currencies share ($, ¥, Rs, kr) are kept as written instead of guessing the country.
- Percentages: 18%, 18 %, 18 percent and 18 per cent, and ‰ for per mille. The value is the number before the sign (18), not 0.18.
- Scientific notation: 6.02e23 and 2E-4 are expanded exactly.
- Multipliers (off by default): thousand, k, lakh, crore, cr, million, mn, billion, bn and trillion multiply the number before them, so ₹2.5 crore becomes 25000000. M and B count only after an amount of money ($1.2M).
- Accounting (off by default): an amount in brackets, (2,400.00), is negative.
Exact totals
Every number is kept as an exact decimal, and the sum is calculated with whole-number arithmetic, so it never shows rounding errors, even for large or long numbers. The average is the sum divided by the count, rounded to 10 decimal places; the median is the middle value of the sorted list (the average of the two middle values for an even count). Totals cover the numbers shown, so use Show and Only unique values to decide what is added up.
Limitations
- Numbers written as words (twenty-five), Roman numerals and fractions such as ½ are not found; 3/4 gives 3 and 4.
- Some numbers can be read two ways. With a decimal point, 1,234 is one thousand two hundred and thirty-four and 1.234 is one point two three four; choose the decimal-comma style if your text means the opposite.
- Skipping dates, times and phone numbers relies on common patterns (2026-10-03, 03/10/2026, 10:30, +91 98765 43210, ten-digit Indian mobile numbers); other formats are not recognised as such.
- A range such as 10–20 gives two numbers, 10 and 20.
- At most 200,000 numbers are listed; files up to 50 MB can be opened.
Privacy
On this device: nothing is sent
Everything happens in your browser. What you enter or open here is not uploaded or stored by MySmartCoPilot.
Frequently asked questions
What do I get without a pass?
Without a pass, Number Extractor shows every count, with the first numbers found (up to 100) and where they are; the sum, average and every other total are hidden. Until you unlock it, the result can’t be downloaded or copied. A Pro, Premium or Ultimate pass, a one-time payment unless you choose automatic renewal, unlocks the full result. The pricing page lists the passes and their prices.
How do I add up all the numbers in a text?
Paste the text: the count of numbers appears at once, and with a pass, or after unlocking this result, the Sum together with the average, median, minimum and maximum. To add up only some of them, choose Show: Money and a currency, or Show: Plain numbers.
How do I get the numbers into Excel or Google Sheets?
Choose One per line, copy the list (with a pass, or after unlocking this result), click a cell and paste: each number goes into its own row. If your spreadsheet uses a decimal comma (common in Europe), set Decimals in the list to comma. For a file with the original text, type and line of each number, download the CSV.
Why is 1,234 read as one number?
Because a comma between groups of three digits is the usual thousands separator. Digits separated in other ways, such as 1,2 or 10,20,30, are read as separate numbers. If your text uses a decimal comma, choose 1.234,56 under Decimal mark and 1,234 becomes 1.234.
Does it understand lakh and crore?
Yes. The Indian grouping 12,34,567 is always read as one number, and with lakh, crore, million words switched on, ₹5 lakh becomes 500000 and 2.5 crore becomes 25000000.
Can I get only the percentages, or only the rupee amounts?
Yes: use Show. Percentages keeps 18%, 18 percent and similar; Money keeps amounts with a currency symbol or code, and you can pick one currency. By type shows the count of each group, and with a pass its total too.
Why are dates or phone numbers in my list?
A date such as 2026-10-03 contains the numbers 2026, 10 and 3. Switch on Skip dates and times or Skip phone numbers to leave them out.
Is my text uploaded?
No. Everything runs in your browser; nothing you paste or open is sent anywhere.
Learn more
Lessons on MySmartCoPilot Learn that use this tool:
- Converting types: numbers, dates and Indian formats Free lesson, Pro answers
- Python regex techniques and the regex module Free lesson, Pro answers
- Atomic vectors, types and coercion Free lesson, Pro answers