Company revenue range parser: turn $5M-$10M text into minimum and maximum numbers
In short: Upload a list, pick the revenue column, and each cell becomes a minimum, a maximum and a currency written as plain numbers. Limit: Currencies are read, not converted.
Upload a CSV or .xlsx file, or paste it with a header row, and pick the revenue column. Text such as $5M - $10M, Under $1M, 1.2B or 500K+ becomes three new columns: minimum, maximum and currency, written as plain numbers without commas. Open-ended ranges leave one side blank, and text it cannot read is counted, not guessed. Download the file.
Price: this tool is free. Checking a whole email list is from $9/mo, and the first 100 checks are free with Google, no card. Check your list free nowSee pricing
Sample result
Six example cells read as 2 ranges, 1 single value and 2 open-ended; $5M - $10M becomes 5,000,000 and 10,000,000 USD, and N/A is counted as unreadable.
- Ranges
- 2
- Single values
- 1
- Open-ended
- 2
What this means for you
A revenue figure does not show which addresses exist; a check does.
- $5M-$10M to numbers
- Under and over
- k, M, B suffixes
- Never converted
- Revenue
- Range
- CSV
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
Revenue parsed? Check the addresses before you send.
- Download the file, or use the check button under the result, which carries its addresses across.
- Upload or paste it at /verify. Every address gets a live mailbox check, and the first 100 email checks are free with a Google sign-in, no card.
How do I convert revenue text into numbers?
- Upload the file as a CSV or .xlsx, or paste the cells with the header row first.
- Pick the column with the revenue or funding text; a header such as Revenue is picked for you.
- Choose the currency to use when the text does not name one.
- Check how each example was read and download the file.
Example
- You enter
- Six cells: $5M - $10M, Under $1M, 1.2B, €500K+, 10-50M USD and N/A, with no fallback currency.
- You get
- 2 ranges (5,000,000 to 10,000,000 USD and 10,000,000 to 50,000,000 USD), 1 single value (1,200,000,000), 2 open-ended (up to 1,000,000 USD and 500,000 EUR or more) and 1 that could not be read.
- Limits
- Runs in your browser; nothing is uploaded. It reads currencies but never converts them, and a stray year in the text can be misread.
What formats can it read?
Ranges such as $5M - $10M, 5 to 10 million and 10-50M USD, where one suffix covers both ends. Single values such as 1.2B, 250k, 5MM or 1,200,000. Open-ended text: under, below, less than and up to give a maximum only; over, more than, at least and a trailing plus give a minimum only.
Suffixes k, m, mm, mil, b, bn and t are read with their long forms thousand, million, billion and trillion. Dollar, euro and pound signs and codes set the currency.
What do the new columns hold?
A minimum, a maximum and a currency, written as plain numbers so a spreadsheet or CRM reads them as numbers and can filter on them. A single value fills both minimum and maximum. For Under $1M the minimum is blank and the maximum is 1,000,000; for $500K+ the maximum is blank.
Cells it cannot read, such as N/A or a word with no number, get blank values and are counted in the summary so you can fix them by hand.
What should I watch for?
Years and other numbers inside the text can confuse any parser. A four-digit year with no suffix is ignored when another number is present, but check the examples on your own data. If a column mixes revenue and employee counts, run employee counts through the employee count normalizer instead.
The currency is read from the text and never converted; set the fallback when a whole column is in one currency.
Who uses this tool, and for what?
- Sales operations
- Turn a vendor's revenue bands into numbers so a CRM can filter accounts above a size.
- SDRs
- Sort a target list by minimum revenue instead of reading text bands row by row.
- Analysts
- Prepare funding or revenue text from an export for a chart or a pivot table.
What can’t this tool tell you?
- Currencies are read, not converted.
- A year or an unrelated number in the text can be misread; check the examples.
- Only the first two numbers in a cell are used.
- Only the first sheet of a workbook is read.
Common questions
- How is $5M - $10M written?
- Minimum 5000000, maximum 10000000 and currency USD.
- What does Under $1M give?
- A blank minimum and a maximum of 1000000, because there is no lower limit.
- Does it convert currencies?
- No. It reads the currency from the text, and uses your fallback when none is written.
- What happens to N/A or unreadable text?
- The new cells are left blank and the row is counted under Could not read.
- Does it read 5 million to 10 million?
- Yes. Long and short suffixes are both read, and one suffix can cover both ends.
- Is my file uploaded?
- No. It is read in your browser and goes nowhere.
A tidy list can still be full of dead addresses.
Extracting, deduplicating and syntax checks all work on the text of an address. None of them can tell whether the mailbox exists. Only the server that hosts it can answer that, through an SMTP check, and that is what the paid product does.
- Upload the cleaned file as it is: CSVs up to 100,000 rows
- A real SMTP mailbox check on every row, with catch-all detection
- Small list? Starter at $9/mo covers 2,500 emails a month, cancel anytime
Plans from $9 a month, cancel anytime, no contract. Sign in with Google and your first 100 email checks are free, no card. The free tools stay free either way.