Microsoft Power Query für Excel

Microsoft Power Query für Excel is a data integration and transformation tool developed by Microsoft Corporation. It allows users to connect to, transform, and import data from various sources into Excel spreadsheets.

The tool features an intuitive graphical interface that allows users to easily connect to a variety of data sources, including SQL Server databases, Microsoft Azure, SharePoint lists, CSV and Excel files, as well as various cloud-based data sources.

Once connected to the data source, users can use the tool's built-in transformation capabilities to clean, transform, and shape the data as needed. This includes features such as data filtering, sorting, merging, grouping, and pivoting.

With Microsoft Power Query für Excel, users can also create reusable transformations and build complex data models that can be shared across multiple workbooks. The tool also supports the creation of custom functions and transformations using the M formula language.

Microsoft Power Query für Excel is a powerful data integration and transformation tool that provides users with an easy-to-use interface for importing and transforming data from multiple sources into Excel spreadsheets.

Note: Microsoft Power Query für Excel is currently only available for Windows versions of Excel.