Take the following steps to learn how to import a sample external data set and to use with Python in Excel. To import data from external sources, use Power Query.
How to use Power Query to import data for Python in Excel To learn more about Power Query, see Power Query for Excel Help. Python in Excel can only run calculations on data in an Excel workbook or data imported with Power Query. Use Power Query with Python in Excel to import external data into Excel and then analyze that data with Python. Power Query is a data transformation and preparation tool designed to help you shape your data, and it’s available in Excel and other Microsoft products. New to Python in Excel? Start with Introduction to Python in Excel and Get started with Python in Excel What is Power Query? If you encounter any issues with Python in Excel, please report them by selecting Help > Feedback in Excel. At this time, the feature is not available on other platforms. Python in Excel is gradually rolling out to Excel for Windows customers using the Beta Channel. To use this feature, join the Microsoft 365 Insider Program and choose the Beta Channel Insider level. Python in Excel is currently in preview and is subject to change based on feedback.
