Free web tool

Excel to LaTeX

Turn an Excel workbook (.xlsx) into LaTeX tables for your paper: booktabs rules, numbers right-aligned, special characters escaped, and a table environment with a caption and label. The workbook is read on your device. Nothing is uploaded.

Drop Excel workbooks here Choose files XLSX and XLSM, up to 50 MB each.

Options

Sheets First sheet All sheets, one table each

The first row is the header Use booktabs rules Wrap in a table with a caption and label

Bytes of your files sent anywhere: 0

Files are read and converted in this tab, in a background worker. The only requests the page makes are for its own scripts. Your files are never sent anywhere.

How it works

The page opens the workbook with JSZip, served from this site, and reads each sheet in a background worker in this tab, keeping the type Excel gave each cell.

Each sheet becomes a tabular: a column is right-aligned when every value under the header is a number, the header is set off with a midrule, and the characters LaTeX treats as commands, & % $ # _ { } ~ ^ and the backslash, are escaped so the table compiles as it is. Numbers come out as the workbook stores them.

To paste a few rows instead of uploading a workbook, the LaTeX Table Generator does the same from CSV text.

How to convert Excel to LaTeX

Pick the options. Keep booktabs and the table environment on for a paper; turn the environment off to paste the tabular into your own.
Add the workbook. Drop the .xlsx file on the box, or click it to choose it.
Download. Download the .tex file from its row.
Add it to your paper. Paste the table into your document, or use \input{}, and add \usepackage{booktabs} to the preamble.

Limits

Up to 50 MB a workbook and 5 million cells.
Numbers are written as stored, not as displayed: 12% is 0.12, and currency signs and thousands separators are not added.
Merged cells, colors, borders and fonts are not carried over, and wide tables are not scaled to the page.
Line breaks inside a cell become spaces.

Questions

Are my files uploaded?

No. The page reads each workbook with your browser and converts it in a background worker in this tab. There is no server step. The meter under the drop zone counts the bytes the page and its worker send while they work, so you can check this yourself. The only things the page downloads are its own scripts.

What is booktabs?

A LaTeX package for tables with three horizontal rules of different weights and no vertical lines, the style most journals ask for. Add \usepackage{booktabs} to your preamble, or turn the option off for plain \hline rules.

Will special characters break my document?

No. Ampersands, percent signs, dollar signs, underscores, braces, tildes, carets and backslashes in cells are escaped, so the table compiles as it is.

Can I convert several sheets?

Yes. Choose All sheets and each sheet becomes its own table in one .tex file, captioned with the sheet name and labelled tab: followed by it.

Is it free?

Yes. There is no account, no watermark and no limit beyond the sizes above.

If this saves you time, you can leave a tip. It helps keep these tools free and online.