Connect to a Microsoft Excel File
This page of the Table Import Wizard enables you to connect to a Microsoft Excel file stored on the local machine. 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. For more information about supported data sources, see Data Sources Supported in PowerPivot Workbooks.
Friendly connection name
Type a unique name for this data source connection. This is a required field.Excel File Path
Specify a full path for the Excel file.Browse
Navigate to a location where an Excel file is available.Advanced
Set additional connection properties by using the Set Advanced Properties dialog box. For more information, see Set Advanced Properties.Use first row as column headers
Specify whether to use the first data row as the column headers of the destination table.Test Connection
Attempt to establish a connection to the data source using the current settings. A message is displayed indicating whether the connection is successful.