How To Import and Use Microsoft Excel Templates on LibreOffice Calc

This tutorial will help you be more productive with LibreOffice Calc by taking benefit of the existing, thousands of Microsoft Excel's templates on the internet. Thanks to LibreOffice compatibility features, this is possible. With this, you can quickly make invoices, receipts, project management, budget plans, financial reports, bookkeeping, teacher/student records and many more. Let's try now!

(A budget plan spreadsheet from Vertex42.com opened in Calc)

Subscribe to UbuntuBuzz Telegram Channel to get article updates.

About

We started a LibreOffice class in Indonesia this year 2022 and we tried hard to give everything useful for students, especially, using Excel templates in Calc. This is a good idea to boost up your productivity at your work. We hope this inspires everyone to create, share and enrich LibreOffice Calc templates more and more.

Warning about licenses: even though you can download a lot of templates gratis, and use them for personal purposes, you might be not permitted to use some for commercial purposes by their authors. For that reason, always check the license of every single template before reusing and resharing it. As a solution, it is better if you could find templates with free as in freedom licenses such as cc by-sa (license used by all Wikipedia pages) or in public domain or even better make them yourself. Trying out many templates will give you the ability to do so in Calc.

What you can create

Calendars
Invoices
Receipts
Pay slips
Gantt charts
Schedules
Forms
Budget planning
Financial reports (balance sheets)
Project managements
Project dashboards
Student grade books
Student score cards
Student/employee attendances
and many more...

Resources

Below is a list of gratis (free of cost) Microsoft Excel template websites. They altogether provide the world most complete digital spreadsheet templates for all purposes possible including invoices, project management, pivot tables, academic records, and many more.

templates.office.com

vertex42.com

invoicesimple.com

trumpexcel.com

spreadsheet123.com

smartsheet.com

exceldatapro.com

calendarpedia.com

xltemplates.org

businessaccountingbasics.co.uk

double-entry-bookkeeping.com

Document Format

xls : Excel 97-2003 old format.

xlsx : Excel 2007-365 new format.

xslt : Excel template format.

ods : Calc format.

ots : Calc template format, equivalent to xlst.

You can use whatever Excel/Calc format available without problems. However, the difference between normal formats (xlsx, ods) with template formats (xltx, ots) is that:

1) if you open the file, normal one will show its actual file name on titlebar while template one will show Untitled, and,

2) if you edited them, saving a normal one will change its content while saving a template one will create a new file without changing the original content.

Expected Goals

If you pay attention closely, you will notice that LibreOffice Calc comes with no template at all. With this tutorial, your Calc should improve from that to having a lot of templates you can use for real work purposes.

Before:

After:

Process

1. Get an Excel template document file.

You can search, find, visit and download them from any of resources above.

2. Open LibreOffice Calc.

3. Open the Excel document.

4. Document opened.

5. Do File > Templates > Save as Template > give it a name according to its original name > select My Templates category > Save > successfully imported a template. For further explanation, read our LibreOffice Templates Use Guide.

6. To use a template, do File > New > Templates > template chooser dialog will show > select a template > Open > a new untitled document with template will show > you are ready to write. Please read LibreOffice Templates Use Guide if you want to learn more.

6. To import another template, repeat steps number 1-5.