Question: how to import data from excel in sharepoint?
Answer: Click on the settings gear and select 'Add an app'.
Search for Excel and select the Import Spreadsheet app.
Give the app a name and browse to the Excel file you want to import.
Enter the URL of the SharePoint site to where you want to import the Excel table.