Are there tools available for importing an Excel file to a SharePoint list so that the importing data would be synchronized based on specified field(s)? I would mostly be interested in a non-commercial solution.
EDIT: Ended up writing a custom solution:
- Read rows from Excel via OpenXML
- Match an id column to similar SharePoint field
Web UI has a couple of steps:
- Browse for Excel
- Preview changes
Excel parsing was pretty simple. Synchronizing to SharePoint also would be pretty straightforward (if not aiming for a lot of generalization).