Free tools · LaTeX
Excel to LaTeX table
Copy cells from Excel, Google Sheets or Numbers, or paste a CSV, and get a LaTeX table with booktabs rules, escaped special characters and numbers right-aligned.
LaTeX table
How to use it
- Select the cells in your spreadsheet and copy them, then paste here. CSV and semicolon-separated text work too.
- Choose the options: header row, booktabs, alignment, caption and label, table float.
- Copy the LaTeX into your document. Add \usepackage{booktabs} if you kept booktabs on.
Why you'd use it
Results live in a spreadsheet and the paper lives in LaTeX. Typing a results table into tabular by hand means retyping every number, and the ampersands, percent signs and underscores that break the build.
This converter reads the tab-separated text spreadsheets put on the clipboard, escapes what LaTeX would misread, and right-aligns columns that are all numbers, which is what a results table should do.
FAQ
Can I paste straight from Excel?
Yes. Select the cells, copy, and paste into the box. Excel, Google Sheets, Numbers and LibreOffice all copy as tab-separated text.
What is booktabs?
A LaTeX package that gives tables the thin top and bottom rules and the mid rule under the header, with no vertical lines. It is the look of almost every table in a published paper. Add \usepackage{booktabs} to your preamble.
How is column alignment chosen?
A column whose cells are all numbers (including 92.1, 1,000, 5% or 2e3) is right-aligned; everything else is left-aligned. Override with the alignment option.
Will $\alpha$ in a cell be escaped?
No. Text between dollar signs is treated as math and left alone; everything else is escaped.
Where do the caption and label go?
Inside a table float above the tabular, in the order \caption then \label, so \ref{tab:...} picks up the table number.