How To: Install and Use Calc2LaTeX [Tutorial]

This guide is intended to give a brief, but complete tutorial aimed towards users who enjoy an easy, graphical walk-through on downloading, installing, and using calc2LaTeX to convert a OpenOffice 2.4 Calc spreadsheet to something that LaTeX will recognize.  There’s nothing wrong with creating your tables directly in LaTeX, but sometimes the tables can be quite complicated to code. That’s where calc2LaTeX comes in really handy.  So, let’s get to it…

Download and Unzip

  1. Use the links above to download the file to your harddrive.  Save them in an easy spot to access and remember, like your desktop.
  2. Unzip the file to the same, easy to find, location. Usually, this is just a matter of performing a right-click and select “Unzip Files” or “Extract Here”.


  1. Open OpenOffice Calc.
  2. Navigate to “Organize Macros” by clicking on “Tools” -> “Macros” -> “Organize Macros” -> “OpenOffice.org Basic…”
  3. Click on “Organizer”
  4. Select the “Libraries” tab and then click “Import”
  5. Browse to the location where the original download file was unzipped and select “script.xlb”
  6. That’s it. Accept the defaults and click “OK”.

Using calc2LaTeX

  1. Highlight the columns and rows that you wish to convert into a LaTeX table.
  2. Run the calc2LaTeX macro that you just installed by navigating to “Run Macro” through “Tools” -> “Macros” -> “Run Macro”
  3. In the left pane of the window, drill down to and select the last instance of “Calc2LaTeX” by clicking on “My Macros” -> “Calc2LaTeX” -> “Calc2LaTeX”. In the right pane of the window, highlight “Main” and then click on “Run”.
  4. Here is where you can select all of your options for your table before producing the LaTeX code.
  5. Once you’re finished configuring your options, click on “Convert”. A window will pop up with all of the LaTeX code highlighted and ready for copy/paste into your LaTeX editor.
  6. Congrats! You’re finished! Not much to it, is there?

I hope that this has given you a very quick and thorough guide on how to download, install, and use Calc2LaTeX for OpenOffice 2.4. As you may have noticed, I wrote this guide while using Linux. The steps above should be very similar, if not exactly, the same in a Windows or Mac OSX environment.


Source: http://calc2latex.sourceforge.net/install_oo20/

Feel free to donate if this post prevented any headaches! Another way to show your appreciation is to take a gander at these relative ads that you may be interested in:

There's 13 Comments So Far

  • Vikas Rawal
    November 28th, 2008 at 5:16 pm

    Just to say that this works fine with openoffice.org 3.0.

    I tried it on OOo installed on debian linux.


  • Marco
    August 2nd, 2010 at 5:13 am

    Works with OpenOffice 3.2.0 on Ubuntu 10.04.

    Thank you very much for the tutorial, this is much clearer than the one provided by calc2latex web page on sourceforge.

  • gogo
    August 19th, 2010 at 3:20 am

    thanx a lot, this is a nice tuto and nice module 😉

  • toru
    December 28th, 2010 at 3:35 pm

    works on debian lenny & OO3.1.1 … awesome explanation btw. thanks a lot.

  • rubix
    April 20th, 2011 at 9:59 am

    Nice, thanks. It works really well

  • Joachim Arts
    July 27th, 2011 at 9:41 am

    This also works for LibreOffice! nice job

  • [email protected]
    July 27th, 2011 at 10:17 am

    Thank you!

  • martin
    August 30th, 2011 at 4:19 pm

    Thanks! Took me about a minute to install and quick-test it with this tutorial…

    Works just fine with Ubuntu 10.10 and OpenOffice 3.2.1

  • Victor
    January 6th, 2012 at 2:19 am

    Found this post after spending some time struggling with this module and the default extension manager, thanks a lot!
    Works fine with LibreOffice 3.4.4. You can also add a custom toolbar with a button pointing to the macro.

  • Joachim
    February 26th, 2012 at 2:31 pm

    Just to let you all know. It works without problems in LibreOffice 3.4.4.

  • Steyn
    December 2nd, 2012 at 12:58 pm

    Awesome! Saved me hours of work! Works like a charm on LibreOffice

  • Kristina
    April 18th, 2017 at 5:59 pm

    Thank you, this is awesome!! It worked perfectly with LibreOffice Version: as well.

Who Linked To This Post?

  1. Ferramentas úteis do dia – LaTeX, gerar diagramas etc | Juliana Fajardini

Share your thoughts, leave a comment!