In this post we will discuss how to upload excel data to SharePoint using Import Spreadsheet option in SharePoint 2013. It will create list as well as it add columns what are there in the excel sheet and upload data to it. But this feature will work only in those browser that support ActiveX. Else it will give an error like "This feature requires a browser that support ActiveX controls.". So it will work fine in Internet Explorer browser.
Also check out:
From the Settings Icon click on Add an app. The select Import Spreadsheet App as shown in the fig below:
Then in the Next page, Give the name and description and then choose the spreadsheet (excel) file. And then click on Import.
Then it will open the Import to Windows SharePoint Services List. There select the Range of Cells from the Range Type: And then put the cursor in the Select Range, it will allow you to select whatever you want to add from the excel. see pics below.
Then click on Import. This will create the list like below which will include the column names also.