BERDATA FOR EXCEL

Your BER data.
Already in Excel.

Bring economic time series straight into your workbook. Start with one formula. Refresh as your analysis evolves.

For desktop Excel with internet access. Try TEST for 10 CPI observations; use your own key for other series.

Need an API key? Contact BER
Metadata, dates and values. One formula.Illustrative worksheet layout

FROM DOWNLOAD TO DATA

Set up once. Keep working.

A few quick steps, then you’re ready to explore.

  1. Download & install

    Extract the package for your platform and close Excel completely. Open Install.cmd on Windows or Install.command on Mac.

  2. Try TEST or connect your key

    Open BERdata Settings on Excel’s Home ribbon. The TEST key is ready to try. Select Test connection, or save your own BER API key for other data.

  3. Start with a formula

    Choose an empty cell with room for your results. Enter a series code and let the data fill your worksheet.

    =BERDATA.GETDATA("P0141-CPS00000")
Installing on a Mac?

Quit Excel with Command-Q before installing. If macOS cannot verify Install.command, dismiss the warning, then open System Settings → Privacy & Security → Open Anyway for that file.

For the manual alternative, see Mac installation help. If your organisation blocks manual installation, contact your IT team.

Used an earlier test version? Read the upgrade guide before installing.