SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?


share|improve this question

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

Importing spreadsheet is an inbuilt option in SharePoint 2010. You can follow these steps mentioned over here in this video demo -

share|improve this answer

Importing an excel Spreadsheet directly into SharePoint list won't transfer columns types like Person or group with correct lookup functionality instead it will import them as single line or multiple lines of text

share|improve this answer

Your Answer


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