Calendar Template - Imported

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

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. 

SEE ALSO:  Decimal Places in LibreOffice Calc

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.



IT professional by profession and founder of Loving Linux and other technologies since 2002. I believe in open source and its philosophy. Follow me on Twitter or email me.

4 thoughts to “How to Download, Import and Use Templates in LibreOffice Calc”

  1. 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.


    1. 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 🙁

Leave a Reply

Your email address will not be published. Required fields are marked *

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