Import data from external data sources

With Microsoft Power Query for Excel, you can import data into Excel from a wide variety of data sources. You use the Query Editor to edit query steps to shape or transform data. For more information about how to combine data sources using the Query Editor, see Shape data.

 Note    Before you can combine data sources into specific data that match your data analysis requirements, you connect to a data source based on your data source Privacy Levels settings.

I want to

Import Data from Web

Connect to a web page

Import Data from File

Import Data from Database

Import Data from an Excel data table

Connect to an SAP BusinessObjects BI Universe

See Also

Microsoft Power Query for Excel Help

Data Management Experience in Power BI for Office 365 Help

Top of Page Top of Page

Applies to:
Excel 2013, Excel 2010