Python in Excel is currently in previewand is subject to change based on feedback. To use this feature, join the Microsoft 365 Insider Program and choose the Current Channel (Preview) Insider level.
This feature is gradually rolling out to Enterprise, Business, Education, and Family and Personal users running Current Channel (Preview) on Windows. It's rolling out to Excel for Windows first, starting with Version 2406 (Build 17726.20016), and then to other platforms at a later date. For more availability information, see Python in Excel availability.
If you encounter any concerns with Python in Excel, please report them by selecting Help > Feedback in Excel.
New to Python in Excel? Start with Introduction to Python in Excel and Get started with Python in Excel.
Open-source Python libraries
Python in Excel comes with a standard set of Python libraries provided by Anacondathrough a secure distribution. Use these Python libraries to simplify your data analysis, find patterns and hidden insights, and visualize your data with plots.
Core Python in Excel libraries
The following open-source libraries are available with Python in Excel by default. They've been imported with the statements listed.
-
Matplotlib. Import statement: import matplotlib.pyplot as plt
-
NumPy. Import statement: import numpy as np
-
pandas. Import statement: import pandas as pd
-
seaborn. Import statement: import seaborn as sns
-
statsmodels. Import statement: import statsmodels as sm
See AlsoHow to Convert JSON to Excel?
Note:These core libraries are also listed in the Python in Excel initialization task pane. Access the initialization task pane by selecting Formulas > Initialization in the Excel ribbon. This task pane is currently read-only and shows the initialization settings for your Python in Excel runtime.
How to import libraries
In addition to the core libraries, you can import additional libraries available through Anaconda. Import Python libraries into Excel using a Python import statement in a Python in Excel cell, such as import numpy as np. This statement imports the NumPylibrary and assigns it the alias np. After entering this import statement into a Python cell, you can refer to the NumPy library as npthroughout the Python formulas in that workbook.
Tip:To ensure that your libraries are imported before your Python formulas run, enter your import statements and any settings on the first worksheet in your workbook. If desired, you can reserve the first worksheet specifically for the import statements and settings.
Important:Not all libraries use the import statement format import [library]as [name]. For example, to import the beautifulsoup4 library, use the import statementfrom bs4 import BeautifulSoup. See the documentation for each library to learn the recommended import statement.
List of recommended libraries
The following table shows a subset of the open-source libraries provided by Anaconda that you can use with Python in Excel. The libraries Matplotlib, NumPy, seaborn, statsmodels, and pandasare imported by default. The additional libraries listed in the table are not automatically imported, but you can choose to import them if desired.
Important:To protect your data security, these libraries will not have the ability to make network requests or access your files and data on your local machine. To learn more, see Data Security and Python in Excel.
Note:Python in Excel supportsEnglish, Chinese (Simplified), French, German, Japanese, and Spanish fonts.
| Library | Description |
|---|---|
| A Python library for astronomy. License:BSD-3-Clause. | |
| A Python library designed for screen-scraping. License: MIT. | |
| Helps tackle classification issues by offering re-sampling techniques. Relies on scikit-learn. License: MIT. | |
| A library for interactive computing. License:BSD-3-Clause. | |
| A topic modelling and natural language processing library. License: LGPL-2.1. | |
| Creates publication-quality charts and figures in Python. License: PSF. | |
| A Python package for creating and manipulating complex networks. License:BSD-3-Clause. | |
| Offers array processing for numbers, strings, records, and objects. License:BSD-3-Clause. | |
| Offers data structures and data analysis tools. License:BSD-3-Clause. | |
| Adds support for opening, manipulating, and saving different image file formats. License: PIL. | |
| Brings together Python, the HDF5library, and the NumPylibrary to handle large amounts of data. License:BSD-3-Clause. | |
| A wavelet transforms library. License: MIT. | |
| A set of Python modules for machine learning and data mining. License:BSD-3-Clause. | |
| A scientific library for Python. License:BSD-3-Clause. | |
| A statistical data visualization library. License:BSD-3-Clause. | |
| An algorithm library collection for Python. License:BSD-2-Clause. | |
| Statistical computations and models, for use with the SciPylibrary. License:BSD-3-Clause. | |
| A Python library for symbolic mathematics. License:BSD-3-Clause. | |
| A library for creating and formatting tables. License: MIT. |
Learn more from Anaconda
To learn moreabout the integration and supported libraries, visit Anaconda.
Related articles
-
Create Python in Excel plots and charts
-
Python in Excel DataFrames
