In SharePoint 2013 the datasheet view is deprecated by Microsoft and Quick edit was promoted. Datasheet view is an ActiveX component which has tight dependency with Internet Explorer and Quick Edit is based on HTML 5, CSS and JS achieving cross platform and cross browser compatibility.
Datasheet view in legacy platform is ideal for doing bulk row edits and inserts without facing performance issues with few caveats.
How Data Sheet view works?
Datasheet view is an ActiveX component called ListNet from STSList.Dll which accept the below parameters to work properly
Pros and Cons
- Users will get the legacy control to work in the same fashion without the need of exporting to excel.
- Document Center is not supported.
- Managed metadata is not supported.
- Cross browser and Cross platform incompatible.