To complete the previous answer, it is actually possible to do two-way data synchronization between Excel and a SharePoint list, but you need to use third party products, such as the one my company has developed: [SharePoint list Synchronizer][1].


  [1]: https://www.softfluent.com/product/sharePoint-list-synchronizer/