Question: how to connect excel spreadsheet to sharepoint list?
Answer: SharePoint List settings. Click Submit to begin the initial discovery of available lists. ... 
View a SharePoint list. ... 
Edit the data connector and click Define Structure. ... 
SharePoint Excel Services settings. ... 
View Excel data. ... 
Select a table. ... 
Select a column.