Converting the spreadsheet into a list

Here are the steps we took to convert an Excel spreadsheet to a SharePoint list.

1. Browse to the Create page in your site by click on the All Site Content on the quick launch. 
2. Click the Import Spreadsheet link in the Custom Lists section. The New List page opens.
3. Type the name for the list in the Name field, and then type a description for the list in the Description field.
4. Click the Browse button. Locate the Excel spreadsheet that contains the data you want in your list, then click on the file name, and then click the Open button.
5. Click the Import button on the New List page. The Import to SharePoint list dialog box opens.
6. Click the Range of Cells option in the Range Type drop down list.
   
   
    
7. Click the button on the Select Range drop down list. Your Excel spreadsheet opens with the Import to Windows SharePoint Services window.
   
   
    
8. Click and drag to highlight the areas of your spreadsheet you want to be included in your list. Be sure to include the column headings; they will become the field names and column titles in the list.
9. Click the button on the Import to Windows SharePoint Services window. The Import to Windows SharePoint Services list dialog box opens.
10. Click the Import button.  Your list is created.