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.
    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.


Your email address will not be published. Required fields are marked *

  • Hi there,I’m trying to install PowerQuery_2.36.4434.1001 (32-bit) [en-us].msi, but I’m getting an error message stating that power query requires MS Excel SP1 or MS Excel 2013. I already have MS Excel installed so I don’t know what to do.

    System information:


    Please help!

  • Good Day

    I installed Microsoft office 365 version 2016, and now my microsoft query is not working anymore like it was working on previous versions. I was using it to connect to external customer database to get their data , so not I cant do my report anymore. How can fix this problem? I did check on add-ins and there is now power query there, I tried to installed it and I am getting an error message saying power query is installed already.

    Please help

  • When i tried to install it, show a message that need internet explorer 9 RTM and closse the install program.
    I have Windows 7 and office 2013 and internet explorer 8. I dont use it.
    How i can install power query?

  • Hello
    How are you?
    I am an Iranian lecturer in Excel.
    Happy to contact you.
    I wanted to know about power pivot, power query and power view.
    You did not find a comprehensive reference in Iran.
    Thanks so much

  • Installed Excel Power Query on Excel 2013 packaged in Office 2013 standard. After installation the Add-in appears in the COM Add-ins menu but when the check box is checked and OK is clicked the ADD-in does not load. Any help is appreciated, questions answered ASAP.

  • My issue..

    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 Excel 2010 SP1.

    Please help.


  • 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 search results page…

  • 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.

  • 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?

  • 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

  • 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 …

  • 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 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,


  • 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.

  • 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