For a specific use case, I need to synchronize/update all items in a SharePoint 365 List with fresh data from an excel sheet.
If the sheet contains new items, they should be added to the list. If items are removed, they should be removed from the list.
The Excel sheet has a column with a unique identifier that can serve as primary key.
I’m looking for a way to do this without any additional coding.
- Does SharePoint have a built-in way to do this?
- Are there any pitfalls that I should be aware of?
Things I’ve tried:
- Paste into Quick Edit window. This is tedious and slow, and seems to crash often. Also I’m worried that this will inevitably create inconsistencies due to human error.