Add Power Query To Excel 2013

Power Query is a powerful data gathering tool included in all installations of Excel 2016. But what do you do if you’re not using Excel 2016?

If you’re a user of Office 2010 Professional Plus or Office 2013, you can install a free Add In from Microsoft to gain this capability. If you’re using Excel 2010, you’ll first need to determine whether you have Office “Professional Plus” 2010.

To check, navigate to File>Help. If the line beneath “Product Activated” on the right side of the screen says “Microsoft Office Professional Plus 2010”, you’re in luck. Next, check the line underneath “About Microsoft Excel” to determine if you have 32- or 64-bit Excel.

Remember which version you have, and head to the section “Installing the Power Query Add-In” below.

Power Query is compatible with all versions of Excel 2013, so you’ll only need to check whether you have 32- or 64-bit Excel.

To determine which installation of Excel 2013 you have, navigate to File>Account and click “About Excel” in the lower right. The top line of the window that opens will tell you whether you have 32- or 64-bit Excel.

Remember which version you have, and continue below. Before you go any further, exit Excel completely so the install can proceed.

Next, go to the Microsoft Download Center to get the add-in. On that page, choose your language and press “Download”.

You’ll be taken to another page that prompts you to choose whether you have 32- or 64-bit Excel.

Choose the appropriate one and click Next. Once the .msi file is finished downloading, run it to install the Power Query add in.

Power Query will be installed as a new Tab in your ribbon and you’ll be able to enjoy all of the great capabilities of this add-in. Power Query is an amazing data tool for Excel! It is built by Microsoft to help you import, transform, and automate your data processes.

Checkout my overview of Power Query to learn more about it. Here is a quick list of compatible versions:.

“Free” add-in for Excel 2010 and 2013 for Windows. Built-in feature for Excel 2016 for Windows (Office 365 Subscription). Click here to learn where to find it.

Power Query is not yet available for the Mac versions of Excel.

This page will help you determine if you have the right version of Excel, and provide installation instructions. The download page for Power Query lists which version of Excel are compatible with Power Query.

The following Office versions for Windows are supported:.

Microsoft Office 2016 – All Versions. Microsoft Office 2013 – All Versions.

Microsoft Office 2010 Professional Plus with Software Assurance. Both 32-bit and 64-bit are supported.

Power Query is not compatible with any Mac versions of Excel yet. Unfortunately, if you don't have these versions you will need to upgrade to use Power Query.

To me, Power Query is worth the upgrade to Office 365 alone, and there are a lot of other cool new features too.

Here's how to determine your version and 32 or 64 bit in Excel 2010:.

Click the File button. Click the Help option on the left side menu. The Excel version will be listed under the Product Activated section.

The bit version (32-bit or 64-bit) will be listed under the About Microsoft Excel section.

If your Excel looks like the screenshot above, then you are in luck! 🙂 Again, you will need the Professional Plus version of Excel 2010.

Here's how to determine your version and 32 or 64 bit in Excel 2013:. Click the File button.

Click the Account option on the left side menu. The Excel version will be listed under the Subscription Product section. Click the About Excel button.

The bit version (32-bit or 64-bit) will be listed in the first row of the pop-up window. Power Query is included with Excel 2016 (Office 365).

It has been renamed and is now on the Data tab of the Ribbon in the Get & Transform section.

This means there is nothing to install.

If you are using Excel 2016, go to the Data tab on the ribbon and press the New Query button to create a query and open the Power Query editor. Power Query is available with all levels of Office 365 subscriptions.