Census Bureau

A direct pull of U. S.

When to use it

Underwriting a property and needing population, income, and household stats for the surrounding county or city.
Building a market study that needs household income distribution, travel patterns, or housing stock composition.
Comparing demographics across multiple deals run through an automation (the input range supports named ranges, so every address in a model can hit the Census).
Refreshing a saved deal model to the latest ACS year automatically.

1

From the Automations Discover tab, drop a Census Bureau action into a workflow (or invoke ad-hoc from the ribbon).
2

Pick the data category (Summary, Detailed, or one of the eight thematic tables).
3

Select an Input range (cell that contains the address) and an Output range (top-left cell where the table is written).
4

Choose Always use latest year or pin a specific year; for Summary, also choose Number of years (year range).
5

Optionally toggle Print charts and Apply formatting.
6

The action geocodes the address, resolves FIPS codes via the FCC FIPS service and the Census FIPS service, calls the Census API, and writes a labeled, formatted table back to the chosen cell (plus a chart if requested and applicable).

Default to Always use latest year in automations - the add-in resolves the newest ACS year that actually has data for the variables and geography, avoiding broken pulls when a year is partially released.
Summary uses ACS 1-year (acs/acs1) - only available for large geographies (counties >65K and metro states). Thematic tables use ACS 5-year (acs/acs5) and resolve down to city/place.
Charts are only generated for Summary (year-over-year delta line chart) and the eight thematic distributions (clustered column with % share); the Detailed view never charts.
The output expands as a table: header row, subtitle row, then one row per variable, plus a "% of total" set of columns and a "Source: United States Census Bureau" footer.