Reader Level:
ARTICLE

Import Spreadsheet in SharePoint 2010

On May 20, 2012 Articles | SharePoint
Today, in this article let’s play around with one of the interesting and most useful concepts in SharePoint 2010.
  • 0
  • 0
  • 5664

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 wa...

  • 11rank
  • 2M readers
  • 2times
COMMENT USING

Trending up