How to Create a DataSheet View on a List in SharePoint 2010

Home > Blogs > SharePoint > How to Create a DataSheet View on a List in SharePoint 2010

How to Create a DataSheet View on a List in SharePoint 2010

Like This Blog 0 Spike Xavier
Added by June 19, 2013

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.

Click the List Tab

I-Click-The-List-Tab.png

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

Click Create View

I-Click-Create-View.png

Choose Datasheet View

I-Choose-Data-Sheet-View.png

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

Name the View and Configure Columns

I-Name-The-View-And-Configure-Columns.png

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.

Use the View

Use-The-View.png

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

Videos You May Like

Agile Methodology in Project Management

0 171 0

In this video, you will gain an understanding of Agile and Scrum Master Certification terminologies and concepts to help you make better decisions in your Project Management capabilities. Whether you’re a developer looking to obtain an Agile or Scrum Master Certification, or you’re a Project Manager/Product Owner who is attempting to get your product or … Continue reading Agile Methodology in Project Management

Using Navigation Controls in a Collaboration Site in SharePoint

0 348 1

In 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 232 2

For 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

Write a Comment

Share your thoughts...

Please fill out the comment form below to post a reply.