Employee count normalizer: one clean company size for every lead
In short: Upload a list with a company size column and an email column. Every spelling (ranges, 10k, 1,200 employees, over 500, under 10, about 250) is read into a minimum, a maximum, one estimate and a size band. Limit: It reads text that looks like a size; it does not look up a company's real headcount.
Upload the list and choose the company size column. Each value is read into a minimum, a maximum, one estimate (the midpoint of a range) and one of eight size bands from 1-10 to 10,001+. It reads ranges, 10k and 2.5k, thousands separators, over and under, and about, and lists the rows it cannot read.
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
Nine example rows: 3 single numbers, 5 ranges or open-ended values, and 1 that could not be read.
- Could not read
- 1
- Rows read
- 9
- Size bands
- 8
What this means for you
Each readable row gets a minimum, maximum, estimate and size band.
- Ranges, 10k and 2.5k
- Over, under and about
- Min, max and estimate
- Eight size bands
- Lead list
- Company size
- Normalise
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
With one size format, check the addresses.
- Copy the Email column from the downloaded list, or use the check button under the result.
- 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 normalise company size in a lead list?
- Upload the .xlsx or CSV, or paste the cells with the header row first. It needs a size column and an Email column.
- Check the size column the tool picked, then read the counts and the rows per band.
- Download the list with employees_min, employees_max, employees_estimate, size_band and size_note columns added.
- Download the rows it could not read, fix them at the source and run them again.
Example
- You enter
- Example list of nine rows with sizes 51-200, 1,001 - 5,000 employees, 10k+, ~250, 2.5k, 11 to 50, under 10, Self-employed and n/a.
- You get
- Nine rows read: 3 single numbers, 5 ranges or open-ended values and 1 that could not be read (n/a). 51-200 stays in the 51-200 band, 2.5k lands in 1,001-5,000 and 10k+ in 5,001-10,000.
- Limits
- Runs in your browser. The size bands are this tool's own.
Which size values does it read?
A single number (250, 1,200, 2.5k), a range with a hyphen, a dash or the word to (51-200, 11 to 50), an open-ended value (10k+, 5,000 plus, over 500, more than 1,000), a limit below (under 10, less than 50), an approximate value (~250, about 300) and the words self-employed or just me, which count as 1. Words such as employees, staff and headcount are ignored.
How are the min, max, estimate and band worked out?
A range keeps its two ends and its estimate is the midpoint. A single number is its own min, max and estimate. An open-ended value has a minimum and no maximum. The band comes from the estimate, using this tool's own eight bands: 1-10, 11-50, 51-200, 201-500, 501-1,000, 1,001-5,000, 5,001-10,000 and 10,001+. A range that runs across two bands is banded by its midpoint and marked in the size_note column.
What happens to values it cannot read?
Blank cells stay blank. Text with no readable number, such as n/a, is counted and left empty in the new columns, and you can download those rows to fix them. Decimals without a k, such as 1.2, are not guessed at. Pair this with the company name cleaner and the job title normalizer to tidy the rest of a lead list.
Who uses this tool, and for what?
- Cold email senders
- Segment a list by company size before writing different copy for small and large accounts.
- Sales ops
- Merge size columns from several data sources into one format.
- List builders
- Find the rows where the size field holds text instead of a number.
What can’t this tool tell you?
- It reads text that looks like a size; it does not look up a company's real headcount.
- The bands are this tool's own and cannot be changed on the page.
- A range is banded by its midpoint, so it can differ from a source that uses its own band for the same range.
- Values in other languages and written-out numbers such as fifty are not read.
Common questions
- Are these the same bands as other tools use?
- No. They are this tool's own eight bands, listed on the page. If you need other cut-offs, use the min and max columns.
- Why is 10k+ in the 5,001-10,000 band?
- Its minimum is 10,000, which falls in that band. 10,001+ and over 10,000 land in the top band.
- What does self-employed become?
- A size of 1 in the 1-10 band.
- How is a range like 1-5k read?
- As 1,000 to 5,000, because the k on the end applies to both numbers when the first is smaller.
- Does it change my original column?
- No. It adds columns to the end and leaves every original column as it was.
- Is my list uploaded anywhere?
- No. It is read in your browser.
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.