XLL Python

Install XLL Python

You’ll download one file and tell Excel where to find it. Python is included. When you’re done, you’ll see a Python tab at the top of your workbook.

Before you start · Open a workbook in the Windows desktop version of Excel. Choose File → Account → About Excel and look for 64-bit on the first line. This release requires 64-bit Excel on Windows.

1. Give the add-in a permanent home

Choose a folder on your PC that you can keep. For example, open Documents in File Explorer, select New → Folder, and name it Excel Add-ins. If your IT team specifies a folder, use that one.

Download xll-python.xll

If your browser asks where to save the file, choose your folder. If it saves automatically, open Downloads in File Explorer, select the downloaded file, press Ctrl + X, open your permanent folder and press Ctrl + V. Leave the file there so Excel can find it each time it opens.

2. Check the file’s Properties

In your permanent folder, right-click xll-python.xll and choose Properties. On the General tab, look near the bottom for Unblock.

This release is unsigned. If you trust the file from the official project release and your organisation permits it, tick Unblock for this file and choose OK.

No Unblock box? Close Properties and continue to step 3. If Windows or Excel says your organisation has blocked the file, ask IT whether they can approve this add-in.

Windows file Properties with the Unblock checkbox highlighted at the bottom of the General tab.
Microsoft’s example uses a sample filename. Look for the same checkbox on your file. Microsoft Support

3. Open Excel’s add-in manager

  1. Open a blank workbook in Microsoft Excel. Choose File at the top left, then Options at the bottom left.
  2. In the Excel Options window, choose Add-ins on the left.
  3. At the bottom, set Manage to Excel Add-ins and choose Go….
Excel Options with Add-ins selected on the left. At the bottom, Excel Add-ins and Go are highlighted.
The Manage dropdown sits below the list of active and inactive add-ins.

4. Select your file and check the ribbon

In the Add-ins window, choose Browse… on the right. Open the folder you chose in step 1, select xll-python.xll and choose OK or Open. Back in the add-ins list, leave the new entry ticked and choose OK.

Excel’s Add-ins window with a checkbox beside each add-in and the Browse and OK buttons on the right.
Microsoft’s example highlights Analysis ToolPak. In your list, look for the add-in you just added.

Look along the top of your workbook for the Python tab. Select it. When you see Console and Open IDE, the add-in is ready. You can now try the forecast worksheet.

An Excel workbook with the Python tab selected and the Console and Open IDE commands visible on the ribbon.
The Python ribbon in the example workbook. You’ll see the same commands in a blank workbook.

Microsoft Windows and Microsoft Excel screenshots. Used with permission from Microsoft. Excel dialog screenshots from Microsoft Community Support.