The 2025 ACS Data Users Conference will now be a one-day conference—held virtually—on May 29, 2025

  • 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?

  • 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: 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…

  • 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…

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

    Hi Glenn and Jonathan, the embargo release is available at this time and the 2019-2023 ACS 5-year Summary File is available in this embargo. My apologies for the confusion, I am confirming that the summary file is available. Thank you!

  • 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…

  • ACS 2014 5-year data in MS Access files

    Hi all,

    As I did with the 2013 ACS 5-Year data, I now have the 2014 ACS 5-year data in MS Access files for a handful of states. Most of these are western states as these are ones I'm directly working with, but if you have a need for the data in Access…
For more information about the American Community Survey Census Bureau Website