Table of Contents
Download & Install Microsoft Power Query
- Check the Excel version – Is it 32 bit or 64 bit?
Go to File Menu –> Account –> About Excel (visible in the End on first row) - Click on the link to download Microsoft Power Query
http://www.microsoft.com/en-us/download/details.aspx?id=39379 - Click on the Download button
- Select the 32 bit or 64 bit version (This should be same as the version we checked in Point 1)
- Click on the set up and finish the installation (Close all the instances of Excel)
Activate Power Query
- Power Query tab should be visible once the installation is complete.
- In case the Power Query tab is not visible, follow the below steps
- Go to Developer Tab –> COM Add-ins –> Microsoft Power Query for Excel
- Click Ok
Steps to enable Developer Tab
- Enable Developer Mode from File -> Options -> Customize Ribbon -> Check Developer
- Click ok