Skip to main content
The Beebole Excel add-in links worksheets in your Excel workbook to your saved Beebole reports. Instead of exporting files and importing them by hand, you save a report once in Beebole, link a sheet to it, and refresh the data whenever you need the latest figures.
The add-in loads saved reports. Build and save the report you need in Beebole first — its columns, filters, and period all come from the report configuration, not from the add-in.

​
How the add-in works

Each worksheet links to one saved Beebole report. When you refresh, the add-in runs the report in your Beebole account, clears the linked sheet, and writes a header row followed by the report data. The links are stored inside the Excel file, so they travel with the workbook when you share it. The add-in connects with your Beebole API key — you never enter a password. The key is stored privately on your device and is never saved inside the Excel file. Beebole accounts are hosted in one of two regions, Europe or America, and an API key only works in the region that holds its account. The add-in finds that region for you: when you connect, it tries your key on each region and keeps the one that accepts it. There is no region or server to choose.

​
Installing the add-in

1

Open Excel's add-in store

In Excel, open the Office Add-ins store from the ribbon. You can also find the Beebole add-in on Microsoft AppSource.
2

Add the Beebole add-in

Search for Beebole and add it to Excel.
3

Open the task pane

Click the Beebole Reports button on the Home tab of the ribbon to open the Beebole task pane.

​
Connecting with your API key

The first time you open the task pane, the add-in asks for your Beebole API key.
1

Copy your API key from Beebole

In Beebole, click the button with your initials at the bottom of the sidebar, then Your API key. Click Copy.
2

Paste the key into the add-in

In the task pane, paste the key into the API Key field and click Connect. The add-in checks which Beebole region accepts the key, Europe or America, and connects to it. You do not pick a region yourself.
If neither region accepts the key, the add-in stays on the setup screen and shows “No Beebole server accepted this API key. Check the key and try again.” Copy the key again from Beebole and make sure you paste the whole value — a key that was reset in Beebole no longer works anywhere.
The API key gives the add-in the same access as your Beebole account: you only see the saved reports — and the data — that your role and authorizations allow. The Reset button next to your API key in Beebole revokes the current key and generates a new one.

​
Linking a sheet to a report

1

Open the add-link form

In the task pane, click + Add link under Beebole reports linked.
2

Pick a report

In the Add Report Link form, select one of your saved Beebole reports in the Report field.
3

Pick a sheet

Choose an existing sheet in the Worksheet field, or type a name in New sheet name to create one.
4

Confirm

Click Add Link. The link appears in the Beebole reports linked table.
To remove a link, click the ✕ button (Remove link) next to it in the table. This removes the link only — the sheet and its current data stay in place. If you delete or rename a linked sheet, the add-in drops its link the next time you open the task pane.

​
Refreshing your data

In the Refresh section of the task pane:
  • Refresh This Sheet — refreshes the sheet you are currently viewing.
  • Refresh All — refreshes every linked sheet in the workbook.
The add-in also refreshes automatically: every linked sheet refreshes when you open the task pane, and in Excel versions that support workbook-open events, linked sheets refresh in the background each time you open the file.
Refreshing clears the linked sheet before writing the new data. Anything you typed into that sheet — formulas, notes, formatting — is removed. Keep your own calculations and charts in separate sheets that reference the linked one.
If a linked report no longer exists in Beebole, the add-in writes an error message to the sheet so you know the link needs updating.

​
Updating or removing your API key

Click Update API at the top of the task pane to open the key settings. The Data Server section shows the region your reports are loaded from, Europe or America with its flag — the server that accepted your API key. It is shown for information only: the region follows the key, so there is nothing to change here. Under API Key:
  • Paste a new key into New API Key and click Update API Key to switch accounts or replace a reset key. The add-in runs the same region check on the new key, so a key from the other region works too, and the Data Server section updates to match. If no region accepts the new key, the add-in shows “No Beebole server accepted this API key. Check the key and try again.” and keeps your previous key.
  • Click Remove API Key to delete the saved key from your device. You will need to enter a key again to use the add-in.

​
Related content

Reports

Understand report dimensions, filters, grouping, and columns in Beebole.

Custom Reports

Build and save the reports your linked sheets will load.

Google Sheets Add-on

Link Google Sheets to your saved Beebole reports the same way.

Data Exports

Download one-off exports in Excel, CSV, PDF, and other formats.

​
Frequently asked questions

No. The Beebole Excel add-in loads saved reports exactly as they are configured in Beebole. To change the columns, filters, or period of the data in a sheet, edit the saved report in Beebole and refresh the sheet.
The sheet-to-report links are stored inside the Excel file and travel with it. Your API key does not — it stays on your device. The other person sees the last refreshed data, and to refresh it themselves they connect with their own Beebole API key, which shows only the reports their account can access. A linked report their account cannot open shows the “Linked report no longer exists in Beebole” error on its sheet.
Yes. A refresh clears the linked sheet completely before writing the report data. Place your own formulas, pivot tables, and charts in separate sheets that reference the linked sheet, so they survive every refresh.
The add-in writes an error message to the sheet telling you the linked report no longer exists. Remove the link and create a new one pointing to another saved Beebole report.
No. Beebole accounts are hosted in one of two regions, and the Excel add-in detects the right one from your API key when you click Connect — it tries the key on each region and keeps the one that accepts it. To see which region is in use, click Update API and look at the Data Server section. If you see “No Beebole server accepted this API key”, the key itself is wrong or has been reset: copy it again from Beebole.