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.

You can use Microsoft Query to retrieve data from external sources. By using Microsoft Query to retrieve data from your corporate databases and files, you don't have to retype the data that you want to analyze in Excel.

Select a cell in the data and then select Query > Edit. Create a blank query. You may want to just start from scratch. There are two ways to do this. Select Data > Get Data > From Other Sources > Blank Query. Select Data > Get Data > Launch Power Query Editor.

A select query helps you retrieve only the data that you want, and also helps you combine data from several data sources. You can use tables and other select queries as data sources for a select query.

A query is a powerful and flexible way to locate specific records because it lets you perform customized searches, apply customized filters, and sort records. You can build your own queries to help you focus on specific records and to answer specific questions.

You can use an append query to retrieve data from one or more tables and add that data to another table. For example, suppose that you created a table to share with a Chicago business associate, but you realize that the associate also works with clients in the Milwaukee area.

Parameters don’t prompt for input. Instead, you can quickly change their value using Power Query. You can even store and retrieve the values from cells in Excel. Parameters are saved in a simple parameter query, but are separate from the data queries they are used in. Once created, you can add a parameter to queries as needed.

For example, when a visitor goes to a page, the Web Part on that page automatically issues a query that contains information from your site navigation. The search results are displayed in the Web Part. If you don’t have much content and the query is simple, you can use several CQWPs to display your content.

A query can help you find and retrieve the data that meets conditions that you specify — including data from multiple tables. You can also use a query to update or delete multiple records at the same time and to perform predefined or custom calculations on your data.

You can use filters to display specific records in a form, report, query, or datasheet, or to print only certain records from a report, table, or query. By applying a filter, you are able to limit the data in a view without altering the design of the underlying object.