Headcount & FTE Calculator
How many people, and how many full-time equivalents, broken down by whichever columns you care about.
Reads .xlsx and .csv inside your browser. Your file never leaves your computer.
The spreadsheet
Drop a spreadsheet here
An employee list. Hours or an FTE column make the FTE figure real.
Full time is a local convention, not a fact
A great many tools bake in 2,080 hours. That is forty hours across fifty-two weeks, which is one country’s working year. It is 1,950 at 37.5 hours in much of the UK, and 1,820 at 35 in France, and a bargaining agreement or a shift pattern can make it something else again inside the same company.
So the number is a field on this page, with the common values one click away and any other value typeable. Whatever you use is written into the assumptions and travels with the download, because “42.5 FTE” means nothing without it.
Counting rows is not counting people
Most roster exports contain leavers, and often people whose start date has not arrived. Counting every row gives everybody who has ever worked here. Point the tool at your hire and end date columns and it counts who was actually on the books on the date you name.
Somebody always has no hours recorded
Treating them as full time overstates FTE. Dropping them understates it. Both are reasonable and neither is acceptable silently, so the choice is yours and the total is labelled an upper or a lower bound accordingly. They count towards headcount either way, because they do work here.
If your FTE column holds 100 and 50
Those are percentages, and read as fractions they turn a hundred people into a hundred and fifty full-time equivalents. The tool notices when most values sit above 1.5 and says so rather than reporting the larger number with a straight face.