The Scenario
You are an analyst at a residential development firm. Your supply-demand model needs 36 months of Census construction data: single-family starts, multi-family starts, completions, and permits. The model is overdue and your manager asked for a draft by end of this week.
That data lives in the Census Economic Indicators Time Series, updated monthly. You pulled it once before using Power Query and a custom M script. The script broke when the Census EITS endpoint changed three months ago and nobody has fixed it.
The bad version:
- You open the Power Query editor, find the broken M script, and try to fix the endpoint URL
- You get the request working but the JSON response structure has changed and the column parsing fails
- You spend a day debugging M code for a dataset that should take ten minutes to import
- It is Friday. Your manager wants the draft. You have a broken Power Query and no model.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that knows the EITS dataset, its series identifiers, and its current endpoint structure.
Open the SheetXAI sidebar and type:
Fetch Census EITS residential construction data for the past 36 months — single-family starts, multi-family starts, completions, and permits — and write each month as a row with seasonally-adjusted values into my workbook. Use YYYY-MM-DD date format in column A.
SheetXAI calls the EITS API, identifies the right series codes, formats the dates consistently, and writes one row per month into the workbook. The four construction series land in their own labeled columns.
What You Get
A clean monthly time series, 36 rows long:
- Column A — date in YYYY-MM-DD format
- Column B — single-family starts (seasonally adjusted)
- Column C — multi-family starts (seasonally adjusted)
- Column D — completions (seasonally adjusted)
- Column E — permits (seasonally adjusted)
These are the official Census Bureau New Residential Construction release numbers, the same figures cited in housing market research and Federal Reserve commentary.
What If the Data Is Not Quite Ready
Time series from government APIs have predictable complications in Excel workflows.
When you need seasonally adjusted and not-seasonally-adjusted side by side
Your econometrician wants both versions for decomposition.
Fetch Census EITS single-family starts for the past 36 months in both seasonally-adjusted and not-seasonally-adjusted form. Write the date in column A, seasonally-adjusted values in column B, and not-seasonally-adjusted values in column C.
When you need to extend the series back further
Your model needs 60 months to capture a full cycle.
Fetch Census EITS single-family starts, multi-family starts, completions, and permits for the past 60 months, seasonally adjusted, with one row per month. Write into columns A through E.
When you need retail sales data instead of construction
Your firm is shifting focus to retail real estate.
Pull Census EITS monthly advance retail sales for the past 24 months and write the series name, period, and value into columns A, B, and C of my workbook.
When you need to join construction data with interest rate data from another tab
Your supply-demand model needs mortgage rate data alongside starts.
Fetch Census EITS single-family starts and completions for the past 36 months, seasonally adjusted, and write date, starts, and completions into columns A, B, and C. Look up the 30-year fixed mortgage rate for each month from the Rates tab (date in column A, rate in column B) and write the rate into column D. Flag any months where the mortgage rate is missing in column E.
The pattern: official construction series, your own rate data, and the joined model input in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any workbook where you need Census economic time-series data, then describe the series you need in plain English. The Census Bureau integration is included in every SheetXAI plan. For related workflows, see how to pull County Business Patterns by NAICS code or the Census Bureau in Excel overview.