Import an existing list to another site in SharePoint 2010

Summery – This post explains how to create a new SP list using existing one. First export existing list with its content as a stp file. Then use it as a template to create a new list in your site.

1. Site Actions -> View all site content
Under the List you will find out the List which you want to export.

2. List tools on ribbon -> List
3. Click ‘List Settings’.
4. Select ‘Save list as template’ under Permission and Management.
                        i. File name
                       ii. Template Name
                      iii. Template Description
                      iv. Include Content (if u want to save with rows)

5. Click ‘OK’.
6. You will get bellow window.

7. Click on the link – list template gallery.
Or go to List Template Gallery -> All Templates after you click Ok button.

8. Click on your template name and save it on your desktop as a .stp file.

Navigate to the site which you want to import the list template.

1.         Navigate to ‘Site Action’ -> ‘Site Settings’ ->  ‘List templates’ (Under the Gallery)

                        Now you can see an empty place if you did not import any template before. 

2.  Click ‘Library tools’ on Ribbon -> documents

3.   Select ‘Upload document’ button which in left side of the ribbon.

4. Give .stp file location

5. Go to All site contents -> Lists.

6. Create Custom List -> Select your template.
7. Give a name and description.
8. Click Create.