Use Excel's Get & Transform (Power Query) experience to create an external data connection instead of importing data into your workbook. This way, you can always have the latest data available. Excel, Excel, Excel, Excel ZXL120, ZXL140, ZXL150, ZXL160, ZXL190, ZXL900. Power Query offers several ways to create and load Power queries into your workbook. You can also set default query load settings in the Query Options window. Tip To tell if data in a worksheet is shaped by Power Query, select a cell of data, and if the Query context ribbon tab appears, then the data was loaded from Power Query.
Quickly and effortlessly enhance the self-service Business Intelligence experience in Excel by simplifying data discovery and access
Microsoft Power Query for Excel (formerly known as Microsoft 'Data Explorer' Preview for Excel) is a software solution that was designed to provide computer users with a seamless experience for discovering data and transforming it for BI professionals, Information Workers and other users as well.
Microsoft Power Query for Excel is capable of identifying the data you care about from the sources you work with such as relational databases, Excel, text and XML files, OData feeds, web pages or Hadoop HDFS. More so, using this app you'll be able to discover various relevant data bits by making use of the search capabilities within Excel.
Furthermore, combining data from multiple, disparate data sources and shaping it in order to prepare the data for further analysis in tools like Excel and PowerPivot is also possible when using this software solution.
It comes in two flavors, 32- and 64-bit, so you can choose whatever version suits your needs the best by downloading the package you want and deploying it on the target computer. The installation process is highly uncomplicated, as you're only required to follow the on-screen instructions provided by the wizard. The rest of the process is carried out without any additional assistance on your side.
System requirements
Filed under
New in Microsoft Power Query for Excel 1.5.3296.2082:- Improved error in the case where a query is trying to connect to a non-existent file
- Implemented more robust protection against out of memory issues when loading data into the workbook
- Improved behavior for disabling Online Search in restricted markets
- Other non-user facing bugs were fixed too
Install Power Query Excel 2010
Power Query Download 2010
This enables Disqus, Inc. to process some of your data. Disqus privacy policyMicrosoft Power Query for Excel 2.59.5135.201
add to watchlistsend us an update- runs on:
- Windows 2008
Windows 8 32/64 bit
Windows 7 32/64 bit
Windows Vista 32/64 bit - file size:
- 17 MB
- main category:
- Programming
- developer:
- visit homepage
top alternatives FREE
Download Power Query
top alternatives PAID