Create a Custom List from an Excel File

To create a custom list from existing Excel data:

  1. Click on the down arrow on Site Actions to open the menu.
  2. Click on the “More options…” link on the Site Actions menu.
  3. On the Create window in the Installed Items section, scroll down and select Import Spreadsheet.
  4. Click on the Create button.
  5. In the Import from Spreadsheet section of the New window click on the Browse button.
  6. On the Choose File to Upload dialog box, locate and select the data file to be uploaded.
  7. Click on the Open button.
  8. On the New page click on the Import button. The spreadsheet will open in Excel. The “Import to Windows SharePoint Services List” dialog box will be presented.
  9. In the “Import to Windows SharePoint Services List” dialog box, select the range type and range.

    To select the cells from the spreadsheet, select Range of Cells from the Range Type.

    To select an existing range using the Select Range menu, select Table range and Named Range.