Primary Games Cubefield 2

Import Excel files into SharePoint

Option available in Excel 2003 and Excel 2007, the ability to create automated lists in SharePoint from Excel, can save a lot of time while providing structure information.

In Excel 2007:

1. Select the data to be a list
2. tab Insert, click Table and validate options
   
   
   
   
3. Once done, the option Export is active and allows the creation of a list in a SharePoint site which we will, first, captures the url
   
   

In Excel 2003, the operation is almost identical but different options:

1. Right-click on Data and select Create a list
   
   
2. right-click, and List Publish List
   

From SharePoint side, the same result can be obtained with View All Site Content > Create >

Import spreadsheet data types that are supported by this import are simple types: Text Currency Time Number Hyperlink

Here!