Power Query data sources in Excel versions - Microsoft Support
If you're a Microsoft 365 subscriber, the Power Query experience is available in Excel for the Mac from the Get Data command on the Data tab. The following table summarizes what data sources are …
About Power Query in Excel - Microsoft Support
With Power Query (known as Get & Transform in Excel), you can import or connect to external data, and then shape that data, for example remove a column, change a data type, or merge tables, in ways …
Create, load, or edit a query in Excel (Power Query)
Know which environment you're in Power Query is well-integrated into the Excel user interface, especially when you import data, work with connections, and edit Pivot Tables, Excel tables, and …
Import data from data sources (Power Query) - Microsoft Support
Use Power Query in Excel to import data into Excel from a wide variety of popular data sources, including CSV, XML, JSON, PDF, SharePoint, SQL, and more.
Learn to use Power Query and Power Pivot in Excel
With Get & Transform and Power Pivot in Excel, you'll spend less time manipulating data, and more time driving impact. Use these resources to find out what's possible, and how to get started.
Use Power Query in Excel for the Web - Microsoft Support
You can import data into Excel using Power Query from a wide variety of data sources. These data source options include Excel workbook, Text/CSV, XML, JSON, SQL Server database, SharePoint …
Power Query for Excel Help - Microsoft Support
Power Query is a technology embedded in Excel and other Microsoft products designed to help you shape your data. In Excel, select the Data tab on the ribbon to see the Get & Transform Data and …
Power Query for Excel Help - Microsoft Support
Power Query is a technology embedded in Excel and other Microsoft products designed to help you shape your data. In Excel, select the Data tab on the ribbon to see the Get & Transform Data and …
Use Microsoft Query to retrieve external data
After you create a query in either the Query Wizard or Microsoft Query, you can return the data to an Excel worksheet. The data then becomes an external data range or a PivotTable report that you can …
Manage queries (Power Query) - Microsoft Support
Excel for the Web incorporates Power Query (also called Get & Transform) technology to provide greater capability when working with imported data sources. You can view your queries and related …
Upgrade Power Pivot Data Models to Excel 2013 or Excel 2016
Oct 14, 2025 · Learn how to prepare and run upgrade on a Power Pivot workbook created in a previous version of Excel and the Power Pivot add-in.