The challenge
Business users needed to move list data out to Excel and back without breaking it, including large lists past SharePoint's 5,000-item view limit and lists with many lookup columns.
What we built
We built a SharePoint web part that works as a series of steps: choose a site and list, upload, map columns, validate, preview, import and review the result. It runs on a SharePoint page or as a Teams tab.
Columns are mapped automatically by name, and mappings can be saved as templates. Every supported field type is validated, errors are reported row by row in plain language and can be corrected in place, and exports stay complete past list limits.
Outcome
Working, with automated tests and an implementation guide. Known limits: legacy .xls files must be re-saved as .xlsx, some column types export but do not import, deleting records is not supported, and browser memory limits practical size to about 100,000 rows.