9 Must-Have OpenOffice Extensions

Damien Oh 20-10-2008

9 Must-Have OpenOffice Extensions openofficelogoLike Firefox, OpenOffice also comes with extensions that you can use to improve its functionality. Here, we have tested all the extensions and sorted out those that are useful for everyday use. Some of them are for general use while some are only meant for Writer, Calc or Impress. (For those who haven’t heard about OpenOffice before, it’s a popular free alternative to Microsoft Office)


Before you carry on reading, here are some things that you need to do/know:

    Obviously, the extensions require OpenOffice to work. If you have not installed OpenOffice, grab the latest version here.

    To install the extension, you have to go to Tools -> Extension Manager in any of the OpenOffice applications. Click ‘Add’ to install the extension that you have downloaded.

Let’s proceed onto the 9 must-have extensions for your OpenOffice.

open office extensions

1) Sun PDF Import Extension

open-office import-pdf Normally, OpenOffice only allows you to export your file to PDF format, but not to import and make changes to it. With this PDF Import extension, you can now import your PDF files and make changes to the date, numbers or even a small portion of text.

By default, this extension imports the PDF file into the Draw application rather than Writer, even though it may contain a full page of text. You may be wondering why, but if you remember that when the PDF format was first created, it was designed not to allow any editing at all. As such, importing as a text document into Writer may prove too difficult a thing to do.


With that, capturing the content as a Draw object now seems the easiest and most logical thing to do. When you import your PDF file into your Draw application, every single line of text will be treated as a draw object and you can edit the text and rearrange it as you like.

Sun PDF Import Extension is still in beta and only works in OpenOffice 3.0.

2) Professional Template Pack II – English

open-office-templatesWith more than 120 professionally designed document templates at your fingertips, it is hard not to create a high quality document or presentation.

This extension adds various kinds of templates, ranging from business correspondence, budgets and project plans, event posters, invoices, notes, minutes, press releases to personal letter templates.


You’ll never have to spend your time writing up the whole document again.

After installation, the templates can be found under File -> New ““> Templates and Documents.

3) OpenOffice.org2GoogleDoc

OpenOffice to Google docs

This extension allows you to export and import documents from Google Docs, Zoho and any WebDav server. Files supported include OpenDocument Text (.odt), StarOffice (.sxw), Microsoft Word (.doc), Rich Text (.rtf), OpenDocument Spreadsheet (.ods), Microsoft Excel (.xls), Comma Separated Value (.csv) and Microsoft PowerPoint (.ppt, .pps).


Java 6 is required to use this extension.

4) Writer’s Tools

writer-tool If you are just like me, who spends a great deal of time sitting behind OpenOffice writing articles, then Writer’s Tools is the extension that you must have. Writer’s Tools is a set of utilities designed to help OpenOffice users perform a wide range of tasks. You can back up documents, look up and translate words and phrases, manage text snippets, and keep tabs on document statistics. Some of the useful functions of this extension include:

  • Lookup word from several sources, including Cambridge Dictionaries, WordNet, and Google Define.
  • Backup a copy of your current document by sending an email to a specified address.
  • Wikify Word tool links a selected word or text fragment in the current document to a Writer document, which is created on the fly
  • Quick Converter that lets you convert between the metric and imperial systems easily.
  • Bookmarks tool allows you to bookmark often-used documents, so you can access them with a few mouse clicks.
  • Word of the Day tool picks and displays a random word and its definition from the accompanying WriterDB database.

and many more…

5) LanguageTool

open office spell checker


What use is there if you can’t check your grammar and other language errors in an Office suite? The LanguageTool extension is an Open Source language checker for English, German, Polish, Dutch, and other languages. It is rule-based, which means it will find errors for which a rule is defined in its XML configuration files. Rules for more complicated errors can be written in Java. You can think of LanguageTool as a tool to detect errors that a simple spell checker cannot detect, e.g. mixing up there/their, no/now etc. It can also detect some grammar mistakes.

The Language Tool extension does not include spell checking.

6) Creative Commons Licensing


If you are always creating open source projects with the Creative Commons License, this extension will come in handy to you. The Creative Commons Licensing extension provides the ability to select and embed a Creative Commons License in Writer, Calc and Impress documents.

7) Data Form

In the Excel application in Microsoft Office, there is this feature – Data -> Form – that allows you to key in data easily. What this extension does is to replicate that feature in OpenOffice. The Data Form extension generates a data input form for tables in the Calc application that you can use to enter values.

In Calc, create a table with at least one row and the headline, for example:


Then, click on a range or any cell of the newly created table (not on empty cells), and go to Data – Form. That’s it. A form should appear letting you insert other records, or edit-delete the old ones.

8) Modern Impress Template

open office impress template

The Modern Impress template extension installs more than 30 beautiful templates that you can use for your presentation. All the graphics in the template are based on open-source art.

After installation, you can access the template at File -> New -> Templates and Documents -> Templates -> My Templates

9) Sun Presenter Console

For those who need to give presentations regularly, wouldn’t it be great if during the presentation, you can view what the next slide is and read the note that you have written all from the screen? It will take the guesswork out of you and also keeps you away from the troublesome paper notes scribbled with tiny text. What this extension does is to project different views to different monitors and allows you to see your upcoming slide and note while the audience only sees the current slide and the slide effect.

There are three views that you can configure in the Presenter Console. The first view displays the current slide for your audience to read while the second view shows the speaker’s notes in large, clear and scalable type plus the current and upcoming slide. The third view is a slider sorter view with the slide thumbnails. In your Impress application, go to Slide Show -> Slide Show settings and you can decide which view is to be projected to each monitor.

Do you use extensions for your OpenOffice? If so, which one is your favorite?

Related topics: Microsoft Excel, Microsoft PowerPoint, Microsoft Word, OpenOffice, Presentations.

Affiliate Disclosure: By buying the products we recommend, you help keep the site alive. Read more.

Whatsapp Pinterest

Leave a Reply

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

  1. Bored
    November 6, 2008 at 12:58 pm

    anyone actually try the import pdf? in my experience most pdfs don't even have the original text data unless they were originally created on the pc.

  2. hughe
    October 24, 2008 at 6:40 pm

    Nice article, thanks!

  3. Lex vd Oudeweetering
    October 22, 2008 at 3:23 am

    PDF import extension has some flaws/bugs. I tried it because recently a fellowillustrator wanted a solution (Not as expensive as buying a pdf editor) for a client to make different presentations of the work of my colleague, made from one total document.
    I experienced the following:
    Grayscale images, made in PhotoshopCS2, (MultipagePDF made in IndesignCS2) are opened and saved inverted and any dustparticles or left pencilscetch marks, which only show faintly when zoomed in, in the original pdf, are shown and saved as lumps of coal.


  4. David
    October 22, 2008 at 2:13 am

    There's another one I think it can be interesting : Sun weblog publisher. You can post to a different platforms (WordPress, Typepad, ...) from Oo just with two clicks, and you can format the text with all the advantages of Oo.

    • Damien Oh
      October 22, 2008 at 5:18 am

      That's a good one too. It will be great if it is free.

      • Rick
        October 22, 2008 at 10:23 pm

        Oh yeah, that would be OOo blog publisher!

  5. j-lon
    October 22, 2008 at 1:35 am

    Maybe they'll eventually get an actual "draft/normal" view. Then I can think more seriously about using OO Writer. Until then, it's just not worth it if you need to edit long documents.

  6. Lex vd Oudeweetering
    October 22, 2008 at 5:13 am

    I meant to underline invert or fatteninvert in my last post.
    And I post again to show what happens in the Draw created/converted pdf in opposition to the original pdf. It looks like a problem with the way masking/Channels work in Draw, because the edge of nonwhite area has no transparacy/fading appearance. It get's hardened and overall the colours shift a bit. See a screencapture with left the Draw-pdf and on the right the original pdf, both as shown in the Acrobat Reader.

    greetings, Lex

  7. westy
    October 22, 2008 at 12:05 am

    When I was a technical, fiscal document and grant writer, I had MS Office. I started to use OpenOffice then because it handled large documents (I was writing or organizing hundreds of pages of text) so much better. Integration of the Calc and Writer was better then Excel and Word as well. I dumped MS Office in 2002 and although I changed jobs and now days I have to use MS Office at work, I would much rather be using OpenOffice.

    These extensions are nice to see, I hope we see more. The scripting and programming available in OO is pretty darn good if people put their mind to it.

  8. matthews
    October 21, 2008 at 9:56 pm

    I wish they would add language tool to the main open office, but allow it to be toggled on and off.

    • Damien Oh
      October 22, 2008 at 5:20 am

      Agreed. That is also my wish list since Open Office 2.0

  9. kaly
    October 21, 2008 at 9:38 am

    Nice roundup.

    Just installed OpenOffice back, after dumping it a year ego.


    • Damien Oh
      October 21, 2008 at 9:40 am

      Welcome to the OpenOffice club, again. I am sure you won't be disappointed this time

    • KA_
      December 16, 2017 at 2:45 pm

      Greetings form year 2017! Still using OO, I can say for sure, Kaly, you're such an...egoist!!!

  10. Charles Peng
    October 20, 2008 at 7:42 pm

    Thanks for your recommendation. And the OpenOffice.org2GoogleDoc is very useful for me.

  11. The Windows Fix
    October 20, 2008 at 5:41 pm

    Nice, these obviously don't a lot of publicity, I personally have never attempted to look for OpenOffice extensions, but figured that they existed.

  12. Mackenzie Morgan
    October 20, 2008 at 1:58 pm

    I don't understand #3. GoogleDocs supports ODF natively. As far as I know, it always has.

    • Damien Oh
      October 20, 2008 at 7:20 pm

      Yes, Google Docs supports ODF. The benefit of extension #3 is to allow you to work your Google Docs or Zoho documents on your Open Office and when you are done, you can easily synchronize back to the server.

      • Aibek
        October 21, 2008 at 9:28 am

        Excellent extension!

        • Ernie Oporto
          October 22, 2008 at 6:12 pm

          Truly! I've been waiting for this a long time. Now I can take my repository of docs and sync them somewhere safe.