I have a problem on how will I connect my excel to SharePoint. I have created a list in SharePoint and I need those data sync in excel that I want to create. I'm using excel 2016 and SharePoint 2016. Please refer to this link because I think this is what I supposed to do. The problem there is that I can't see the "SharePoint List" option in my excel.
Follow the steps in this article: https://support.office.com/en-gb/article/Export-a-list-to-Excel-in-SharePoint-Online-40f4b5cd-cb8a-4106-817e-4a0bf7cd68b5
If your list on the sharePoint gets updated, you will need to Refresh connection in excel in order to get the updated data from the SharePoint List.