From following Microsoft's documentation, I've been able to import an Excel spreadsheet into SharePoint Online as a List and also export a SharePoint List to an Excel spreadsheet. What I haven't been able to do is figure out a way to make changes in Excel and push updates to its related SharePoint List. The CRUD functions in SharePoint Lists make it tedious and inefficient to make a lot of updates in the GUI, hoping there's a way to make updates via Excel.
1 Answer
There are a few possibilities.
The last SharePoint version to support some flavor of data synchronization between Excel and SharePoint lists was circa SharePoint Server 2010 on premises. You don't specify your version, but unless you run something that old, you're out of luck.
With Office 365 you could use Power Automate to monitor the workbook, given it lives in SharePoint or OneDrive for Business, and you could use the Excel connector actions to write data from Excel to SharePoint.
The easiest, though, is to do all data entry in SharePoint and use Excel only for the reporting/data export. You can easily show/edit a SharePoint list in grid view, so you don't have to use the SharePoint list form interface to edit data.
Or you could write a user interface with PowerApps.
But a two-way sync between Excel and SharePoint is not an out-of-the-box option anymore.
2
