ACS Data Users Group

 View Only
  • 1.  Downloading ACS tables without MOE columns (similar to option in the old American FactFinder)?

    Posted 09-09-2020 06:11 PM

    In the old American FactFinder, there was a way to turn off the MOE columns in ACS tables, and then download the tables without the MOE columns. With the new data.census.gov platform, I can't seem to find a way to download a table without the MOE even when unchecking the MOE option in "Customize Table."

    Is there a way to download ACS tables through data.census.gov without the MOE?

    Some charts and tables we create for publications are linked to specific layouts of ACS excel files, and the MOE throws off the order of columns.

    Thanks. Haley



  • 2.  RE: Downloading ACS tables without MOE columns (similar to option in the old American FactFinder)?

    Posted 09-09-2020 06:34 PM

    I just took a sample table, clicked on Customize, chose Margin of Error box which turns it off, and then clicked on any table cell and chose export to Excel and it came in without MOE column

    stan drezek



  • 3.  RE: Downloading ACS tables without MOE columns (similar to option in the old American FactFinder)?

    Posted 09-09-2020 06:40 PM

    Ah, that may be the solution! I was clicking "Download" next to "Margin of Error" in the header above the table which downloaded the entire table, but by right-clicking a cell within the table and choosing to export as Excel, it worked. Thanks so much!



  • 4.  RE: Downloading ACS tables without MOE columns (similar to option in the old American FactFinder)?

    Posted 09-11-2020 10:40 AM

    This is going to save me so much time! Thanks for this tip.