Share via


Preview Selected Table

This page of the Table Import Wizard enables you to preview the data in the selected table, to select the columns to include in the data import, and to filter data in the selected columns. 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.

Not all the rows in the table are displayed. However, the filters that you set will be applied to all of the data in the table during import.

  • Checkbox in the column header
    Select the checkbox to include the column in the data import. Clear the checkbox to remove the column from the data import.

  • Down-arrow button in the column header
    Filter data in the column.

  • Clear Row Filters
    Remove all filters that were applied to the data in the columns.