Economic calendar in Google Sheets

Paste one IMPORTDATA formula and the sheet fills with the week's releases, one row each, sorted by time. The actual figure appears in its column after the release. New here? Create a free account and you get a Sheets key and starting credit to try this.

The formula

=IMPORTDATA("https://api.narwhalapi.com/v1/economics/calendar?countries=USA&start_date=2026-11-16&end_date=2026-11-20&format=csv&key=YOUR_SHEETS_KEY")
  1. Get a Sheets key Create one under Google Sheets keys on Team and keys in your dashboard.
  2. Put the key in Replace YOUR_SHEETS_KEY in the formula with your key.
  3. Paste it Click an empty cell in Google Sheets, paste and press Enter. The first time in a spreadsheet, click Allow access.

First rows from 16 Nov 2026:

atcountrynameperiodstatusvalue.previousvalue.consensusvalue.actual
2026-11-16T10:00:00ZUSACentral bank speechscheduled
2026-11-16T13:30:00ZUSAEmpire State manufacturing survey2026-11scheduled25.517.6
2026-11-16T17:00:00ZUSACommodity market reportscheduled
The US economic calendar for the week of 16 Nov 2026 in Google Sheets, one release per row with time, name, period, previous figure and forecast

Make it always show this week

Build the dates from today, so you never edit the formula:

=IMPORTDATA("https://api.narwhalapi.com/v1/economics/calendar?countries=USA&start_date=" & TEXT(TODAY()-WEEKDAY(TODAY(),2)+1,"yyyy-mm-dd") & "&end_date=" & TEXT(TODAY()-WEEKDAY(TODAY(),2)+5,"yyyy-mm-dd") & "&format=csv&key=YOUR_SHEETS_KEY")

This runs Monday to Friday of the current week. A new week is a new link, so it costs one call on its first load each day.

More than one country

Join codes with a comma:

countries=USA,GBR,JPN,DEU

Read the columns

ColumnMeaning
atRelease time in UTC. Empty when only the day is known.
nameThe release.
periodThe month or quarter the figure covers.
statusscheduled before the release, then its state after.
value.previousThe last published figure.
value.consensusThe forecast.
value.actualThe new figure, filled after the release.
value_countHow many figures the release has. The row shows the first.

Useful sheet formulas

Put these in another tab, because the table fills the columns to its right. Here the table's tab is named Calendar. Show the time in your own zone (here New York, UTC minus 5 in winter), then choose Format, Number, Date time:

=DATEVALUE(LEFT(Calendar!A2,10)) + TIMEVALUE(MID(Calendar!A2,12,8)) - 5/24

Surprise against the forecast:

=IF(Calendar!H2="","",Calendar!H2-Calendar!G2)

Only releases that have a forecast:

=FILTER(Calendar!A2:J, Calendar!G2:G<>"")

How often does it refresh?

Google reloads the formula about once an hour while the sheet is open. Reloads of the same link on the same day are free.

Why do some rows have no figures?

Speeches and reports have a time and no number. value_count is 0 for those.

Can I get the calendar in my calendar app as well?

Yes. See Build an economic calendar.

Published .

Next steps