Sunday, November 15, 2009

Export Excel to Sharepoint

Export your excel spreadsheet data in to sharepoint list using these steps:

Import the file into a new list using these steps:
1.Site actions -> Create
2.In the "Custom Lists" section, select "Import Spreadsheet"
3.Enter a name and description for your list
4.Browse to your exported text/Excel file.
5.Click Import

Excel will start up with a Import dialog.

1.In the import dialog, select "Range of cells"
2.Click in the "Select range" text box.
3.Select the Subject to End Time columns and drag down to all rows you want to import.
(So it will result in something like MyExportedCalendar!$A$1:$E$46)
4.Click Import.

The data is now imported in to a list.Hope this helps.

No comments:

Post a Comment