Python for Excel

Create custom Excel functions powered by Python. This free Excel add-in lets you write Python functions and use them directly in Excel formulas, LAMBDA functions, and spreadsheet calculations.

Unlike Excel's built-in =PY() function, Python for Excel turns your Python code into reusable custom functions that work just like native Excel functions. Write once, use anywhere: =MY_FUNCTION(A1:B10).

Includes a growing library of example Python functions for math, statistics, and more. Many of these functions can also be used with the native =PY() function.

Key Features

✅ Custom Python Functions — Build reusable Excel functions from Python code. Use them in formulas, LAMBDA definitions, and complex calculations.

📊 Scientific Computing — Access NumPy, SciPy, Pandas, and 100+ scientific Python packages for statistics, engineering, and data analysis.

🆓 100% Free — Unlimited use at no cost. No Microsoft 365 subscription required.

🌐 Cross-Platform — Works in Excel for the web, Windows, and Mac desktop.

🔒 Private & Secure — Python runs locally in your browser. Your data and code never leave your computer.

📦 Package Support — Import pure Python packages from PyPI. Use Micropip to install additional libraries.

☁️ API Integration — Make HTTP requests to REST APIs and web services directly from your Python functions (CORS-enabled).

Use Cases

• Custom formulas for financial modeling, engineering calculations, and scientific analysis

• Data transformation and text processing with Python string methods

• Statistical functions and machine learning calculations

• API automation to pull data from web services into Excel

• Prototyping custom Excel add-ins before full development

Getting Started

1. Install the add-in and open the sidebar

2. Write a Python function in the Editor tab

3. Save your function and use it as =MY_FUNCTION_NAME() in any cell

See our Python for Excel documentation for tutorials, examples, and API reference.