How to Convert Revenue Ranges Like $5M-$10M Into Min and Max Numbers
To turn revenue text into numbers, split each cell into a minimum, a maximum and a currency and write them as plain numbers. Upload the list to the company revenue range parser, pick the revenue column and download the file with three new columns. It runs in your browser, and your file is not uploaded.
Why text ranges need converting
Lead databases export revenue as text: "$5M - $10M", "Under $1M", "1.2B", "500K+". A CRM cannot filter "revenue over 5 million" on text, and a spreadsheet sorts "$10M" before "$5M". Plain numbers fix both. For the same job on headcount, see the employee count normalizer, and for the wider clean-up, cleaning CSV columns before import.
The by-hand way in Sheets or Excel
For one clean pattern such as "$5M" you can strip and multiply:
=VALUE(SUBSTITUTE(SUBSTITUTE(A2,"$",""),"M",""))*1000000
A range needs a second formula after SPLIT or TEXTSPLIT, and K, B, MM, "million" and "Under" each need their own handling. Commas in "1,200,000" and a year in the text break it quietly.
Step 1: upload and pick the revenue column
Upload a CSV or .xlsx file, or paste the cells with the header row first. A header such as Revenue, Turnover or Funding is picked for you.
Step 2: set the fallback currency
Choose the currency to use when the text does not name one. Dollar, euro and pound signs and codes in the text set the currency for that row.
Step 3: check how each example was read
| Text | Min | Max |
|---|---|---|
| $5M - $10M | 5000000 | 10000000 |
| Under $1M | blank | 1000000 |
| 1.2B | 1200000000 | 1200000000 |
| 500K+ | 500000 | blank |
A single value fills both minimum and maximum. Suffixes k, m, mm, mil, b, bn and t are read, with thousand, million, billion and trillion, and one suffix covers both ends of a range such as 10-50M. Under, below, less than and up to give a maximum only; over, more than, at least and a trailing plus give a minimum only.
Step 4: fix what was counted, not guessed
The summary counts single values, ranges, at most, at least, unreadable and blank cells. Unreadable text such as N/A gets blank values so you can fix it by hand. 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 with employee counts, split it first.
What this tool cannot do
- 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.
Check the addresses before you send
Tidy columns do not make an address deliverable. Upload your list on the verify page: the first 100 email checks are free with a Google sign-in, no card. Each address comes back valid, risky or invalid with a reason, and nothing is sent to anyone on the list. For larger or recurring lists, see bulk email verification, list cleaning and pricing.
Convert your revenue column now
Open the company revenue range parser.
Common questions
How do I convert $5M-$10M into numbers in a spreadsheet?
Split the text on the dash, strip the dollar sign and turn the M into 1,000,000 with SUBSTITUTE and VALUE. The company revenue range parser does this for ranges, single values and open-ended text and writes minimum, maximum and currency columns.
What does it do with Under $1M or $500K+?
Under $1M leaves the minimum blank and sets the maximum to 1,000,000. $500K+ sets the minimum to 500,000 and leaves the maximum blank.
Does it convert currencies?
No. The currency is read from the text and never converted. Set the fallback currency when a whole column is in one.
What happens to text it cannot read?
It gets blank values and is counted in the summary, not guessed.
Is my file uploaded?
No. It is read in your browser and goes nowhere.
Check your list before you send
Real mailbox checks over SMTP, and nothing is sent to the address. Sign in with Google and your first 100 email checks are free, no card. Plans for bigger lists are on the pricing page.