Get & Transform and Power Pivot in Excel

Your browser does not support video.

Identify Insights Faster

With Get & Transform and Power Pivot in Excel, you'll spend less time manipulating data, and more time driving impact. Watch this 2-minute video to learn how.

See it for Yourself

Whether it's small data sets or large ones with up to millions of rows, you can connect, clean, analyze, and share your data faster. This 10-minute learning guide will show you how.

Other Resources

For more information on this powerful data analysis experience in Excel, check out our other resources:

  • Virtual Labs – These hands-on labs go deeply into Get & Transform and Power Pivot within a virtual environment.

  • Analytics Course – For the analytics enthusiast, we offer a free self-guided course on these capabilities, complete with videos, labs, and references.

  • Excel Tech Community – Talk about analytics with the new Excel community. Plus, learn new tips and tricks, or share your experiences with data analysis.

  • General Excel Support – Visit the main Excel support page for more information on analytics or other topics.


With Microsoft 365 Apps for enterprise, the Excel app on Windows for PCs offers the full Get & Transform and Power Pivot features that further enhance your analytics and modeling capabilities, take advantage of advanced data connectivity options, and effectively share your data across the organization. See the details below for more information on Get & Transform and Power Pivot availability and ask your IT team if your current Office plan supports these features.

Basic business analytics features

Basic analytics features are available with any Microsoft 365 subscription or any Office 2016 one-time purchase. Such features include PivotTables, slicers, charts and some Get & Transform and data model capabilities. With Get & Transform, you can import, shape, and merge data from files, databases and websites. Basic data model support allows you to load data to the data model, detect relationships automatically, add time grouping, and create DAX measures.*

Advanced business analytics features

Advanced analytics features are available with Microsoft 365 Apps for enterprise, Office 2016 Professional, Office 2016 Professional Plus, and Excel 2016 standalone one-time purchases. In addition to the basic analytics features, you can use Get & Transform to import, shape, and merge data from corporate, big data, and cloud data sources, conduct corporate data catalog search, and share queries. Advanced data model support with Power Pivot includes a dedicated data modeling editor, a data view, DAX calculated columns, KPIs, and hierarchies.

* Learn more about the 64-bit versus 32-bit version of Office to maximize performance.

Excel 2016/2019 for Mac have many of the same basic analysis features that are listed above: PivotTables, slicers, charts, and basic import capabilities. They do not yet have Get & Transform or Power Pivot, but we are continually improving Excel on the Mac.

Excel for Microsoft 365 for Mac offers some support for Power Query.

Get & Transform provides fast, easy data gathering and shaping capabilities. Get & Transform enables you to connect, combine, and refine data sources to meet your analysis needs. Learn more about Get & Transform.

Power Pivot allows you to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily. You can use the Data Model and a collection of tables to create relationships stored as part of the workbook. The Data Model integrates deeply with other features in Excel, such as tables and Pivot Tables, to provide a seamless analytics experience. Learn more about data analysis and modeling with Power Pivot.

Power BI is a suite of business analytics tools that deliver insights throughout your organization. With Power BI Desktop, you can connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis. You can also produce reports and then publish them for your organization to consume on the web and across mobile devices. Everyone can create personalized dashboards with a 360-degree view of their business. Governance and security tools are built-in. Learn more about Power BI.

Excel 2016 and Power BI Desktop deliver a portfolio of tools that is unique in the industry. Together, they enable business analysts to more easily gather, shape, analyze, and visually explore their data. Power BI is a suite of business analytics tools that deliver insights throughout your organization. It helps anyone in your organization bring together data from a wide range of sources—Excel workbooks, on-premises corporate data, Azure services, and other popular cloud-based offerings like or Marketo—to view and share using live dashboards and interactive reports. Learn more about how Power BI and Excel work together.

For Microsoft 365 subscribers, Excel 2016 has added enhancements to the functionality and features you're already used to.

Learn about the newest features in Excel 2016 for Windows

Learn about the newest features in Excel 2016 for Mac

Need more help?

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.