Python for Excel

Run Python code as a function to power your formulas and LAMBDA functions, which is not possible with Excel's native PY(). For example: =BOARDFLARE.RUNPY("arg1 + 2", arg1) will add 2 to the argument (arg1) passed to the function.

This enables you to build custom functions using Python without building a custom Excel add-in. This was originally conceived as an internal tool for prototyping custom functions based on Python, and we decided to publish it as a free add-in.

Benefits

✅ Use Python as a function in formulas and LAMBDAs.

🆓 Free add-in, no Office 365 license required.

🌐 Works in Excel for web as well as desktop.

☁️ Runtime has network access for API calls (need CORS).

📦 Import custom packages (pure Python only).

🔒 Runs locally, so no data is shared outside Excel.

➡️ Code can be loaded from a URL (e.g. GitHub).

🚀 Performance is only limited by your CPU.

This is a work in progress and is intentionally very minimalist. See our Python for Excel documentation for details.