Text & Writing
LaTeX Table Generator (from Excel or CSV)
Paste cells from Excel, Google Sheets, CSV or a Markdown table and get clean LaTeX tabular code: booktabs or grid lines, automatic number alignment, bold header, caption and label, with special characters escaped.
How to use
- 1Copy cells from a spreadsheet and paste them in (or type comma-separated values).
- 2Choose the line style, alignment, caption and label.
- 3Copy the LaTeX code into your document. For booktabs, add \usepackage{booktabs} to the preamble.
Frequently asked questions
What's booktabs and why is it the default?
booktabs is the LaTeX package most journals and style guides recommend. It uses three horizontal rules of different weights (top, middle, bottom) and no vertical lines, which reads more cleanly than a full grid.
How does automatic alignment work?
Columns where every value below the header is a number (including decimals, negatives and percentages) are right-aligned so digits line up; all other columns are left-aligned.
Why are some characters changed?
&, %, $, #, _, {, }, ~, ^ and \ have special meanings in LaTeX and break compilation if left as they are, so they're escaped (for example % becomes \%). Turn escaping off if your cells already contain LaTeX such as $\alpha$.
Worked example: a three-row results table
Pasting 'Group, Mean, SD' followed by 'Control, 12.4, 3.1' and 'Treatment, 15.9, 2.8' with the defaults gives a table environment with \caption{Results} and \label{tab:results}, a tabular with column spec lrr (Group left-aligned, the two number columns right-aligned), \toprule above the header, \midrule under it, and \bottomrule at the end. Each row ends in \\ and cells are separated by &.
Pasting from a spreadsheet
When you copy cells from Excel, Numbers, LibreOffice or Google Sheets, the clipboard holds them as tab-separated text, so cells that contain commas (like '1,250' or 'Smith, J.') stay in one piece. Comma- or semicolon-separated text and Markdown tables with | separators also work. Rows that are shorter than the longest row are padded with empty cells so the table always compiles.
Caption above, label after
Tables are captioned above the table in APA, IEEE and most journal styles, so the caption comes first. The \label must come after \caption: LaTeX attaches a label to the most recent numbered item, and a label placed before the caption makes \ref point at the section number instead of the table number.
Related tools
- Text to Table Converter
Turn tab, comma or space separated text into a Markdown, HTML or aligned plain-text table.
- German & French Noun Gender Checker (der/die/das, le/la)
Find the gender and article of German and French nouns — der, die or das; le or la. Common nouns are looked up; others are predicted from their ending, with how reliable that rule is.
- British ↔ American Spelling Converter
Convert between American and British spelling — color/colour, center/centre, organize/organise, traveled/travelled and more.
- LaTeX Equation to Image (PNG & SVG)
Type a LaTeX equation and download it as a sharp SVG or a 150–600 dpi PNG with a transparent background, ready for Word, PowerPoint, Google Slides or the web. Live preview, AMS environments and chemistry formulas.
- Word Tables to Excel Converter
Pull every table out of a Word document into an Excel workbook, one sheet per table or all on one sheet. Merged cells stay merged, header rows are kept, and numbers, currencies and percentages typed as text become real numbers you can sum.
- Pivot Table Tool (Summarize CSV & Excel Data)
Summarize spreadsheet data with a pivot table in your browser — group by rows and columns, sum, count, average, min or max, group dates by month, quarter or year, and export to Excel.