We have migrated a lot of sites from SharePoint 2007 to SharePoint 2013.

I observed a very unique behaviour, if my SharePoint 2007 list contained a Access Datasheet view, they remain the same and I see Access based Datasheet view.

However I dont have any way of creating the datasheet view in the old way. It uses Quick Edit view which is pretty slow in Internet Explorer.

Do we have any workaround through which I can create the datasheet view in the old access way?


2 Answers 2


For those who prefer on using the good old SP2010 Datasheet view in SharePoint 2013, we've created a free solution:


Note: I work for this company.


On the SharePoint 2013 site, instead of Quick Edit view, I needed to show the SharePoint list in the datasheet view like 2010/2007. After trying several different settings I figured, If the site is created using the Publishing Site Template, the old datasheet view is still available.

If the site is created using Team Site template, enabling publishing feature will not help. We will need to manage with Quick Edit.


  • I'm not able to duplicate this in an on-premises 2013 environment.
    – Jane Panda
    Commented Oct 31, 2017 at 13:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.