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”.


About Andrej Dobrovoljc

Andrej Dobrovoljc

Posted on 9. December, 2010, in SharePoint and tagged , . Bookmark the permalink. 7 Comments.

  1. 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:

    I hope this information proves useful to those needing to import data into SharePoint lists.

  2. 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

  3. 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!

  4. 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.

  5. Piece of writing writing is also a excitement, if you know then you can write or
    else it is difficult to write.

  6. 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.

  7. 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.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: