Using the `xl` function, you can load connected data into a Pandas DataFrame, seamlessly combining Excel’s familiar interface with Python’s advanced analytical tools.

Microsoft introduces Python in Excel Advanced users will now be able to directly add Python code to the sheet and analyse it using the usual Excel formulae.

Discover how Python in Excel transforms data analysis with advanced features. Is it worth the hype? Find out if it’s right for your workflow.

Microsoft is integrating Python into its Excel app. A public preview is available for Microsoft 365 subscribers now and all the Python code runs on the Microsoft Cloud.

Still using Excel for your data analysis? Learn how to leverage Python so you can work with larger datasets and automate repetitive tasks.