THE ACS ONLINE COMMUNITY WILL SHUT DOWN ON SEPTEMBER 30, 2025. READ MORE.

  • RE: Geography file change?

    ah.. I guess it would be if you aren't using the summary files. I use the summary files so it isn't a waste for me. :) Do you need them for every state?

  • RE: Downloading large files

    The ZCTA data (zip code tabulation areas) are only available in the US file, if you're looking for the ACS summary file data. I actually have it imported into Access. The files are big, but if you want it let me know and I can post a link to it on my…

  • 2011-2015 estimates for summary level 70 (geographic Type: Place/Remainder (or Part)

    Hello, I am trying to find 2011-2015 ACS data for Summary Level 70, and I noticed that there are only 16 tables available in the 2011-2015 estimates. However, 897 tables are available from 2009-2013 estimates for the same geography. Michigan is a MCD…

  • RE: Error in sequence file or table shells file for 2013?

    Another "gotcha" now that the 3-year data is out: The ACS2013_TableShells.xlsx file contains rows for the new tables B2800x, but these tables don't exist in the 3-year summary file.

  • RE: Anyone know where to get the big data files?

    Just received this word from Tom Edwards at the Census Bureau:

    "Per our conversation, the SDCs alerted the Census Bureau late yesterday that our ACS 2014 5-Year Summary File was not available during embargo. We are very appreciative of that notification…

  • U.S. Census Bureau Releases 2024 ACS 1-year Estimates

    We are pleased to announce the release of the 2024 American Community Survey (ACS) 1-year estimates, the most relied-on source for up-to-date social, economic, and housing information every year. The ACS is the only source of local statistics for most…

  • RE: Today: Webinar and Documentation Supporting the 2019-2023 American Community Survey 5-Year Data Release

    Hi Glenn, No, the embargo access does not include access to the FTP site and thus does not include the Summary File. The 2019-2023 ACS 5-year Summary File will be available with the public release on December 12.

  • ACS 2014 Table Metadata File

    Attached is a metadata file for both the 2014 1-year and 5-year I created from the ACS 1- year Seq_Table_Number_Lookup Excel file and from Glenn Rice’s modified 5-year shell file. I added fields for record (person/housing) and topic to allow for better…

  • Error in new Table Shells file (2015 1-year)

    Anyone using the table shells file for ETL should be aware that the "UniqueID" column contains incorrect data for any table having 10 or more lines. It's easily fixed with an Excel formula like CONCATENATE(A5,TEXT(B5,"000")). 

  • RE: Geographic components list

    This used to appear in ACS Summary File Appendices, but those are no longer produced with the new Table-Based Summary Files. Instead, the same info is now available through what's called the "Table List" on this page or in this FTP dire…

For more information about the American Community Survey Census Bureau Website