How to import data into SharePoint 2010 List
My problem was how to migrate some lists from SharePoint 2003 into SharePoint 2010. There is a simple and effecitve way how to do this. At first you have to export data to Excel file. The next step is import Excel data into SharePoint 2010 list. How to do this, you can find very well described in this post:
Import and export data between Excel 2010 and SharePoint 2010
There is one thing I will add to this post. What I liked with this procedure is the fact, that the import function automatically finds the right data types for columns (text, number). Only with the text columns it alway selects “more lines of text”.
Posted on 9. December, 2010, in SharePoint and tagged Import, SharePoint. Bookmark the permalink. 7 Comments.
amavs 
Hi,
Yes, that works well when you are creating a whole new list in SharePoint 2010. However, this will not work if you want to import data into an existing SharePoint list. That problem is much more difficult to solve.
We developed an application that allows you to import data from various sources including SharePoint 2003 or 2007 lists into existing SharePoint lists. The application is called Magic – An Import Wizard for SharePoint and can be downloaded here: http://www.rddevsolutions.com
I hope this information proves useful to those needing to import data into SharePoint lists.
I feel this is one of the most significant info for me.
And i’m happy studying your article. But wanna observation on few basic issues, The web site taste is great, the articles is in point of fact great : D. Good process, cheers
It’s perfect time to make some plans for the future and it is time to be happy. I have read this post and if I could I want to suggest you few interesting things or tips. Perhaps you can write next articles referring to this article. I want to read more things about it!
The report features confirmed necessary to myself. It’s extremely useful and you are naturally extremely well-informed of this type.
You possess opened up my personal eyes for you to various opinion of this kind of matter with interesting and solid content material.
Piece of writing writing is also a excitement, if you know then you can write or
else it is difficult to write.
I’m amazed, I must say. Rarely do I come across a blog that’s equally educative and
amusing, and let me tell you, you have hit the nail on the
head. The issue is something not enough men and
women are speaking intelligently about. Now i’m very happy that I stumbled across this during my search for something relating to this.
Hi there, i read your blog occasionally
and i own a similar one and i was just wondering if you get a lot of spam feedback?
If so how do you reduce it, any plugin or anything you can advise?
I get so much lately it’s driving me insane so any help is very much appreciated.