Download Microsoft Power Query for Excel from Official Microsoft Download CenterWarning: This site requires the use of scripts, which your browser does not currently allow.
Microsoft Power Query for Excel
Select Language:
BasqueBulgarianCatalanChinese (Simplified)Chinese (Traditional)CroatianCzechDanishDutchEnglishEstonianFinnishFrenchGalicianGermanGreekHebrewHindiHungarianIndonesianItalianJapaneseKazakhKoreanLatvianLithuanianMalay (Malaysia)Norwegian (Bokmål)PolishPortuguese (Brazil)Portuguese (Portugal)RomanianRussianSerbian (Latin)SlovakSlovenianSpanishSwedishThaiTurkishUkrainianVietnamese
Choose the download you wantFile NameSize
PowerQuery_2.20.-bit) [en-us].msi10.8 MB10.8 MB
PowerQuery_2.20.-bit) [en-us].msi10.9 MB10.9 MB
Release Notes (English-only).docx30 KB30 KB
Download Summary:KBMBGBYou have not selected any file(s) to download.Microsoft recommends you install a download manager.A download manager is recommended for downloading multiple files.Microsoft Download ManagerManage all your internet downloads with this easy-to-use manager.It features a simple interface with many customizable options:Download multiple files at one timeDownload large files quickly and reliablySuspend active downloads and resume downloads that have failedWould you like to install the Microsoft Download Manager?Yes, install Microsoft Download Manager(recommended)No, thanks
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:There are multiple files available for this download.Once you click on the "Download" button, you will be prompted to select the files you need.
2.20.PowerQuery_2.20.-bit) [en-us].msiPowerQuery_2.20.-bit) [en-us].msiRelease Notes (English-only).docx3/4/201510.8 MB10.9 MB30 KB
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 .
Supported Operating System
Windows 7, Windows 8, Windows Server 2008 R2, Windows Server 2012
Windows Vista (requires .NET 3.5 SP1)
Windows Server 2008 (requires .NET 3.5 SP1)
Windows 8.1
The following Office versions are supported:
Microsoft Office 2010 Professional Plus with Software Assurance
Microsoft Office 2013 Professional Plus, Office 365 ProPlus or Excel 2013 Standalone
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.
Microsoft(R) SQL Server(R) 2012 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.
Microsoft SQL Server 2008 R2 Express with Service Pack 2 is a free and feature-rich database for developing and deploying SQL Server 2008 R2.
Microsoft SQL Server 2008 Management Studio Express is a free, integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server, as well as combining a broad group of graphical tools and rich script editors that provide access to SQL Server to developers and administrators of all skill levels.
Includes Windows PowerShell 3.0, WMI, WinRM, Management OData IIS Extension, and Server Manager CIM Provider
Microsoft SQL Server 2014 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.
Loading your results, please wait...
Security patches
Software updatesService packsHardware driversExperience the new and enhanced capabilities.电脑教程_计算机子分类Microsoft Office Excel - 电子表格软件Excel 可用于您的各个设备。安装 Excel 移动应用程序，即使身在途中也能高效工作。Excel 可用于您的各个设备。安装 Excel 移动应用程序，即使身在途中也能高效工作。在电子表格或工作簿中整理您的数字或文本数据。在相关背景下查看数据有助于您做出更明智的决策。当您尝试不同设置时，Excel 可以学习和识别您的模式，并自动填充剩余数据，为您省时省力。无需任何格式或宏。Excel 为您快速执行复杂分析。它可汇总您的数据，让您预览各种数据透视表选项。因此，您能够加以比较，并选择最能揭开数据背后的故事的选项。在电子表格或工作簿中整理您的数字或文本数据。在相关背景下查看数据有助于您做出更明智的决策。当您尝试不同设置时，Excel 可以学习和识别您的模式，并自动填充剩余数据，为您省时省力。无需任何格式或宏。Excel 为您快速执行复杂分析。它可汇总您的数据，让您预览各种数据透视表选项。因此，您能够加以比较，并选择最能揭开数据背后的故事的选项。Excel 就是您的知心向导，为您推荐最能展示数据模式的图表和图形。快速预览您的选项，并选择其中最清晰地展示数据背后的真知灼见的选项。以不同的方式进行探索和比较，直观显示您的数据和意图。在您发现最能展示数据的方式后，只需单击一次即可应用格式设置、迷你图、图表和表格。使用柱形图、颜色和图表，形象地突出重要值，轻松发现数据中的趋势和模式。Excel 就是您的知心向导，为您推荐最能展示数据模式的图表和图形。快速预览您的选项，并选择其中最清晰地展示数据背后的真知灼见的选项。以不同的方式进行探索和比较，直观显示您的数据和意图。在您发现最能展示数据的方式后，只需单击一次即可应用格式设置、迷你图、图表和表格。使用柱形图、颜色和图表，形象地突出重要值，轻松发现数据中的趋势和模式。Excel 就是您的知心向导，为您推荐最能展示数据模式的图表和图形。快速预览您的选项，并选择其中最清晰地展示数据背后的真知灼见的选项。以不同的方式进行探索和比较，直观显示您的数据和意图。在您发现最能展示数据的方式后，只需单击一次即可应用格式设置、迷你图、图表和表格。使用柱形图、颜色和图表，形象地突出重要值，轻松发现数据中的趋势和模式。显示 Excel 电子表格共享选项的 PC 显示屏。所有人都只会获得最新版本，因为默认情况下，OneDrive 或 SharePoint 会在云中存储您的电子表格。向每个人发送同一个文件的链接，整个团队即可随时随地访问。将电子表格保存到 OneDrive，您和您的团队即可通过 Excel Online 实时协作。显示 Excel 电子表格共享选项的 PC 显示屏。所有人都只会获得最新版本，因为默认情况下，OneDrive 或 SharePoint 会在云中存储您的电子表格。向每个人发送同一个文件的链接，整个团队即可随时随地访问。将电子表格保存到 OneDrive，您和您的团队即可通过 Excel Online 实时协作。在 Windows Phone、iPhone(R)、iPad(R)、Android 手机或 Web 上访问、编辑和查看文档。Office Mobile 和 Office Online 让您即使身在途中，也能做好工作。使用模板彰显您的风格和专业，并大大节省时间和精力。40 多个类别的 Word 模板供您浏览。查看最新功能，获得经典提示和编辑技巧，帮助您像专业人士那样创建、编辑和润色文档。iPhone 和 iPad 是 Apple Inc. 在美国和其他国家/地区注册的商标。{"pmgControls":[{"functionName":"PinnedNav","params":"#pmgPDN|#pmgPinnedNavStart|top|.pmg-pinned-nav-highlighted|true||680|.pmg-pinned-end-point|500"},{"functionName":"CustomTooltip","params":""},{"functionName":"BtnFlyout","params":"#container1|.targetBtn1|.dropDownCtn1"},{"functionName":"BtnFlyout","params":"#container2|.targetBtn2|.dropDownCtn2"},{"functionName":"BtnFlyout","params":"#container3|.targetBtn3|.dropDownCtn3"},{"functionName":"BtnFlyout","params":"#container4|.targetBtn4|.dropDownCtn4"},{"functionName":"BtnFlyout","params":"#container5|.targetBtn5|.dropDownCtn5"},{"functionName":"BtnFlyout","params":"#container6|.targetBtn6|.dropDownCtn6"},{"functionName":"BtnFlyout","params":"#container7|.targetBtn7|.dropDownCtn7"},{"functionName":"BtnFlyout","params":"#container8|.targetBtn8|.dropDownCtn8"},{"functionName":"AddDynaCss","params":"#Dynacss|pmg-pos-abs pmg-txt-align-left|680"},{"functionName":"AddDynaCss","params":"#planattr|pmg-pos-abs|680"},{"functionName":"AutoMiddle","params":".pmgJS-frame1|.pmgJS-target1"},{"functionName":"AutoMiddle","params":".pmgJS-frame2|.pmgJS-target2"}]} {"pmgControls":[{"functionName":"Accordion","params":".pmg-mobile-accordion-wrapper|.pmg-mobile-accordion-btn|.pmg-mobile-accordion-content|.pmg-mobile-accordion-showIcon|.pmg-mobile-accordion-hideIcon||680"}]}