Import SpreadSheet in SharePoint 2010

Step 1) Select Import SpreadSheet template in Sharepoint site as shown below

        Click on Create
Step 2)   Enter Name, Desc, Select excel file located in Harddisk as shown below

         
Step 3) Click on "Import" --> Excel  file will be opened
             in Excel Sheet  in first arrow -->select Range of Cells
                                    in Second Arraow -> click on it ,it will allow user to select Excel sheet range

Select the range by pressing Shift from starting cell A1 to D4

Range will appear shown in first arrow then click on second arrow

Then click on "Import"


List will be created in Sharedpoint site as shown below.
Name =SalesDetails with data.