Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I am running SharePoint Server 2010 and I have an excel spreadsheet of about 3000 rows / 30 columns, which I would like to import to a SharePoint list.

I've seen on codeplex a free tool for MOSS/wss 3.0 but nothing for 2010.

Only option I can think of is writing an app that will go through each line of the spreadsheet and create a new list item for each.

Can anyone else think of any options for getting this data into a list?

thanks!

share|improve this question
add comment

4 Answers 4

There is the option of using datasheet view to copy-paste data, especially if need lookups to other lists or have "choices" already set up. This does require you to normalize the data in your spreadsheet. The downside is that you can't paste in data for columns that are "multi-line" type in datasheet view.

Using the above two walk-throughs, you can first use the "Import Excel Spreadsheet" function for your import, then create the final "destination" fields - say if you need lookups, and use the datasheet view to "convert" data from the old columns to the final fields by copying-pasting from one column to another.

share|improve this answer
add comment

Importing spreadsheet is an inbuilt option in SharePoint 2010. You can follow these steps mentioned over here in this video demo -http://www.sharepoint-videos.com/sp10import-spreadsheet-to-create-a-new-list/

share|improve this answer
add comment

Import Spreadsheet directly into SharePoint list won't have columns types like Person or group

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.