SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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'm trying to import data from excel into an existing list. I can paste one line at a time by opening the excel doc and the sharepoint list in datasheet view, but that's not very efficient.

Any sugestions?

Alternately, is there a way to add fields to a newly imported list that behave like task list items?

share|improve this question

Following on James Love's answer:

For Sharepoint 2003, you can copy/paste, but you must be careful about how you do it. (not sure how this may apply to more current versions)

After copying the data in your excel spreadsheet, go to your Sharepoint list and single-click on your left-most editable cell in the 'new row' at the bottom (so that you're selecting the cell, not editing it). Hit ctrl-v and you should be good.

share|improve this answer

For Sharepoint 2007 there is a nice tool on codeplex:

share|improve this answer
Does it work in 2010? – user2339 Feb 7 '11 at 14:20

If you can't use third party tools- if you line up the columns in the excel spreedsheet to that of your view in datasheet view, you can select all the rows you want and paste them directly into the datasheet view.

share|improve this answer
I do this all the time, you just have to make sure the column formats and the data being input match and it's also helpful to make every column optional. – Eric Alexander Feb 4 '11 at 20:44
Do you find if you paste into a lookup column the browser sorta hangs for an age? Wondering if it's just my client's environment... – James Love Feb 4 '11 at 20:51
It was not letting me paste more than one row at a time – user2339 Feb 7 '11 at 14:18

I don't yet have the rep required to comment on @WimHill, so here goes as an answer:

Yes there is a version of Praveen Battula / Technovert's tool that works with SharePoint 2010, 2013 and Online. It is called SPImporter and is available at

I tried it out just now and it worked fine to import a few hundred rows from an Excel 2007 spreadsheet into an Announcements list in SP2013 Server.

Note however that Praveen Battula / Technovert haven't published the source code yet, which is a requirement for projects hosted on CodePlex, so you will have to decide if it is safe to use the download setup binary as is.

share|improve this answer

Your Answer


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