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, …
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 …
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 …
Manage queries (Power Query) - Microsoft Support
You can manage your queries either in the Queries pane of the Power Query Editor or on the Queries tab of the Queries & Connections pane in Excel. This is especially helpful if you have …
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.
Use Microsoft Query to retrieve external data
Using Microsoft Query to import data to import external data into Excel with Microsoft Query, follow these basic steps, each of which is described in more detail in the following sections.
關於 Excel 中的 Power Query - Microsoft 支援服務
使用 Power Query，您可以搜尋數據源、建立連線，然後重塑該數據 (例如移除數據行、變更數據類型，或以符合您需求的方式合併數據表) 。
Create a data type (Power Query) - Microsoft Support
In Power Query, create a custom data type: import, shape, and load it into an Excel Table. View it in a card, extract it into columns, or use a formula.
Create Power Query formulas in Excel - Microsoft Support
The Power Query Editor provides a data query and shaping experience for Excel that you can use to reshape data from many data sources. To display the Power Query Editor window, import …
Import and analyze data - Microsoft Support
You can use Excel's Get & Transform (Power Query) experience to connect to multiple data sources, then use the Query Editor to shape and transform data.