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

Creating Users and Managing Passwords in Microsoft Office 365

0 642 3

In 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 337 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

Detailed Forensic Investigation of Malware Infections – April 21, 2015

4 608 5

How does an investigator hunt down and identify unknown malware? In this recording of our IT Security training webinar on April 21, 2015, Security expert Mike Danseglio (CISSP / CEH) performed several malware investigations on infected computers and identify symptoms, find root cause, and follow the leads to determine what’s happening. He demonstrated his preferred … Continue reading Detailed Forensic Investigation of Malware Infections – April 21, 2015

Write a Comment

Share your thoughts...

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