A .gov website belongs to an official government organization in the United States.
A lock () or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.
TOPICS
2000 and Earlier
2010 Census
2020 Census
2030 Census
American Community Survey (ACS)
American Housing Survey (AHS)
Business Statistics
Data.census.gov
Economic Indicators
Foreign Trade
Geography / Maps
Glossary
Government Statistics
Housing
MQA
Not Sure
Open Government
Other Data Tools
People
Privacy Protections
Pulse Surveys
Voting Rights

Due to a technical change that we had to make for the application programming interface (API), the prescribed sort order functionality that we had before was lost.  This means that geographies may not appear in alphabetical order, and estimates in the data downloads may not appear in the expected order. Although the data may not appear in the expected order, the file still contains the full data values and geographies.

You can sort the download into the desired order using the custom sort function in Excel:

  1. Select Row 1
  2. From the Home Tab, click Sort and Filter
  3. Click Custom Sort
  4. Leave the default radio button checked for Expand the Selection
  5. Click Sort
  6. Click Options and select Sort left to Right
  7. Click the "Sort by" drop down menu and select Row 1
  8. Click OK

 


 

We are looking into other ways to force a sort order while making sure the solution will not negatively impact the speed and performance of the site.

Email us at census.data@census.gov for any questions or comments you may have.  For more guidance on data availability and using data.census.gov, the Census API, and Microdata Access, visit our Resources page.

Send your question or a description of the issue you are facing to a Census Bureau support representative.
Have a live conversation with a Census Bureau support representative to get answers to your questions.

Monday - Friday, 8:00 AM - 5:00 PM ET, Except Federal Holidays.