Reader Level:
Articles

Import Spreadsheet in SharePoint 2010

By Vijay Prativadi on May 20, 2012
Today, in this article let’s play around with one of the interesting and most useful concepts in SharePoint 2010.
  • 0
  • 0
  • 5848

Introduction

 

Today, in this article let's play around with one of the interesting and most useful concepts in SharePoint 2010.
 

Question: What is Import Spreadsheet?

 

In simple terms "It creates a new list by importing data from a spreadsheet".

 

I think we are now good to go and implement this wonderful concept.

 

Step 1: Create a new Excel sheet and enter some data into it. Save it to a local directory:

 

Output1.png
 

Step 2: Select "Import Spreadsheet" from the listed categories. Give a name to the list:

 

Output2.jpg
 

 

Step 3: A dialogue box appears which enables providing of a unique name for the list and to upload the document from a local directory:

 

Output3.png

 

Step 4: It specifies that the user select the range in the Excel sheet:

 

Output4.png
 

Step 5: The data is imported. The site now looks like this:

 

Output5.jpg

 

Step 6: List setting looks like this:

 

Output6.jpg
 

 

I hope this article is useful for you.

Vijay Prativadi

Hey Everyone, It's Vijay. I am SDE mostly up on Microsoft Technologies. If you are thinking to know what I do mostly when at work. I get a chance to work upon few Microsoft technologies. All the way along my core tech... Read more

COMMENT USING

Trending up