Introduction to the Query Editor

With the Query Editor, you can navigate, define, and perform data transform operations over a data source. To display the Query Editor dialog box, connect to a data source, and click Edit Query in the Navigator pane or double-click a query in the Workbook Queries pane. To connect to a data source, see Import data from external data sources.

The query editor has the following user interface elements:

  1. Query Editor ribbon.

  2. Navigator pane that enables you to browse structured data sources to find the data table that you want to query.

  3. Context menus are specific to an element, such as a table column, within the editor preview grid.

  4. Preview grid that displays a preview of data from the results of each query step. You interact within the Preview pane to shape data to reduce and rearrange one or more tables into a subject table to match your data analysis requirements. For more information about shaping data, see Shape data.

  5. Query Settings pane that includes each query step. A step is each of the data acquisition or data transformation tasks applied on a query. For more information about how to edit query steps, see Edit query step properties.

    Query Editor Parts

Applies To: Excel 2013, Excel 2010

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language