Legacy Update: Get back online, activate, and install updates on your legacy Windows PC

Microsoft Power Query for Excel is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery, access and collaboration. (Note: The Microsoft Power Query add-in for Excel 2010/2013 is no longer being updated by Microsoft. Please upgrade to a newer Excel version.)

• The Microsoft Power Query add-in for Excel 2010/2013 is no longer being updated by Microsoft. You can still download this version, but if you want to access new Power Query capabilities please upgrade to Excel 2016 or newer, where Power Query capabilities are integrated within the Data tab. More information
  
  Microsoft Power Query for Excel, is a new add-in that provides a seamless experience for data discovery, data transformation and enrichment for Information Workers, BI professionals and other Excel users.
  
  With Power Query you can:
  • Identify the data you care about from the sources you work with (e.g. relational databases, Excel, text and XML files, OData feeds, web pages, Hadoop HDFS, etc.).
  • Discover relevant data from inside(*) and outside your organization using the search capabilities within Excel.
  • Combine data from multiple, disparate data sources and shape it in order to prepare the data for further analysis in tools like Excel and Power Pivot, or visualization in tools like Power View and Power Map.
  • Share the queries that you created with others within your organization, so they can be easily found via Search. (*)
  
  (*) This capability requires Power BI for Office 365. You can learn more at Power BI for Office 365.

Files

Status: Live This download is still available on microsoft.com. The downloads below will come directly from the Microsoft Download Center.

File	Size
PowerQuery_2.62.5222.761 (32-bit) [en-us].msi SHA1: 5205097b14ce10cdfc655f165ee9c3d234184f25	16.62 MB
PowerQuery_2.62.5222.761 (64-bit) [en-us].msi SHA1: a0bebbdefa60f8ce5e7d10adc277178efb01873e	16.70 MB
Release Notes (English-only).docx SHA1: 9c4a7a5c7dbc12d751d6dc9a50ddf1cedfb05a07	27 KB

File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.

• • Windows Server 2008 R2
  • Windows Server 2012
  • Windows 7
  • Windows 8
  • Windows 8.1
  
  The following Office versions are supported:
  • Microsoft Office 2010 Professional Plus with Software Assurance
  • Microsoft Office 2013:
  • Power Query Premium: All Power Query features available for: Professional Plus, Office 365 ProPlus or Excel 2013 Standalone
  • Power Query Public: Available for all other Office 2013 Desktop SKUs. Includes all Power Query features, except the following ones: Corporate Power BI Data Catalog, Azure-based data sources, Active Directory, HDFS, SharePoint Lists, Oracle, DB2, MySQL, PostgreSQL, Sybase, Teradata, Exchange, Dynamics CRM, SAP BusinessObjects, Salesforce.
  
  Microsoft Power Query for Excel requires Internet Explorer 9 or greater.
  
  Microsoft Power Query for Excel is available for 32-bit (x86) and 64-bit (x64) platforms, your selection must match architecture of the installed version of Office.

• Download the version of the Power Query add-in that matches the architecture (x86 or x64) of your Office installation. Run the MSI installer and follow the setup steps.