How to Download, Import and Use Templates in LibreOffice Calc


This tutorial will show how to use templates in LibreOffice Calc. I will show how to download a template, import it, use it and manage it in LibreOffice Calc.

Download Templates

Templates are a great way to extend the functionality of LibreOffice. Huge numbers of community developed free LibreOffice Calc templates available in extensions.libreoffice.org/templates/.

Download any Calc template you want and save it in your computer. For this tutorial, I have downloaded Calendar Creator template.

Download calendar-creator template

Template files are having .ots (ODF Spreadsheet Template) extension which is used by LibreOffice Calc spreadsheet applications.

Import Templates

To open the manage templates dialog, from the menu choose File -> Templates -> Manage. On the Template Manager Dialog, go to Spreadsheet Tab and click My Templates. 

Template Manager_Import

Using Import button, choose the template .ots file you have downloaded. Template manager will import the .ots file and you can see it under My Templates. Select the template and click open.

Open Template - LibreOffice Calc


Use Templates

It might take a moment to load the template, once loaded you can see the template in Calc workspace. Now you can save it as .ods files and your use.

Calendar Template - Imported


This is how you can download and use a Calc spreadsheet template in LibreOffice. Feel free to leave a comment or if you are looking for something else using comment box down below.

Next Chapter Data Validation

Looking for something else?

Read our complete tutorial index of Calc, Writer, Impress and Draw.

Join our Telegram channel and stay informed on the move.


Creator of libreofficehelp.com. The aim is to help as many people with easy-to-understand tutorials. Connect with me via Telegram, Twitter, LinkedIn, or send us an email.

Notify of

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Newest Most Voted
Inline Feedbacks
View all comments
Carmen Blakely (not my real name, of course)

Glad you like the Calendar Creator template I made. It has been a lot of fun making it and using it. I’m no programmer so a lot of the functions in Calc were copied from other calendar making spreadsheets and just some how it works. I print the entire file/sheets to a pdf and then use pdftk (PDF Toolkit) to obtain maximum area of the calendars. The monthly calendar on one page will print, of course, but it doesn’t fill the page well enough. So, I usually just paste it into Writer as a GDI and then reformat the calendar to 7-1/2″ x 10″ which is a nice size.



i try to follow the link to download the calendar creator template but i get insufficent privledges error and i made a login but no luck 🙁

Carmen Blakely

To find the Calendar Creator template simply search for “Libreoffice Templates”.


[…] Source : libreofficehelp.com […]

Would love your thoughts, please comment.x