SPJeff

For bulk editing of SharePoint list data, we used to have Datasheet (ActiveX control) in the old MOSS 2007 / SP2010 days.   SP2013 gave us Quick Edit (JavaScript based) with compatibility across multiple browsers and works well for simple edits.

However, sometimes we want a more robust bulk edit.  Sort, filter, keyboard navigation, copy/paste, and more full features.   MS Access can help with the “External Data” feature.

Now we can make changes to SPList with MS Access for a faster advanced user experience than Quick Edit in the browser.

Cheers! 

Steps

1. Open MS Access
2. Create new database
3. Click “External Data”
4. More: SharePoint List
5. Type in your site URL:  https://tenant.sharepoint.com/sites/team
6. Link to the Data Source
7. Next
8. Select the list
9. OK

Screenshots

References

• Things to Know about SharePoint 2013 Quick Edit – Part 1
• Import or link to data in a SharePoint list