Discover & Connect

Quickly find and connect to data from public and company data sources. Power Query gives you new data search functions, ease of conversion and joining.
You will be able to carry out analyzes in Excel effectively.

Search and find data

You can easily find data inside and outside your organization using Online Search. Typing what you are looking for will make Power Query display a list of available data sets that meet your criteria. After viewing the content could be easily imported directly to the Excel data source you need.

Data sources

Power Query allows you to extract data from various types of compatible sources.

Data cleaning, merging, shaping and formatting

Before you load data into a spreadsheet, review and organize it. Power Query lets you create queries that you can reuse later, merge different tables in one step, delete and create new ranges, or transform data before importing it into a spreadsheet. You will receive your data ready for analysis.