Forum Discussion
Excel workbook to a Sharepoint List
Our customers typically integrate Excel with SharePoint lists (and many other apps) https://www.layer2solutions.com/support/cloud-connector-faqs/office-365-integration-excel-files-to-cloud. It works for example with Excel on-prem (e.g. on a file share) and SharePoint Online or Server on-prem. It can be used for migration (Excel to SharePoint), but also for a permanent sync of changes. Best to create your SharePoint list as needed and map the columns / fields to each other. Some "translations", for example to Excel strings to SharePoint lookups can be implemented using Dynamic Columns (a few lines of C# if needed). Hope that helps, Frank.
Thanks for this Frank, i am going to give the trial a whirl and see if it is what i need. We have a lot of Excel sheets which may benefit from being in a list format.