Spend less time gathering data and more time analyzing it

Compiling data takes time that can hold up a project. You need a fast, easy way to gather and sync your data, so you can focus on analysis and forecasting.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.


Use “Get Data” in Excel or Power BI to immediately connect to various internal and external data sources, quickly transform data in a trackable/refreshable manner, and jump directly into your analysis. 

Save your analysis in Microsoft Teams to ensure one file acts as the source of truth for your colleagues. Work together in real time without having to worry about locked files or confusion around version control.


  • Spend less time compiling data.

  • Ensure your analysis is always connected to up-to-date information.

  • Save your analysis in one file as the source of truth for colleagues.

Learn More

Getting Started with Get & Transform in Excel

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

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.