Microsoft Power Query for Excel

by Microsoft

Power Query for Excel is an add-in that simplifies data discovery, transformation and enrichment for Excel users.

Operating system: Windows

Publisher: Microsoft

Antivirus check: passed

Last revision: Last week

Report a Problem

Microsoft Power Query for Excel is a powerful data connector and transformation tool that enables users to easily access and analyze data from a wide range of sources. The software allows users to quickly access, transform, and combine data from multiple sources, allowing them to create powerful insights and visualizations that can be used to inform and drive better business decisions. With Power Query, users can quickly uncover hidden trends, find patterns and correlations, and gain insights into their data in ways that would be impossible with traditional methods.

Power Query provides a unified, easy-to-use user experience to access, transform, and combine data from multiple sources, such as databases, spreadsheets, text files, web services, and more. It also enables users to create powerful data mashups, combining data from different sources and transforming it into insights that are easily consumed by other users. Additionally, Power Query provides a wide range of features for working with data, such as the ability to filter, sort, group, and summarize data.

Features of Microsoft Power Query for Excel:

- Easy to use user interface for accessing and transforming data from multiple sources
- Create powerful data mashups, combining data from different sources
- Filter, sort, group, and summarize data
- Create insights from data that can be easily consumed by other users
- Ability to access data from databases, spreadsheets, text files, web services, and more
- Automatically detect data types, relationships, and anomalies
- Easy to deploy on any platform
- Automatically detect and apply data transformations
- Supports multiple languages including English, French, Spanish, German, and Chinese
- Create custom formulas to transform data
- Create scheduled refreshes to update data automatically
- Create parameterized queries with dynamic inputs
- Publish data to Power BI to create interactive reports
- Publish data to SharePoint to share with other users
- Automatically detect relationships between data sources
- Easily create and share data queries
- Create data models to explore relationships between data sources
- Create data visualizations for easy consumption
- Support for R and Python for data analysis and transformation
- Create custom data connectors to connect to any data source
- Support for Microsoft Azure for storing and analyzing data
- Connect to the Microsoft PowerApps platform for building custom apps
- Comprehensive security features for data privacy and protection
- Advanced data analysis and transformation features
- Support for data wrangling, cleaning, and preparation
- Support for Power BI Desktop, dataflows, and more
Microsoft Power Query for Excel requires the following:

• Microsoft Excel 2010 or later
• Windows 7 or later
• .NET Framework 3.5 or later
• Visual Studio Tools for Office Runtime
• Microsoft Office Primary Interop Assemblies
• Microsoft Windows Installer 4.5 or later
• An active Internet connection
image/svg+xmlBotttsPablo Stanleyhttps://bottts.com/Florian Körner
James F.

Microsoft Power Query for Excel is an excellent software for quick data transformation and analysis. I have been using it for some time now and I am very pleased with its features. It is very user friendly and simple to use. It also integrates with other Microsoft Office programs, making it very convenient to use. It allows me to easily manipulate large amounts of data in a very short period of time. The graphical user interface is also very intuitive and easy to use. I have also found that it allows me to save changes to my queries so that I can quickly modify them later. Overall, I am very satisfied with the features Microsoft Power Query for Excel provides.
image/svg+xmlBotttsPablo Stanleyhttps://bottts.com/Florian Körner
Callum I.

I found Microsoft Power Query for Excel to be reall useful for comples data analysis tasks, and it makes working with Excel a lot less tedioius and time consuming.
Violet UML Editor logo
Violet UML Editor is an open-source, cross-platform, graphical modeling tool for software design and development, built to create and edit Unified Modeling Language (UML) diagrams.
Visual Studio Live Share logo
Visual Studio Live Share is a collaboration platform that allows developers to remotely edit, inspect and debug code together in real time.
PyCharm Community Edition logo
PyCharm Community Edition is an open-source, cross-platform integrated development environment for Python programming.
Reshacker Script Creator logo
Reshacker Script Creator is a program that allows you to create and edit scripts for Reshacker, a resource editing program.
OpenCover logo
OpenCover is a free and open source code coverage tool for .NET applications.