A Practical Guide to SharePoint 2013

A Practical Guide to SharePoint 2013
A Practical Guide to SharePoint 2013 - Book by Saifullah Shafiq

Friday, October 28, 2011

Import Excel files to SharePoint 2010 ( Via Slava G )

Extracted from the original post

Sometimes we have a need to transfer Excel spreadsheet to the SharePoint 2010 environment.

Because Excel is very popular business application, I see quite a few spreadsheets out there that are used for managing complex business operations.

At some stage the decision comes up to move Excel-based system to SharePoint for certain good reasons and business users try to upload their spreadsheets to SharePoint lists and libraries.

It might seem obvious that we could use out-of-the-box functionality provided by Microsoft in SharePoint 2010 which is "Import Spreadsheet" which "creates a list which duplicates the columns and data of an existing spreadsheet".
What it does in reality is: allowing you to select a range of cells, creating a list with all columns as single or multiple lines text. That's it.
So for real life scenarios we need a different approach to import Excel data to SharePoint appropriately.

In the scenario here we have got a simplified application management system in Excel that features two related worksheets: Applications and Environments. Applications is a list of software and Environments is a list of servers and owners where the software exists.

For complete post click here