Beta — Data under validation. Values may contain errors.
Documentation

Install the Excel Add-in

EnergyData Iberia runs as a custom Excel add-in. Choose the method that matches your setup.

Excel for the Web (Easiest)

Works immediately, no file downloads needed.

  1. Open any workbook at excel.office.com
  2. Go to Home tab → Add-ins (or Insert → Office Add-ins)
  3. Click Upload My Add-in
  4. Enter this manifest URL or upload the file:
    https://energydataiberia.com/addin/manifest.xml
  5. Click Upload. The EnergyData button appears in the Home tab.

Excel Desktop — Windows

Uses the Trusted Catalog method (works on all Office 365 versions).

1

Download the manifest

Save this file to a folder on your computer (e.g. C:\AddinManifests\):

Download manifest.xml
2

Share the folder on the network

Right-click the folder → Properties → Sharing tab → Share...

Add yourself (or "Everyone") with Read permission. Copy the network path (e.g. \\YOUR-PC\AddinManifests).

The folder must be a network share — a plain local path won't work. Sharing it with yourself on the same machine is fine.

3

Add it as a Trusted Catalog in Excel

In Excel: File → Options → Trust Center → Trust Center Settings → Trusted Add-in Catalogs

Paste the network path in "Catalog URL" and check Show in Menu. Click OK and restart Excel.

4

Load the add-in

After restarting Excel:

  1. Home → Add-ins (or Insert → My Add-ins)
  2. Click SHARED FOLDER tab at the top
  3. Select EnergyData Iberia and click Add
5

Enter your API key

Click the EnergyData Panel button in the Home tab. Paste your API key (format: ED-XXXX-XXXX-XXXX-XXXX-XXXX) and click Save.

Try =ED.OMIE() in any cell to verify.

Excel Desktop — Mac

Sideload via the manifest file directly.

1

Download the manifest

Save manifest.xml anywhere on your Mac.

2

Copy to the wef folder

Open Finder and press Cmd+Shift+G. Paste this path:

~/Library/Containers/com.microsoft.Excel/Data/Documents/wef

If the wef folder doesn't exist, create it. Copy manifest.xml into it.

3

Load the add-in

Open Excel → Insert → My Add-ins → Developers tab. Select EnergyData Iberia and click Add.

Troubleshooting

Functions return #BUSY! or don't appear

Clear the Excel cache and restart. On Windows, run this in PowerShell:

Remove-Item -Recurse -Force "$env:LOCALAPPDATA\Microsoft\Office\16.0\Wef\*"

Then close and reopen Excel completely.

"Enter your API key" appears in a cell

Open the EnergyData Panel and paste your API key. Get it from your dashboard.

"Upgrade your plan" appears in a cell

The metric you requested is not included in your current plan. Check available metrics on the pricing page.

Shared folder tab doesn't appear

Make sure the folder is a network share (not just a local path), the catalog URL starts with \\, and you restarted Excel after adding it.

Add-in worked before but stopped

EnergyData updates automatically since the add-in loads from the web. If something breaks, clearing the cache (above) usually fixes it.

Verify Installation

Type these formulas to confirm everything works:

=ED.OMIE() — should return the latest spot price
=ED.METRICS() — should spill a list of all available metrics
=ED.GEN(1) — should return the latest solar generation in MW

Still having trouble? Contact us at support@energydataiberia.com