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

How can we copy/export a library/list that currently lives on SharePoint 2010 and import it to SharePoint 2013 on office 365?

I have searched the web, but I just don't seems to find a good example for this situation.

share|improve this question

There are a number of third-party tools that can do this for you. Here are a few:


Express Migrator:




share|improve this answer
But is there any recommended way of doing it manually ? or using third party tool is the only option till now. – Ahmed Masud May 12 '14 at 8:22
You can always write your own migration tool or do it manually, one record at a time... – John Chapman May 12 '14 at 14:21

You should be able to do the following:

  1. Save your document library in 2010 as a template.
  2. Copy the template file to your desktop.
  3. Go to your top-level site collection settings in SP Online and go to "List Templates" from the Designer Galleries section.
  4. Upload your 2010 template.
  5. Create a new list using that template.

The list you created should have all of the information (with the exception I believe of any workflows). There are limits to how large a doc library swapped out like this can be, and if your library exceeds that size then John Chapman's remedies are the only other way that I am aware of. Nonetheless, I'm almost positive that they left the way that lists and by extension libraries are formatted virtually untouched between these versions and so therefore this should work.

share|improve this answer
Lists can also be exported to Excel, and then use that Excel file as template to create a new list (with the data) – Louis Apr 14 '15 at 18:00

There is also a newer, cheaper and much simpler solution. 3 PRO - SharePoint Migrator -

It migrates from on-premise or filesystem to your SharePoint Online, or vice versa. It maintains users, ownership, dates, and versions.

share|improve this answer

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.