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'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
add comment

4 Answers

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
add comment

For Sharepoint 2007 there is a nice tool on codeplex: http://spreadsheet2splist.codeplex.com/

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

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. –  PirateEric 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
add comment

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 https://spimporter.codeplex.com/.

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
add comment

Your Answer

 
discard

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