With the new SharePoint 2013 custom list ‘Quick Edit’, Microsoft have removed the (very cool) DataSheet view – which used a Microsoft-Access ActiveX plug-in.
This would be for cross-browser compatibility – and other devices – but it’s left a bit of a gap with regard to editing multiple rows.
Specifically, when needing to upload rows and rows of data – such as from Microsoft Excel – case in point, with a spreadsheet I was emailed by a client.
There’s a simple step – using Microsoft Access 2013 (desktop tool).
Here’s the basics :
- Create your SharePoint list – with the columns you need.
- Eg. Name, StateCode, Suburb (list of hotels for an InfoPath lookup)
- Click on the “List Tab” and choose “Open with Access”
- When prompted, choose to “Link to data” – NOT “Export a copy”
- Flip back to your spreadsheet
- Select the columns/rows
- Right click – and hit “Copy” (or CTRL+C)
- Back to Access
- Highlight the cells – and click “Paste”
- Takes a few seconds – and then the rows appear.
I’m using Office 365 – so takes a little longer – Melbourne –> Singapore – LOL !
- Change over to SharePoint
- Click F5 to refresh the page – too easy !
Hopefully that’s a useful tip for someone – cheers !