Choose How to Import the Data
Looking for help with Power Pivot in Excel 2013? Go to Power Pivot Help on Office.com.
This page of the Table Import Wizard enables you to choose how to import data from the selected data source. To access the wizard from the PowerPivot window, on the Home tab, in the Get External Data group, click the type of data source from which you want to import tables.
Select from a list of tables and views to choose the data to import
Select this option if you want to import data by selecting from a list.Note
This option is available only when the selected data source exposes schema information that the Table Import Wizard supports.
Write a query to specify the data to import
Select this option if you want to import data by using a SQL query. The SQL query can manipulate the data that is imported. For example, you could join data from different tables or select only rows that meet certain criteria.
See Also
Concepts
Take a Tour of the PowerPivot UI