General

Re: Importing a spreadsheet to a existing sharepoint list.

sirii — Wed, 22 Oct 2008 20:00:19 GMT

Thanks Hari

Re: Importing a spreadsheet to a existing sharepoint list.

sirii — Wed, 22 Oct 2008 19:59:58 GMT

Thanks Ravi

Re: Importing a spreadsheet to a existing sharepoint list.

Hari Krishna — Wed, 22 Oct 2008 12:09:56 GMT

Hi,

One of the option can be by adding an extra column and by copy/pasting from the spreadsheet to SharePoint:

This can be done by going to Actions-->Edit in Datasheet

Right clicking on the column and add column and paste the data from spreadsheet.

Re: Importing a spreadsheet to a existing sharepoint list.

ravig — Wed, 22 Oct 2008 08:55:04 GMT

Hi,

To import Excel Spread sheet to SharePoint following link will help you.

http://www.sharepointcustomization.com/wss/articles/lists-excel.htm

But the fields of excel sheet will be displayed in seperate view.

Importing a spreadsheet to a existing sharepoint list.

sirii — Tue, 21 Oct 2008 21:25:53 GMT

Hi,

I have published a infopath form to a sharepoint site as a document library. I have added some fields of infopath form while publishing so that they would appear as columns in a sharepoint list.

Consider the list name as "My_Template". Can I import a different excel spreadsheet with different fields to the "My_Template". So that the fields in excel spreadsheet also appears as columns in "My_Template". So the fields of infopath form and fields of excel sheet should appear as coulumns in a sharepoint list.