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.
The development repository and the bug tracker for this package are hosted on GitHub. To work with the project, you will require chelh's VBA Sync Tool.
Copyright © 1996–2017 Chelsea Hughes, Kirill Müller, Andrew Hawryluk, Germán Riaño, and Joachim Marder.
This work is distributed under the LaTeX Project Public License, version 1.3 or later, available at http://www.latex-project.org/lppl.txt
Chelsea Hughes currently maintains this project (comprising
README.md) and will receive error reports at the project GitHub page (see Contributing above).
Download the contents of this package in one zip archive (102.9k).
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.
|Licenses||The LaTeX Project Public License 1.3|
|Copyright||1996–2016 Chelsea Hughes, Kirill Müller, Andrew Hawryluk, Germán Riaño, and Joachim Marder|
Andrew Hawryluk (inactive)
Chelsea Hughes (inactive)
Joachim Marder (inactive)
Kirill Müller (inactive)
George Pearson (inactive)