What is Power Query?
Power Query is a new add-ins for Excel 2010 & Excel 2013 and you can download it for free at this page: http://www.microsoft.com/en-us/download/details.aspx?id=39379.
This add-in is still in Preview version, so it is possible that there are some difference between your version and the screenshot in these articles.
Once you have downloaded and installed the add-in, you have to activate it in the menu File > Options > Add-ins. There, you select COM Add-ins in the dropdown list and you press Go …
A new dialog box appears with all the add-ins install on your computer. Select the add-ins Microsoft Power Query for Excel and press OK.
Then, a new tab Power Query appears on the ribbon of Excel.
Import without Power Query
Most of the time, the data is imported in Excel through csv files. With the classic import wizard, you can only specify
- the columns width
- the delimiter
- the type of data (standard, text, date)
More important, with this classical technique, you must re-execute the same process each time you want to re-import a csv file with the same structure. But with Power Query, the process of importation will be automatically generated for each new csv file.
Import with Power Query
When you import your data (csv file, excel file, access, sql server, microsoft azure, open data, ….) in Excel, you create a query for the importation.
A query is a kind of program to manipulate your data and you don’t need to create a macro Excel to reorganize your data after the import.
In the following articles, you will find a lot of new techniques to import easily your data in Excel.