Question: how to import excel data into sharepoint list 2016?
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.