Both OpenOffice.org and LibreOffice (a derivative of OpenOffice) provide free open-source software packages that are popular alternatives to Microsoft Office. They are both good tools and highly compatible with Excel.
Vertex42 focuses on Excel, so people may not know that we offer 100+ free templates for OpenOffice and LibreOffice as free .ods file downloads, including calendar templates, schedules, financial calculators, budgets, invoices, checklists, and many others.
OpenOffice.org and LibreOffice use the OpenDocument Format for Office Applications (a.k.a. ODF), an XML-based file format. What does that mean? Well, for spreadsheets, it means that the files are going to end in the .ods extension. Documents like letters and resumes use the .odt extension.
.ODS File Download Button
If you are looking specifically for OpenOffice templates or LibreOffice templates, browse Vertex42 and look for the button or link on Vertex42's template pages labeled "OpenOffice," such as the button shown in the image on the right. These will be .ods files.
If we DON'T have a separate .ods download, then 9 times out of 10 the Excel file is going to open just fine in OpenOffice and LibreOffice anyway.
The best way to find a complete list of our spreadsheet templates is to browse the Excel Templates page. You'll also find numerous document templates via our Word Templates page.
If you find a template that you'd like to use and there isn't a .ods download and the Excel file does NOT work in OpenOffice, please let me know (you can comment below or shoot me an email).
Comments
I am just suprised with all the various things that I found available by VERTEX42.
Thank you.
I downloaded the blood pressure chart for OO and have entered three days worth of data, but there’s no trend line showing on the chart. Is there a “Calc” button or Function key sequence I’m supposed to click?
You might have to adjust the x-axis (or y-axis) scaling if the data is not showing in the chart.
How do I get the perpetual-calendar.ods to download and SAVE to my computer rather than opening? I am unable to do anything with the web file that opens. There is no save as option either. It also will not allow me to scrol up to see the first 5 rows of the spreadsheet. Any help would be greatly appreciated. Thanks.
hi there,
didn’t find what i was looking for on your website but thought you might just like to know
what it was! a libreoffice/open office monthly photo calendar.
(i appreciate you’re predominantly an excel-ent site).
hmmm, and i’d like to put smaller photos in the unused calendar spaces too!
regards, PtB
@PtB … There are links to OpenOffice versions of a monthly photo calendar template on this page: https://www.vertex42.com/calendars/photo-calendar.html
would love a template for putting together a portfolio of stocks/Bonds to achieve a balance and total.
@Ed, Thank you for the suggestion. An investment portfolio template is on my to do list, but I’ll move it up a bit higher.
how do you get a resume from libreoffice to attach to a job application?
Export the document as a PDF file then upload it to application
I have used Visio to design buildings and do electrical drawings. Now that I have Linux. can someone point me to .odt templates which might be similar?
@Charlie … See the following page that talks about the drawing tools in OpenOffice: https://wiki.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Impress_Guide/The_Drawing_toolbar
As for templates, you might be able to find some created for Excel and then open them in OpenOffice. Google it. :-)
Trying to find an Access or Base template for a small business. Customers, who have multiple assets, and repairs on those assets. The closest I could think of is customer, multiple computers, repairs on those computers or customer, car or cars, repair and maintenance. A table for parts would be good, as well as labor and sales tax.
Any chance you may have seen one? Right now my budget is just about $0. I’ve seen other templates but I have no idea how to modify. I’ve tried setting up my own and might continue on that, but I’ve run up against some walls.
Is this something you might take on?
@Mark … I don’t have any database templates right now. I would recommend asking a consultant for a quote, but you mentioned your budget is $0, so I’m afraid I don’t have any recommendations at the moment. You might want to look through the various invoice templates and inventory templates.
I came to your web page that promised “100+ Templates for OpenOffice and LibreOffice.” What did I find? NOTHING. No templates. Instead, you suggest that I look at a different part of your site for Excel templates.
I’m looking for Libre Office Base templates. If I wanted Excel templates, I wouldn’t be clicking links to sites promising Libre Office templates.
Sorry about that. The links to download the ODS versions are typically underneath the downloads for the Excel and Google Sheets versions. I’m sorry about making you search the site or browse the site, but I don’t want multiple pages describing the same template just for different versions. So, when there are different versions, they are all listed on the same page. And I definitely like Excel WAY better than OpenOffice or LibreOffice.
4/24/2022: I’m trying to find my “JANUARY to MAY, 2022, FAMILY NEWSLETTER”
The first time I checked it said it was being edited??? Then I wrote two more pages, and it said there was a crash report to look at; I’m totally wasting my time trying to get a newsletter out before Mothers Day; What is going on here??
@Rosalie, Are you using a Vertex42 template? Is this related to Excel? Sometimes Excel crashes or files get corrupted for no known reason. Microsoft has articles about this type of thing: https://support.microsoft.com/en-us/office/repair-a-corrupted-workbook-153a45f4-6cab-44b1-93ca-801ddcd4ea53
This is just silly. It talks and talks and talks about templates and vertex42 etc etc – but NEVER tells you WHERE that is to get them.
This is a short article and the second half of the article is about how to get the templates (almost the entire Vertex42.com website consists of pages describing each template with download links), or if there aren’t separate .ods download links, then most of the Excel versions will work.
Do you have any database templates? Looking for one that deals with books and music. If you don’t have any would you know where I could look? Thank you.