Subscribe:      
 

Automatically create SharePoint custom list populated with Excel data - Part 2

Written By: Hesham Saad -- 2/22/2011 -- join -- contribute -- (0) comments -- printer friendly version

Rating: Rate --

Categories: Integration with other products , MOSS 2007, SharePoint 2010, SharePoint Foundation 2010, WSS3

< Prev - 1 | 2 | 3 | 4 | - Next > | Become a paid author

Problem

It is easy to export SharePoint lists to an Excel spreadsheet, but how about the reverse? If we already have data in excel format with predefined columns , headers , formulas , ... etc how can we make those available in a SharePoint list?

Solution

Via Microsoft Office Excel 2007 we can create a table and then export it to a new SharePoint list. SharePoint provides OOTB (Out Of The Box) functionality to import Excel spreadsheets and to save it as a custom list. There are multiple techniques for getting this job done. Parts I and II of this tip will explore three different approaches. 

  • Export an Excel spreadsheet table to a SharePoint custom list (Default text data type for table - Columns headers)  - Part I.
  • Export an Excel spreadsheet table to a SharePoint custom list (Multiple data type for table - Columns headers) - Part II.
  • Import an Excel spreadsheet table to a SharePoint custom list (SharePoint OOTB Custom Lists feature) - Part II.

< Prev - 1 | 2 | 3 | 4 | - Next >



Learn more about SharePoint



Sponsor Information




Copyright (c) 2010-2017 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | contribute | feedback | about
Some names and products listed are the registered trademarks of their respective owners.


MSSharePointTips.com | MSSQLTips.com