About 600 results
Open links in new tab
  1. Create, load, or edit a query in Excel (Power Query)

    In Excel, you may want to load a query into another worksheet or Data Model. In the list of queries, locate the query, right click the query, and then select Load To.

  2. About Power Query in Excel - Microsoft Support

    With Power Query, you can search for data sources, make connections, and then shape that data (for example remove a column, change a data type, or merge tables) in ways that meet your needs. …

  3. 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 many queries …

  4. 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 data from …

  5. 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.

  6. Learn to use Power Query and Power Pivot in Excel

    With Power Query (known as Get & Transform in Excel) and Power Pivot in Excel, you'll spend less time manipulating data, and more time driving impact. Watch this 2-minute video to learn how.

  7. 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 …

  8. Use Power Query in Excel for the Web - Microsoft Support

    Excel incorporates Power Query (also called Get & Transform) technology to provide greater capability when importing, refreshing, and authenticating data sources, managing Power Query data sources, …

  9. Create a parameter query (Power Query) - Microsoft Support

    To open a query, locate one previously loaded from the Power Query Editor, select a cell in the data, and then select Query > Edit. For more information see Create, load, or edit a query in Excel.

  10. Import from an Excel Table - Microsoft Support

    Load sales data into Power Query and apply some transformations, create a new worksheet, and understand the Query Settings pane