Bureau for Economic Research

BERDATA Excel add-in

This plug-in allows you to use the BERDATA portal in Excel.

Open BERdata in Excel

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

Installation instructions

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

Connect your data

Try TEST for 10 CPI observations, or use your own API key.

Get an API key — contact BER

When you test or fetch data, your API key and requested series codes are sent through BER’s relay to api.beranalytics.co.za. BER’s API supports usage logging. How your data is handled.

TEST is a public demo key: up to 10 CPI observations for P0141-CPS00000. Other series and multi-series examples require your own BER API key.

Your key determines which series you can access. In Excel, it is saved in the add-in’s shared runtime storage until you clear it.

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("P0141-CPS00000")

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

More formula examples

Several series, side by side

=BERDATA.GETDATA("P0141-CPS00000", "KBP7008Q")

Include up to 20 unique codes per call.

Start from a date

=BERDATA.GETDATA("KBP7096B", "2018-01-01")

Put the date last, after all series codes. Includes that date and later observations. Leave it out for the full history. Use your own API key for this example.

Values beside existing dates

=BERDATA.GETVALUES("P0141-CPS00000", A10)

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

Click the first date in GETDATA. Lower-frequency values leave blanks between observations; higher-frequency values require a higher-frequency base table.