Skip to main content

Posts

Showing posts from October, 2011

Import Excel files to SharePoint 2010

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 …