08 June, 2012

how to import a spreadsheet into sharepoint list 2010

Just like SharePoint 2007, SharePoint 2010 also provides this functionality in which we can directly import an excel spreadsheet and creates a custom list based on the number of the columns.
How to import? Here is the step by step guide for you:

·         Open your sharepoint site
·         Click on view all site content
·         Create
·         Select the List category from the left
Note: If you do not wants to follow the above mentioned steps then please make some adjustments in your site URL (like the below one)
You will be wondering as what exactly we need to do in the URL, it’s very easy
Just append _layouts/create.aspx after the site name. That’s it
·         Okay, continuing the same point


·         As soon as you click on ‘Import a spreadsheet’ then Provide the list name as per your project requirements
·         Click on Browse and select your excel file that you wants to import
·         Select the range of cells that you want to import
·         Click OK
-That’s it-Job Done J Very Easy Right J-
If you face any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues. Thank you.

1 comment:

  1. You need to be a part of a contest for one of the highest quality blogs on the
    net. I am going to recommend this blog!

    Feel free to surf to my weblog :: turbotax coupon

    ReplyDelete

Your feedback is always appreciated. I will try to reply to your queries as soon as possible- Amol Ghuge

Note: Only a member of this blog may post a comment.