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 BERFROM DOWNLOAD TO DATA
Set up once. Keep working.
A few quick steps, then you’re ready to explore.
Download & install
Extract the package for your platform and close Excel completely. Open
Install.cmdon Windows orInstall.commandon Mac.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.
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.