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:
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
After the content type created completely click on Advanced settings (comes under the Settings option).
In the Advanced Settings page, we can see the
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.
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 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.
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
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.
You may like following SharePoint tutorials:
- the list is too large to save as a template the size of a template cannot exceed 52428800 bytes
- [Solved] The list cannot be imported because a Microsoft SharePoint Foundation-compatible spreadsheet application is not installed or is not compatible with your browser
- Bind SharePoint Online List Data into HTML table or jQuery Datatable using jQuery and Rest API
- Insert/Add item to SharePoint Online list using PowerShell
- Cannot import a spreadsheet into SharePoint. This feature requires a browser that supports ActiveX controls in SharePoint
- Could not load file or assembly ‘Microsoft.AI.Web’ or one of its dependencies. The system cannot find the file specified.
- cannot find module ‘@microsoft/sp-build-web’ SharePoint Framework (spfx)
- Create and Use Content type hub in SharePoint Online/2013/2016/2019
- SharePoint content type CSOM examples
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.
I am Bijay from Odisha, India. Currently working in my own venture TSInfo Technologies in Bangalore, India. I am Microsoft Office Servers and Services (SharePoint) MVP (5 times). I works in SharePoint 2016/2013/2010, SharePoint Online Office 365 etc. Check out My MVP Profile.. I also run popular SharePoint web site EnjoySharePoint.com