107

The Complete Guide to Installing Power Query

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.

Complete Guide to Installing Power Query

This page will help you determine if you have the right version of Excel, and provide installation instructions.

Video Guide to Installing Power Query

What Version Do I Need?

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.

How Do I Check My Version of Excel?

Excel 2010

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

  1. Click the File button.
  2. Click the Help option on the left side menu.
  3. The Excel version will be listed under the Product Activated section.
  4. The bit version (32-bit or 64-bit) will be listed under the About Microsoft Excel section.

Excel 2010 Version and 32 or 64 bit

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

Excel 2013

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

  1. Click the File button.
  2. Click the Account option on the left side menu.
  3. The Excel version will be listed under the Subscription Product section.
  4. 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.

Excel 2013 Version and 32 or 64 bit

How to Install Power Query

Excel 2016

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.

Power Query in Excel 2016 for Windows Data Tab of Ribbon Get and Transform

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.  Here is an article that explains the features available for each subscription level.

It's important to note that there are some differences in Power Query for different builds of Excel 2016.

If you are on the MSI (Windows Installer) version then you will not get frequent updates to Power Query.  Your ribbon might look different from mine, and you won't have all the latest features.

If you are on an Office 365 subscription then you have the Click-to-run version and you should get all the latest updates.   Here is an article on how to determine which version of 2016 your are on.

If you are on the ProPlus version of Office 365 then you might be on the Deferred Channel.  The name of the Deferred Channel has been changed to Semi-Annual Channel as of September 2017.  This means you get updates every six months instead of every month.

Here is an article about the different channels for Office 365 ProPlus.

Here is an article on how to switch channels.

All the versions and channels make this very confusing, to say the least.  Hopefully this guide helps you figure out how to get Power Query for Excel 2016.

Checkout my article on an Overview of Power Query to learn more about this awesome tool!

Excel 2010 & 2013

For Excel 2010 and 2013 you will need to download the Power Query add-in and install it.

The installation steps are about the same in Excel 2010 and 2013.

  1. Close (exit) Excel completely.
  2. Click the following link to go to the download page.
    http://www.microsoft.com/en-us/download/details.aspx?id=39379
    Power Query Download Page
  3. Click the Download button.
  4. Click the checkbox for the bit version you are using.  Most likely you will be using 32-bit.
    Download Power Query Select Bit Version
  5. Click Next
  6. The add-in installation file will download.  Click the file to run the installation.
    Power Query Run Installer
  7. The Setup Wizard window will open.  Follow the steps to install Power Query.
    Power Query Installation Window - Setup Wizard
  8. Once the installation is complete, open Excel.  You should now see the Power Query tab in the Ribbon.
    Power Query Tab of the Ribbon Excel 2010Power Query Tab of the Ribbon Excel 2013

My Power Query Tab Disappeared

If your Power Query tab ever goes missing, you can usually re-enable the add-in by going to the COM Add-ins menu.

There are a few ways to get to the COM Add-ins menu.

  1. File menu.
  2. Click Options on left side menu.
  3. Click Add-ins on left side menu.
  4. Select COM Add-ins from the Manage drop-down.
  5. Click the Go… button
    Excel 2010 Options Menu for COM Add-ins
  6. That will open the COM Add-ins Window.  If the Power Query check box is not selected, just select it to reload the add-in.
    COM Add-ins Menu for Power Query

There is also a button on the Developer tab that will take you directly to this window.

COM Add-ins Button on the Developer Tab of the Excel Ribbon

Getting Started with Power Query

Power Query is my favorite tool for working with data in Excel.  If you are not familiar with what Power Query can do, checkout my article on an Overview of Power Query to learn more.

 

Please leave a comment below with any questions.

Click Here to Leave a Comment Below 107 comments
Jennifer - October 19, 2018

The video I watched was super clear. Thanks

Reply
Joe Blackburn - July 21, 2018

Power Query is returning the dreaded “The server committed a protocol violation. Section=ResponseHeader Detail=CR must be followed by LF”

I am using Office 365 Excel 2016.

How do I fix this specifically for Excel – I’m not using Viusal Studio or IIS.
When I Google the error message, I only see fixes for IIS or VS.

Note: The same query works fine on Excel 2013 on Windows 7. I am connecting to an Ancestry.com search results page…

Reply
Daniela - June 30, 2018

I have Microsoft Home & Student 2010 – Excel Version 14.0.7208.5000 (32 bit) .. So I guess I am out of luck to obtain Power Query.

Reply
Ann - June 9, 2018

my problem is example A2 has a name, A2:A15 are blank B2:B15 has data attributed to A2, how do I get the name in A2 to fill in to A15? Will power query do this?

Reply
Office 365 Support - June 4, 2018

Another very strong and powerful post I’ve read some of your previous posts and finally decided to drop a comment on this one. I signed up for your newsletter, so keep up the informative posts!

Office 365 Support

Reply
Michael Robson - June 2, 2018

this was a huge help! Thank you very very much

Reply
Larisa Golovko - May 31, 2018

I am on 2016 Pro with all updates current, however, there is no Power Query tab, neither is available on COM addins. There is Inquire add on, which I enabled, bot this is not Power Query …

Reply
Sajeda Khalifa - May 17, 2018

Hi Jon,

I have Microsoft Office 2010 Professional Plus 32 bit but when I have followed the instructions it is stating that I need to install Microsoft SP 2010. Any idea why this is occurring?

Thanks

Reply
Angelica - February 23, 2018

I have Excel 2011. Can I use the same procedure to install Power Query?
Thank you for your time,
Angelica

Reply
Vince D. - January 17, 2018

Thanks Jon!

One stop shop for PowerQuery installations. I just installed Office 365 and I could not locate the PowerQuery ribbon.

Thanks for easing my panic.

Best regards,

Vince

Reply
Grant - January 16, 2018

I have 2016 Excel and still don’t have it. (I’ve checked Data tab, I have FileMaker, From HTML, From text, New Database Query but none ” From Web”) I am on a mac, however.

Reply
    Jamie Cameron - February 21, 2018

    “From Other Sources” >> “From Web”?

    Reply
Olly - December 15, 2017

This is an excellent, clear resource for introducing people to Power Query. Thanks!

Reply
Nitin Gupta - October 29, 2017

Hi, I am getting the same error. I have 32bit version office 2010 and I am installing 32bit version Power Query. Please help me in installing power query to excel. Thanks

Reply
Mohamed Elagami - October 20, 2017

Thanks

Reply

Leave a Reply: