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
A Simple Introduction to Cisco CML2
0 3849 0Mark Jacob, Cisco Instructor, presents an introduction to Cisco Modeling Labs 2.0 or CML2.0, an upgrade to Cisco’s VIRL Personal Edition. Mark demonstrates Terminal Emulator access to console, as well as console access from within the CML2.0 product. Hello, I’m Mark Jacob, a Cisco Instructor and Network Instructor at Interface Technical Training. I’ve been using … Continue reading A Simple Introduction to Cisco CML2
Creating Dynamic DNS in Network Environments
0 626 1This content is from our CompTIA Network + Video Certification Training Course. Start training today! In this video, CompTIA Network + instructor Rick Trader teaches how to create Dynamic DNS zones in Network Environments. Video Transcription: Now that we’ve installed DNS, we’ve created our DNS zones, the next step is now, how do we produce those … Continue reading Creating Dynamic DNS in Network Environments
Government Edition – Encrypting a USB Flash Drive in Windows 10
0 271 2In this video, Security Instructor Mike Danseglio demonstrates how to use BitLocker in Window 10 to secure files on a USB Flash drive that adhere to stricter data protection requirements as found inside Government entities. BitLocker 2-day instructor-led training is now available at Interface: BITLOCK: Planning and Deploying BitLocker Drive Encryption Training Video Transcription: Hi. … Continue reading Government Edition – Encrypting a USB Flash Drive in Windows 10