Making tables in LaTeX can be tedious, especially if some columns are calculated. This converter allows you to write a table in Excel instead, and export the current selection as LaTeX markup which can be pasted into an existing LaTeX document, or exported to a file and included via the
Known to be compatible with Windows Excel 2000-2016 (32-bit and 64-bit) and Mac Excel 2004, 2011, and 2016. May also be compatible with other versions that support
Most Excel formatting is supported.
- Bold and italic (if applied to the whole cell)
- Left, right, center, and general alignment (per-cell or per-column)
- Vertical and horizontal borders (per-cell or per-column, single or double)
- Font color (using the
- Fill color (using the
- Rotation (using the
- Merged cells (using the
multirowpackage, if needed)
- Can convert
#to appropriate macros, or leave them in-place
booktabsis not available
- Makes standard LaTeX
- Can surround
- Copy output to clipboard or export to a
.texfile for inclusion using
- Save table specifications to your Excel worksheet, then export all tables at once
Just open the file Excel2LaTeX.xla in Excel. Then you will have two additional menu items in your Tools menu and a new toolbar with two buttons on it. For Excel 2007 and later, you will have two new buttons in the Add-Ins ribbon. If you plan to use the program frequently, you can save it in your addin directory and add it with Tools->Add-Ins. This way it will be loaded whenever Excel is opened.
Select the table to convert and hit the button Convert Table to LaTeX. You will be given the option to save the result to a
.tex file, or send it to the clipboard (so you can paste it into your LaTeX editor). Hit the Store button to store the current settings so you can Load them later or Export All to files.
Bugs and Source
This development repository and the bug tracker for this package are hosted at https://github.com/krlmlr/Excel2LaTeX/
Copyright (c) 1996-2016 by Chelsea Hughes, Kirill Müller, Andrew Hawryluk, Germán Riaño, and Joachim Marder.
This work may be distributed and/or modified under the conditions of the LaTeX Project Public License, either version 1.3 of this license or (at your option) any later version. The latest version of this license is in http://www.latex-project.org/lppl.txt and version 1.3 or later is part of all distributions of LaTeX version 2005/12/01 or later.
This work has the LPPL maintenance status
maintained'. The Current Maintainer of this work is Chelsea Hughes. This work consists of the file Excel2LaTeX.xla.
Download the contents of this package in one zip archive (102.5k).
Excel2LaTeX – Convert Excel spreadsheets to LaTeX tables
Making tables in LaTeX can be tedious, especially if some columns are calculated. This converter allows you to write a table in Excel instead, and export the current selection as LaTeX markup which can be pasted into an existing LaTeX document, or exported to a file and included via the \input command.
|License||The LaTeX Project Public License 1.3|
Andrew Hawryluk (inactive)
Joachim Marder (inactive)
import files in a non-TeX (or different TeX) format|