Bureau for Economic Research Excel add-in

BERdata

Economic data.
In your workbook.

Bring BER time series straight into Excel.

Open BERdata in Excel

Install the add-in, then open BERdata Settings to connect your API key and start pulling data.

Download add-in manifest

You can also test your key and preview data here in your browser once the page has loaded.

Connect your data

Use your BER API key to get started.

Your key determines which series you can access.

Keep it current

Pull the latest values into your formulas.

Whole-workbook refresh recalculates all open workbooks.

Refresh specific codes

Separate codes with commas. Searches all sheets, including codes in cell references.

Each matching formula refreshes in full. For named ranges, table references or calculated codes, use whole-workbook refresh.

Start with a formula

Enter this in an empty worksheet cell.

One seriesGETDATA
=BERDATA.GETDATA("KBP7096B")

Dates, values and metadata expand into the cells below. Leave room for the result.

More formula examples

Several series, side by side

=BERDATA.GETDATA("KBP7096B", "KBP7008Q")

Include up to 20 unique codes per call.

Values beside existing dates

=BERDATA.GETVALUES(A9, "KBP7096B")

A9 contains the first observation date. Place this beside the original formula, at the top of its metadata block.

Use matching frequency, start date and gaps. GETVALUES does not check date alignment.