In the United States, a county is a geographic and administrative location within a state. Counties serve as the primary local government in most states and provide various services such as courts, law enforcement, public records, and infrastructure maintenance. Sometimes counties also serve as school districts.

How many U.S. counties are there?

There are more than 3,000 counties in the U.S. according the most recent data available from the U.S. Census.

Can you open this county population data in Excel and Google Sheets?

Due to their data limits, you may struggle to work with large population datasets in Excel and Google Sheets especially when joining with larger datasets. However, you can try downloading the county spreadsheet as CSV to open in Excel.

Is this county code database free?

Yes, the county population spreadsheet provides free county demographic data. Sign up for free to make full use of the data in Row Zero. To export the county population data to your data warehouse or download a CSV of county data, you'll need to sign up for a Pro account.

Population by County in a Spreadsheet - County Demographics

Explore comprehensive county demographic data in a spreadsheet. This dataset provides a list of all U.S. counties with their state. It also has population by county and detailed U.S. Census data by county for age, gender, and race. Explore for free in Row Zero, a 1000x more powerful spreadsheet built for big data.

Open County Demographics Dataset

Dataset Summary
Highlights from the Data
Use Cases
Data Sources

Dataset Summary

View the Spreadsheet

This spreadsheet includes several different sheets of U.S. county data from the U.S. Census Bureau. County demographic data includes county population by age, gender, and race with both raw counts and percentages. It also includes counts for U.S. Citizens of voting age. county demographic breakdown by race

You can also map county to state, ZIP to county, and filter to a list of ZIP codes by county.
breakdown zip codes by county

The workbook contains multiple sheets:

Demographics by County
Map County to State
Map County to ZIP Code
Map ZIP to County
Overall U.S. Demographics
States

Highlights from the Dataset:

Largest Counties in the U.S.

Top 10 most populated counties in America:

Los Angeles County, California - 9,848,406
Cook County, Illinois - 5,185,812
Harris County, Texas - 4,758,579
Maricopa County, Arizona - 4,491,987
San Diego County, California - 3,282,782
Orange County, California - 3,164,063
Miami-Dade County, Florida - 2,685,296
Kings County, New York - 2,646,306
Dallas County, Texas - 2,603,816
Riverside County, California - 2,449,909

Compare this to the median county population of 25,967 residents. You can also easily filter the spreadsheet to see the largest counties by state.

Oldest Counties in the U.S. (in terms of population)

Several of these are popular counties for retirees.

Sumter County, Florida - median age of 68.4 and 57.8% of the population 65 and older
Catron County, New Mexico - median age of 62.6 and 44.5% of population 65+
Charlotte County, Florida - median age of 60.0 and 40.4% of population 65+
Meagher County, Montana - median age of 59.9 and 34.5% of the population 65+
La Paz County, Arizona - median age of 59.7 and 42.2% of the population 65+
Alcona County, Michigan - median age of 59.7 and 36.2% of the population 65+
Jefferson County, Washington - median age of 59.5 and 39.6% of the population 65+
Northumberland County, Virginia - median age of 59.5 and 37.9% the population 65+
Custer County, Idaho - median age of 59.5 and 36.1% of the population 65+
Ontonagon County, Michigan - median age of 59.4 and 37.8% of the population 65+

Counties with the Most Children (in terms of population)

Compare oldest counties to youngest counties with the highest percent of population under 18

Kusilvak Census Area, Alaska - 41.8% under 18 and a median age of 23.6
Todd County, South Dakota - 39.3% under 18 and a median age of 25.4
Dewey County, South Dakota - 37.6% under 18 and a median age of 27.6
Northwest Arctic Borough, Alaska - 37.6% under 18 and a median age of 28.3
Buffalo County, South Dakota - 36.3% under 18 and a median age of 26.2
Oglala Lakota County, South Dakota - 36.1% under 18 and a median age of 27
Sterling County, Texas - 36% under 18 and a median age of 31.4
Oldham County, Texas - 35.8% under 18 and a median age of 32.5
Gaines County, Texas - 35.7% under 18 and a median age of 29.3
Corson County, South Dakota - 35.6% under 18 and a median age of 29.9

Manliest Counties in the U.S. (in terms of population)

Counties with the highest male to female ratio

Forest County, Pennsylvania - 2.44 males to 1 female
Crowley County, Colorado - 2.27 males to 1 female
Aleutians West Census Area, Alaska - 2.27 males to 1 female
West Feliciana Parish, Louisiana - 2.13 males to 1 female
Chattahoochee County, Georgia - 2.01 males to 1 female
Issaquena County, Mississippi - 2.01 males to 1 female
Stewart County, Georgia - 1.95 males to 1 female
Concho County, Texas - 1.91 males to 1 female
Wheeler County, Georgia - 1.87 males to 1 female
Union County, Florida - 1.81 males to 1 female

Use Cases for this Dataset

Row Zero is a powerful spreadsheet built for big data, so you can easily import your data into the spreadsheet (or vice versa) to map your data or just start exploring this comprehensive county dataset with charts and pivot tables. Here are a few common use cases:

Lookup population by county by age, race, and gender.
Rank counties by state by size and percent county breakdown for race, age, and gender.
Enrich your current datasets with county data. You can use XLOOKUP and the ZIP to County mapping to enrich addresses with county data.
Calculate market penetration by county. Measure your user counts or sales by county vs county population counts to see your U.S. county market penetration. You can use the detailed demographic breakdowns to measure more advanced cohorts by gender, age, and race.
Evaluate the diversity of each county by race, gender, and age.