Share via

Copy/create multiple lists under one Sharepoint site

  • Article

Question

Wednesday, August 28, 2019 5:05 PM

Hello,

I've been searching for an easy way to copying a current list and renaming it under a different title within one Sharepoint site. So far, all options provided to me do not work. Powershell commands do not work, Sharepoint Designer isn't allowed at our facility etc. etc. The site has also been 'published' and I've read that once published, you can't copy lists as templates.

For something seemingly as simple as this, I'm completely baffled at how difficult it is. At this point in time, my only option is to manually recreate the list which will take hours to do. Any guidance would be appreciated. 

All replies (15)

Wednesday, August 28, 2019 5:13 PM | 1 vote

You can save the existing list as Save List as Template option to copy lists under same site. and also you can do via Content and Structure option from Site Settings.

Create a list template based on the list.

How?

  1. On the top link bar, click Documents and Lists.
  2. On the Documents and Lists page, click the list that you want to copy.
  3. On the page that displays the list, click Modify settings and columns.
  4. On the Customize List_Name page, under General Settings, click Save list as template.
  5. In the File Name box, type the file name to use for the template file.
  6. In the Template Title box, type the title that you want to use for the template in the list template gallery.
  7. In the Template Description box, type a description for the template.
  8. Select the Include content check box.
  9. Click OK.
  10. On the Operation Completed Successfully page, click OK.

Below article for reference:

http://sharepoint.ebizassist.com/copying-or-moving-sharepoint-lists

Thanks & Regards,

sharath aluri

Wednesday, August 28, 2019 5:31 PM

In viewing our home site, I can't even find 'Documents and Lists'.

Wednesday, August 28, 2019 5:57 PM

there is no such option called Documents and lists. I was just referring if you want to copy list or library then go for your list/library which you want to copy and go to list settings and there you see a option called Save list as Template.

below article with screenshots:

https://support.office.com/en-us/article/manage-list-templates-c3884ad1-bc49-44b8-b3d6-3bc6a01eb393

Thanks & regards,

sharath aluri

Wednesday, August 28, 2019 7:14 PM

I've tried that it and it doesn't work. There's no option to 'Save list as Template'. 

Wednesday, August 28, 2019 7:22 PM | 1 vote

Seems like you have Publishing feature enabled at Site level. that's the reason you are not able to see. hmmm, i don't think you have any other way other than using powershell / 3rd party tools to migrate the list. you can also do Database backup and Restore and get the data without attach that database to sharepoint. I don't think you have any other option other than using one of the above.

Thanks & Regards,

sharath aluri

Wednesday, August 28, 2019 7:26 PM

So far, Powershell isn't working either as I mentioned earlier. Could you elaborate on any off-the-shelf third party tools that might do the trick or is that not allowed here? That really might be my only option that will work.

Wednesday, August 28, 2019 7:43 PM | 1 vote

3rd party tools like Sharegate, Metalogix & Doc Ave are priced ones, you don't have any free tools we have one tool but that will only work with SharePoint online but not on-premises. Sharegate is less in price when compared to others approx 4000$ / year. but i would say take Database backup and Restore with a New Name under same SQL Instance then get the lists from unattached content database. below article for reference:

https://blogs.msdn.microsoft.com/mvpawardprogram/2016/05/03/how-to-restore-sharepoint-2013-content-from-unattached-database/

If you are planning to buy 3rd party tool then go for the below one which is less in price when compared to other.

 https://sharegate.com/products/sharegate-desktop/pricing

Thanks & Regards,

sharath aluri

Thursday, August 29, 2019 6:37 AM

Hi chevyavalanche,

You can use the tools that Sharath mentioned, and as Sharath says, there's no better way unless you're willing to spend time manually recreating them.

Third-party information disclaimer:

The third-party product that this article discusses is manufactured by a company that is independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of third-party products referenced in this article.

Best regards

Itch Sun

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

SharePoint Server 2019 has been released, you can click

here to download it.
Click

here to learn new features. Visit the dedicated

forum to share, explore and talk to experts about SharePoint Server 2019.

Thursday, August 29, 2019 8:07 AM

Hi chevyavalanche,

You can use Save List as Template option. In publishing Site that option is hidden but you can still access the page using URL: 

/_layouts/15/savetmpl.aspx?List=%7BLIST_GUID%7D

Just replace LIST_GUID with your list's GUID.

Best Regards,
Brij K
http://bloggerbrij.blogspot.co.uk/

Thursday, August 29, 2019 5:11 PM

Tried this and it didn't work either. Got this message:

Sorry, something went wrong

An unexpected error has occurred.

TECHNICAL DETAILS

Troubleshoot issues with Microsoft SharePoint Foundation.

Friday, August 30, 2019 1:35 AM

Hi chevyavalanche,

You can use the tools that Sharath mentioned, and as Sharath says, there's no better way unless you're willing to spend time manually recreating them.

If you think the replies are helpful to you, please remember to mark them as answers. It will help others who meet the similar question in this forum.

Best regards

Itch Sun

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

SharePoint Server 2019 has been released, you can click

here to download it.
Click

here to learn new features. Visit the dedicated

forum to share, explore and talk to experts about SharePoint Server 2019.

Friday, August 30, 2019 2:44 PM

Hi chevyavalanche,

Just a suggestion, if you are not able to save list as a template from publishing site, why not create that list in a Team Site, then Save list as a Template and download the template and upload it on your publishing site. This way you have to create list only once and then in Team Site and in publishing site you can create the list from Uploaded template.

Best Regards,
Brij K
http://bloggerbrij.blogspot.co.uk/

Tuesday, September 3, 2019 8:56 AM

Hi ,

Has the problem been solved?

If you think the replies are helpful to you, please remember to mark them as answers. It will help others who meet the similar question in this forum.

Thank you for your understanding.

Best regards

Itch Sun

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

SharePoint Server 2019 has been released, you can click

here to download it.
Click

here to learn new features. Visit the dedicated

forum to share, explore and talk to experts about SharePoint Server 2019.

Thursday, September 5, 2019 8:27 AM

Hi ,

I'm still paying attention to this issue.

If you think the replies are helpful to you, please remember to mark them as answers. It will help others who meet the similar question in this forum.

Looking forward to your update on this issue.

Best regards

Itch Sun

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

SharePoint Server 2019 has been released, you can click

here to download it.
Click

here to learn new features. Visit the dedicated

forum to share, explore and talk to experts about SharePoint Server 2019.

Monday, September 9, 2019 7:52 AM

Hi

If you think the replies are helpful to you, please remember to mark them as answers. It will help others who meet the similar question in this forum.

Looking forward to your update on this issue.

Best regards

Itch Sun

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

SharePoint Server 2019 has been released, you can click

here to download it.
Click

here to learn new features. Visit the dedicated

forum to share, explore and talk to experts about SharePoint Server 2019.