Add multiple Office templates as content type to a document library in SharePoint Online/2013/2016

In the SharePoint tutorial, we will discuss how to add different Microsoft office template like word, excel, PowerPoint to SharePoint document library in SharePoint 2013/2016 or SharePoint Online.

When we open the SharePoint 2013/Online document library and try to Add “New Document” we can able to see Word document. Suppose we have a business requirement that when the user goes for Adding New document in the document library he wants to see the PowerPoint and Excel Spreadsheet as a template.

By default, if you open a SharePoint document library, you can see below only Document template like below:

SharePoint 2013 document library template
SharePoint 2013 document library template

Now, what will do?

Follow the below method to add the “Excel spreadsheet” and “PowerPoint” to document library “New Document”. For the above requirement, the SharePoint content type is used.

Create a SharePoint Content type using Document Parent Content Type

Here we will see how to add or create a content type for the document template in SharePoint Online or SharePoint 2013/2016.

For creating a content type go to Site Settings -> Site Content type (under the web designer galleries).

Create a new Content type. Here

SharePoint 2013 document library template
SharePoint 2013 document library template

After the content type created completely click on Advanced settings (comes under the Settings option).

SharePoint 2013 document library template
SharePoint 2013 document library template

In the Advanced Settings page, we can see the

“Document Template”:

We can see two option Enter the URL of an existing template and Upload a new document template. In the First option we can give the document template URL but here I tried for the second option. I have browse from the local system. I have created a blank PowerPoint page and save in the local system and I have uploaded that PowerPoint page from the local system here.

“Read Only”:

This is by default chosen to No If you want to content type be read-only means you only can see the content type you can not modify it then enable it. I have chosen the by default option because I want to modify if required.

“Update Sites and Lists”:

The Update Sites and List is by default Yes.

Click on OK.

add content type to document library sharepoint online
add content type to document library SharePoint online

Add multiple Office templates as content type to a document library in SharePoint

Now directly go to the Documents when we want to see the Office template. From the Library, settings go to “Advanced Settings“. In the Advanced Settings page enable the “Allow management of content types” feature. Click On OK.

SharePoint 2013 document library template
SharePoint 2013 document library template

In the Library Settings page scroll down the page and we can able to see “add from existing site content types“, Click on that option.

Now Add Content Types page will come like below screenshot. Select the “All Groups” from “Select site content types from“. From the Available Site Content Types choose the name which you have created in the Create Content type page. Click on Ok

sharepoint document library template
sharepoint document library template

Now in the “Documents” library when I have click on Add “New Document” We can able to see PowerPoint template. Like that, I have added ExcelSpreadsheet. For ExcelSpreadsheet same steps can be followed but I have uploaded the PowerPoint file. Instead of that for Excel, we need to Browse the Excel file. This much difference only.

add content type to document library sharepoint online
add a content type to document library sharepoint online

You may like following SharePoint tutorials:

Conclusion

In the SharePoint article, we were discussed how to add multiple office templates like word, excel, PowerPoint, etc. to a document library in SharePoint online/SharePoint office 365/SharePoint 2016.

>