- Applies to: Excel for Microsoft 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010.
This post focuses on what the Query Editor is and what you can do with it. There are also links to relevant aspects that are pivotal for applying it.
Note: Power Query is also known as Get & Transform in Excel 2016. Information supplied here concerns both. For further information, read Get & Transform in Excel 2016.
The Query Editor only displays once you load, edit, or produce a new query. The video below presents the Query Editor window showing up after changing a query from an Excel workbook.
To view the Query Editor without loading or editing an existing workbook query:
Choose From Other Sources > Blank Query. Do this from the Get External Data section in the Power Query ribbon tab.
Using Query Editor offers you a variety of actions to perform:
- You can navigate;
- Define; and
- Conduct data transform commands over a data source.
To show the Query Editor dialogue box, do the following steps:
- Connect to a data source.
- Then, press Edit Query in the Navigator pane. Alternatively, double-click a query in the Workbook Queries pane.
To connect to a data source, refer to Import data from external data sources.
The query editor comprises these elements:
- Query Editor ribbon.
- Navigator pane – allows you to browse structured data sources. This helps you to locate your desired data table that you seek to query.
- Context menus will adapt to an element inside the editor preview grid—like a table column.
- Preview grid that illustrates a preview of data from the results of each query step. You engage amongst the Preview pane to shape data and reformat tables into a subject table to reflect your data analysis requirements. For further clarity, see Shape data.
- The Query Settings panel, which includes each query step. A step links to each respective data acquisition or data transformation task that can be sent to a query. For greater details about how to edit query steps, see Edit query step properties.