If you're working with Excel 2010 or Excel 2013, you need to explicitly download and install the Power Query add-in. As of this writing, the Power Query add-in is available to you only if you have one of these editions of Office or Excel:
- Office 2010 Professional Plus: Available for purchase through any retailer
- Office 2013 Professional Plus: Available through volume licensing only
- Office 365 Pro Plus: Available with an ongoing subscription to Office365.com
- Excel 2013 Stand-alone Edition: Available for purchase through any retailer
Note that Microsoft offers Power Query for both Excel 2010 and Excel 2013 in both 32- and 64-bit platforms. Be sure to download the version that matches your version of Excel as well as the platform on which your PC is running.
After the add-in is installed, activate it by following these steps:
- Open Excel and look for the Power Query command on the Insert tab. If you see it, the Power Query add-in is already activated. You can skip the remaining steps.In Excel 2010 and 2013, the Power Query add-in is exposed via its own tab on the Ribbon.
- From the Excel Ribbon, choose File→Options.
- Choose the Add-Ins option on the left, and then look for the Manage drop-down list at the bottom of the dialog box. Select COM Add-Ins and then click Go.
- Look for Power Query for Excel in the list of available COM add-ins. Select the check box next to each one of these options and click OK.
- Close and restart Excel.