Number Extractor
Paste any text and get every number in it, with an exact sum, average, low and high.
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 |
|---|
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.
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.
- Copy or Download the list, or read the totals above 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
Everything happens in your browser. What you enter or open here is not uploaded or stored by MySmartCoPilot.
Frequently asked questions
How do I add up all the numbers in a text?
Paste the text: the Sum appears at once, together with the count, 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, 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 and total of each group.
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.