Python for Excel

by BoardflareMicrosoft 365Price not published

Create reusable Python functions for Excel formulas, LAMBDA definitions, and spreadsheet calculations.

Facts verified marketplace.microsoft.comAd-free rankings
PRICINGNot published
DEPLOYMENTCloud
CATEGORYAnalytics
UPDATED ON MARKETPLACE
Python for Excel — screenshot from the Microsoft Marketplace listing

What it does

Python for Excel lets users write Python functions in an editor and call them from Excel formulas. Functions can also be used in LAMBDA definitions and spreadsheet calculations. The add-in includes example functions for mathematics, statistics, and other tasks. Python code runs locally in the browser, and the add-in supports Excel for the web, Windows, and Mac desktop.

Key capabilities

from the Microsoft Marketplace listing

Custom Python functions

Creates reusable Excel functions from Python code for formulas, LAMBDA definitions, and calculations.

Scientific computing

Provides access to NumPy, SciPy, Pandas, and other scientific Python packages.

Package imports

REST API requests

Makes HTTP requests to CORS-enabled REST APIs and web services from Python functions.

Example function library

Includes example Python functions for mathematics, statistics, and other uses.

Use cases

  • Financial modeling, engineering calculations, and scientific analysis can use custom Python formulas.
  • Python functions can transform data and process text with Python string methods.
  • Web service data can be pulled into Excel through API requests.
  • Custom Excel add-ins can be prototyped before full development.

In the catalog

688 plugins in Microsoft 365 · Analytics

Price distribution: 19 free, 30 freemium, 204 paid, 435 price not published

Pricing & deployment

Platform
Microsoft 365
Product
Excel
Deployment
Cloud
Pricing
Price not published

More from Boardflare

Similar plugins in Excel · Analytics

View all 688 →

What the vendor says

«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 …»

Official marketplace listing

Publisher
Boardflare
Updated on marketplace
Facts verified