Import and analyze data

Import and analyze data

You can use Excel's Get & Transform (Power Query) experience to connect to multiple data sources, then use the Query Editor to shape and transform data.

Getting Started with Get and Transform

Import data from external data sources

View and Manage Queries in a Workbook

Add a query to an Excel worksheet

Introduction to the Query Editor

Shape data

Edit Query Step Settings

Get support
Contact us
Expand your Office skills
Explore training

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.