Employees - Government
Returns the total number of employees in government at all levels (federal, state, and local).
Data Source
Bureau of Labor Statistics (BLS) - Current Employment Statistics.
Usage Notes
- No parameters required
- Returns employment in thousands
- Data updated monthly
- Seasonally adjusted
Government Employment Levels
| Level | Examples |
|---|---|
| Federal | Military, federal agencies |
| State | Universities, state agencies |
| Local | Teachers, police, firefighters |
Note on Composition
Local government is the largest component (teachers, police, firefighters), followed by state government, then federal.
Syntax
=EmployeesGovernment()Examples
Government employment (thousands)
When to Use
- Analyzing public sector employment
- Tracking government hiring trends
- Fiscal policy analysis
- Building labor market dashboards
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need private sector employment | EmployeesPrivate() |
| Need total nonfarm employment | EmployeesNonfarm() |
| Need goods-producing sector | EmployeesGoodsProducing() |
| Need service sector | EmployeesServiceProviding() |
Common Issues & FAQ
Does this include military?
Federal employment includes civilian federal employees but typically excludes military personnel in BLS data.
What is the largest component?
Local government (teachers, police, firefighters) is the largest component of government employment.
Related Formulas
More MarketXLS Economic Data formulas you can use in the same worksheet:
- Federal Funds Rate
- Federal Receipts
- Federal Surplus or Deficit
- Gasoline Price
- GDP Price Deflator
- Hires - Nonfarm
- House Price Index
- House Price Index - Shiller 20 City
See EmployeesGovernment used in a complete workbook: Jobs Report Tracker Excel: Live Labor Market Dashboard for May 2026 NFP
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?