The quickest way to bring Federal Reserve Economic Data (FRED) into a workbook is the official FRED Add-in for compatible desktop versions of Excel: enter a series ID and retrieve observations without copying them by hand. If you cannot install the add-in, download an XLSX or CSV file from a FRED graph. For repeatable, multi-series updates, use the FRED API with Power Query. Whichever route you choose, check the series definition, units, frequency, and seasonal adjustment before analyzing it; an easy import does not make two economic series comparable.
What FRED data in Excel can—and cannot—tell you
FRED, maintained by the Federal Reserve Bank of St. Louis, is a platform for finding and distributing economic time series from many source agencies, including the Bureau of Economic Analysis, Bureau of Labor Statistics, Census Bureau, OECD, and Federal Reserve entities. FRED is not necessarily the original producer of a series: its underlying source, methodology, units, and revision practices belong to the individual series. Start with the series page and its metadata, not just a familiar label.
- Series: A dated sequence such as GDP, the unemployment rate, or a Treasury yield.
- Series ID: The identifier used to retrieve it—for example,
UNRATEorDGS10. - Observation: A value associated with an observation date.
- Frequency: How often values are reported, such as daily, monthly, or quarterly.
- Units: What the number represents, such as index points, dollars, or a percentage rate.
- Seasonal adjustment: Whether recurring seasonal patterns have been removed.
- Vintage date: The date identifying a particular version of data available at that time.
Economic statistics can be revised. A workbook refreshed today may show changed historical values, so the latest figure in FRED is not always the figure first published for that period.
Choose and verify the right series
Searching for “GDP,” “inflation,” or “interest rates” is only a starting point. Before importing a series, confirm its definition and coverage, source agency, geographic scope, units, frequency, seasonal-adjustment status, and whether it is a level, rate, index, or percentage change. For GDP, also distinguish nominal from real measures. Check whether the source revises its history and whether the series supports the calculation you intend to make.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
#1 Best Overall
- The Microsoft Office 365 Bible: The Most Updated and Complete Guide to Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Teams, Access, and Publisher from Beginners to Advanced
- ABIS BOOK
| Example | Series ID | Check before using |
|---|---|---|
| Real GDP | GDPC1 | Chained-dollar level; it is not a percentage growth rate. |
| GDP growth | A191RL1Q225SBEA | Verify the series definition and growth-rate convention before interpreting it. |
| Unemployment rate | UNRATE | Monthly, seasonally adjusted percentage. |
| Consumer Price Index | CPIAUCSL | Index level, not an inflation rate; calculate a change or select a series explicitly defined as inflation. |
| 10-year Treasury yield | DGS10 | Daily percentage rate; monthly or quarterly conversion requires an aggregation choice. |
| Payroll employment | PAYEMS | Monthly employment level; verify its units and seasonal adjustment on the series page. |
Series IDs are useful, but they are not a substitute for reading the title and metadata. In particular, an index level is not inflation, and a rate displayed in percentage points is not automatically a decimal fraction.
Install the official FRED Excel Add-in
The Federal Reserve Bank of St. Louis describes the FRED Add-in as free software and provides its download, installation information, and user guide on the official FRED Add-in page. The add-in is for Excel environments that can load it; compatibility and menu wording can vary by operating system and Excel edition. You still need Excel access, permission to enable an add-in, and an internet connection to retrieve or update observations.
- Open the official FRED Add-in download page.
- Choose the package and installation instructions for your Excel environment; avoid third-party installers.
- Complete installation, then open Excel and look for the FRED toolbar, ribbon, or add-in controls.
- If the controls are absent, check Excel’s Add-ins and Disabled Items settings, enable the FRED Add-in if listed, and restart Excel if needed.
The basic retrieval workflow is documented in the FRED Add-in User Guide. Its quick-start example uses a series ID in the first-row input area; optional rows can specify settings such as a manipulation, frequency, or start date. Because exact cell positions depend on the guide and add-in layout, follow the current guide rather than assuming a particular worksheet address.
Import your first series
- Open a blank workbook and the FRED Add-in controls.
- Enter a verified series ID, such as
UNRATE, in the designated first-row series input. - If needed, provide a start date such as
2015-01-01in the appropriate date input; leave optional settings blank only if the defaults suit your analysis. - Click Get Data.
- Inspect the returned dates, values, and metadata, then save the workbook.
The workbook should populate with dated observations. Keep the series ID and settings visible in the workbook so someone reviewing it can identify what was requested. The add-in retrieves data when you use its controls; do not assume that updates run on an unattended schedule in every Excel environment.
Crashes, No Sound, or Screen Glitches?
Random freezes, missing sound and display glitches usually trace back to one bad driver. Find and replace yours safely.Free scan · under a minuteWindows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallSet dates, frequency, units, and seasonal adjustment deliberately
Choose a date range for the job
A fixed historical start date supports a stable analysis window. A rolling window, such as the last 10 years, suits a monitoring dashboard but changes as time passes. A full-history download is useful for long-run context, while a vintage-specific range is necessary when asking what data were available at a past point in time. Record the requested range so a later refresh can be interpreted.
Convert frequency only with an explicit aggregation rule
Changing daily data to monthly or quarterly data is not a neutral formatting step. The appropriate rule depends on what the series measures: a rate or yield may call for an average or end-of-period value; a stock or balance-sheet level often calls for end-of-period; a flow may call for a sum or an average depending on the question. State the aggregation method and rationale. The Add-in User Guide says the add-in does not disaggregate data, so selecting a higher frequency cannot legitimately create monthly observations from a quarterly series.
Keep units and transformations straight
Start by retrieving levels and inspecting them. Then choose any transformation deliberately. A simple percent change is not the same as a percent change at an annual rate, a compounded annual rate, or a log difference. Index points also need their base-period context. Do not treat these measures as interchangeable simply because they appear as numbers in adjacent spreadsheet cells.
Match seasonal-adjustment status
Seasonally adjusted and not-seasonally-adjusted series can tell different stories about short-term movement. When comparing related monthly series, use consistent adjustment conventions where possible and disclose differences when they are analytically necessary. Confirm the status in each series title and metadata rather than assuming all monthly data are adjusted.
Analyze and chart the imported data
Calculate year-over-year growth
For complete monthly observations sorted chronologically, if values are in column B and row 14 is exactly 12 months after row 2, a simple percent-change formula is:
=IFERROR(B14/B2-1,"")
Format the result as a percentage. The row-offset method assumes no missing months and a consistent monthly frequency. For production work, use date-based lookups so gaps or a changed frequency do not silently compare the wrong periods.
Calculate a spread between aligned series
For two same-frequency series with matching units and dates, subtract one value from the other, for example =Series_A-Series_B. A yield spread can subtract a shorter-term yield from a longer-term yield. Align observations by date, not merely by row position, and confirm that the two series use compatible units and frequencies. A percentage rate minus an index value is mathematically possible in Excel but economically meaningless.
Calculate a moving average
For 12 monthly values in B2:B13, use =AVERAGE(B2:B13). A 12-month window represents a year of monthly data; four quarters represent a year of quarterly data. A moving average can smooth short-term noise, but it also lags turning points and may obscure abrupt changes.
Recommended Free Tools
Choose a chart that fits the question
- Line chart: A series changing over time.
- Column chart: Period-by-period changes, releases, or flows.
- Indexed line chart: Relative movement after rebasing comparable series to 100 at a common starting date.
- Scatter chart: The relationship between two variables whose observations are aligned.
- Two-axis chart: Use only when different scales are essential and explain the axes; a secondary axis can make unrelated series appear to move together.
Use Excel Tables or dynamic ranges where practical so charts and formulas can accommodate new observations after a refresh.
Download data without installing the Add-in
A direct file download is a useful route if add-ins are blocked, you use a browser-based workflow, or you want a static copy to inspect. FRED documents Excel and CSV data-value downloads from a graph at Using the Download Data link.
- Open the desired FRED series or graph.
- Select Download, then choose Excel or CSV.
- Open the downloaded file in Excel and preserve the original observations on a raw-data sheet.
- Put formulas and transformations on a separate calculations sheet, and charts or dashboard elements on a presentation sheet.
This three-layer workbook makes it easier to distinguish downloaded observations from your own calculations and to recover if a formula or imported value is changed. For a manually downloaded file, record the series ID, source, settings, and download date alongside the workbook.
Rank #4
Automate retrieval with the FRED API and Power Query
The FRED API is a better fit for parameterized, repeatable retrieval. Its observations endpoint accepts a series ID and options for observation dates, units, frequency, aggregation, output type, and vintage controls. An API key is required; consult the official observations endpoint documentation for current parameters and response limits.
The Tool Desk
Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →A conceptual request for monthly unemployment observations looks like this (replace the key and dates with your own):
https://api.stlouisfed.org/fred/series/observations?series_id=UNRATE&api_key=YOUR_API_KEY&file_type=json&observation_start=2015-01-01&observation_end=2026-08-18&sort_order=asc
The date range above is an example, not a claim about the latest available observation. Do not put a live API key in a shared workbook, public repository, screenshot, or URL that may be exposed or indexed. The API documentation lists XML, JSON, XLSX, and CSV response types; it notes that CSV is delivered as a compressed file, so confirm how your Excel import handles it before building a workflow around a direct CSV response.
Build a Power Query refresh
- In Excel, go to Data > Get Data > From Web (labels and availability vary by platform and edition).
- Enter the API endpoint with the required request parameters and handle the API key using an appropriate secure method for your environment.
- Parse the JSON or CSV response, expand the observations into columns, and set the observation date to a date type and the value to a decimal number.
- Load the result to a worksheet or Data Model, then use Refresh or Refresh All for later updates.
The Add-in is generally quicker for a simple retrieval; Power Query makes transformation steps and refresh logic more explicit, particularly in a workbook with several series. API setup, key handling, and platform or organizational security rules add complexity. Excel editions do not all expose identical Power Query controls.
Preserve vintage context and handle missing values
Revisions and historical analysis
Current FRED history may include revisions made after the original release. If your question is what an analyst or policymaker could have known at a past date, current revised data alone cannot answer it. The API supports real-time and vintage controls, including realtime_start, realtime_end, and vintage_dates; use them when the analysis depends on information available at a historical point in time.
For a reproducible workbook, record the series ID and title, source agency, units, frequency, seasonal-adjustment status, date range, transformation, aggregation method, download or refresh date, and vintage date when relevant. Do not describe revised history as the information available to decision-makers at the time unless you used vintage data.
Blanks are not zeroes
FRED observations may be missing, not yet released, suppressed, or absent because frequency or coverage differs. A blank, a marker such as a period, and a genuine zero have different meanings. Never replace missing observations with zero automatically; check the series and source context before deciding how to handle a gap.
Troubleshoot common problems
The FRED toolbar or ribbon is missing
- Confirm the add-in installation completed and the package matches your Excel environment.
- Check Excel’s Add-ins and Disabled Items settings; an add-in can be installed but disabled.
- Restart Excel after enabling it, and reinstall only from the official FRED page if needed.
- If organizational policy blocks add-ins, use a direct XLSX/CSV download or an approved API workflow instead.
Get Data returns no values
- Check the spelling and current status of the series ID on its FRED page.
- Confirm that the date range includes observations and that the ID is in the input row required by the guide.
- Check that the requested frequency is supported and that Excel has internet access.
- Use the Add-in User Guide and API documentation to verify inputs and available observations.
The values look wrong
Recheck the series definition, date range, units, seasonal adjustment, transformation, aggregation method, and revision status. Also confirm that a rate has not been confused with an index level, or a percentage with a decimal fraction. If the selected frequency is higher than the source frequency, the Add-in cannot create legitimate disaggregated observations.
Free tools Windows power users keep installed
One-click scans. No signup required.
An API request returns an error
Check that the API key is present and valid, the series ID and dates are correctly formatted, and each parameter is supported. Review the endpoint documentation for output handling and response limits; if the response is compressed CSV, ensure your import step can process it.
Choose the method that fits your workbook
| Need | Practical choice | Main trade-off |
|---|---|---|
| Quick, simple import in compatible desktop Excel | FRED Add-in | Requires installation and permission to enable the add-in. |
| No add-in installation or a static archive | FRED graph XLSX/CSV download | Manual downloads are less repeatable unless settings and dates are recorded. |
| Several related series at one frequency | FRED Data List | The FRED guide says series in a list must have the same frequency; see FRED Data List downloads. |
| Repeatable refresh and visible transformation steps | Power Query connected to the FRED API | Requires more setup, API key management, and compatible Excel controls. |
| Large, scheduled, or version-controlled pipeline | API with code or a database | More technical infrastructure than a one-off spreadsheet requires. |
Excel for the web and desktop Excel differ in add-in and automation capabilities; feature availability also varies by account, platform, and organization. Check Microsoft’s Excel product information for the environment you use. A paid data subscription is not required simply to retrieve a FRED series, and the official Add-in itself is described by FRED as free.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
