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.
