Import data from external data sources
With Microsoft Power Query for Excel, you can import data into Excel from a wide variety of data sources. You use the Query Editor to edit query steps to shape or transform data. For more information about how to combine data sources using the Query Editor, see Shape data. For information about prerequisites, see Data source prerequisites.
Note Before you can combine data sources into specific data that match your data analysis requirements, you connect to a data source based on your data source Privacy Levels settings.