Transform your Google Sheets into powerful economic analysis tools. Access 40M+ time series from FRED, BLS, World Bank, IMF, and 200+ other sources with custom functions.
Chrome, Firefox, Safari, Edge
Google Sheets app
Google Sheets app
Native support
Navigate to sheets.google.com or open the Sheets mobile app.
Click Extensions → Add-ons → Get add-ons in the top menu.
Type "DataSetIQ" in the Google Workspace Marketplace search box.
Click Install and follow the permission prompts. The add-on needs access to:
Go to Extensions → DataSetIQ → Open Sidebar
Try your first formula: =DSIQ_LATEST("FRED/GDP")
When you first try to use a custom function like DSIQ_LATEST, you may see a "You need authorization to perform that action" message. Click the link in the error, grant permissions, then close and reopen your sheet completely (close the browser tab).
=DSIQ_LATEST("FRED/GDP")Returns: 28,269.394 (as of latest FRED data)
=DSIQ("FRED/UNRATE", "M", "2020-01-01")Returns a spill array with Date and Value columns, showing monthly unemployment rate from 2020.
=DSIQ_YOY("FRED/CPIAUCSL")Returns the pre-calculated inflation rate (CPI year-over-year change).
Google Sheets automatically handles array formulas (spill). When you use DSIQwhich returns multiple rows, they'll automatically populate adjacent cells. Make sure there's empty space below!
While the add-on works without an API key (with limited data), connecting your DataSetIQ account unlocks:
Create a new API key or copy an existing one
Open the DataSetIQ sidebar in Google Sheets, paste your API key, and click Save
Install the DataSetIQ add-on and transform your Google Sheets with real economic data.