How to Create a DataSheet View on a List in SharePoint 2010
How to Create a DataSheet View on a List in SharePoint 2010
In this blog post I will create a Datasheet View on a list in SharePoint 2010. Datasheet Views are very powerful and allow for quick data entry. You can even cut and paste from an Excel spreadsheet into a Datasheet View. If you have the 64 bit version of the Office 2010 programs installed on your client machine, the Datasheet View won't work without a hot fix. I have a bare metal dev server with SharePoint 2010 and Office 2010 installed.
In this example, I have a Site Collection with the Team Site as the Top Level Site and I have a list of some of the current courses offered at Interface Technical Training. I want to add some more courses quickly by copying them from a spreadsheet. To do this, I will create a Datasheet View. In this blog, I'll just show the part of creating the Datasheet View.

This will change the ribbon to be contextual to interacting with the actual list as a container, which is where you create the views.


Datasheet View is very similar to Access View but occurs entirely in the browser and is a great tool for rapid data entry.

I name the view QuickEdit-DSV (I like to use DS or DSV in my Datasheet View Names) and configure the columns as needed. In this case SharePoint guessed correctly.

To add some data from a spreadsheet, I would simply scroll to the bottom and choose a cell and paste in the data. Of course the columns have to match up.
That's it!
Spike Xavier
SharePoint Instructor – Interface Technical Training
Phoenix, AZ
You May Also Like
data sheet view, Datasheet, datasheet view, list columns, lists, SharePoint 2010, sp2010
Creating Users and Managing Passwords in Microsoft Office 365
0 786 4In this Office 365 training video, instructor Spike Xavier demonstrates how to create users and manage passwords in Office 365. For instructor-led Office 365 training classes, see our course schedulle: Spike Xavier SharePoint Instructor – Interface Technical Training Phoenix, AZ 20347: Enabling and Managing Office 365
Using Navigation Controls in a Collaboration Site in SharePoint
0 360 1In this SharePoint training video, I want to talk about the Navigation Controls in SharePoint. They tend to fall into two kind of different categories; one with the navigation controls in a typical Collaboration Site such as a Team Site or a Project Site. These are Sites that are based on the Team Site Template … Continue reading Using Navigation Controls in a Collaboration Site in SharePoint
How to Use SharePoint Navigation Controls in a Publishing Site
0 235 2For more SharePoint training videos in this series, see: Part 1 – Using Navigation Controls in a Collaboration Site in SharePoint Part 2 – » Using Navigation Controls in a Publishing Site in SharePoint « Part 3 – Configuring SharePoint Navigation in a Publishing Site – Activating the Publishing Feature Part 4 – How to Configure Navigation in SharePoint … Continue reading How to Use SharePoint Navigation Controls in a Publishing Site