Export Excel tables to Overleaf

Question

Good morning everyone,

I have been trying to export Excel tables to my Overleaf file. I have succeeded to some extent using \includegraphics command, but the problem with that is that the font size is not editable on Overleaf. The attached is done using the command.

I have also tried to convert Excel to a .tex file using an add-in excel2latex but it did not work very well on Overleaf.

Could you please provide more tips or advice?

Why do you cover the table by black rectangle? If you don't want to show us the information, you can type in each cell A, B, C, or something like that. — , Nov 05 '18 at 15:53
Have you seen Comprehensive list of tools that simplify the generation of LaTeX tables? — Paul Gessler, Nov 05 '18 at 16:09
When I want to retain the exact formatting, I usually save the sheet as pdf and then include as graphics in latex. — nidhin, Nov 06 '18 at 06:23

Mibi · Answer 1 · 2018-11-05T16:08:59.023

9

One possible solution I can think of from the top of my head is to load the excel table with the python module pandas and than use the export as tex file function in pandas.

#As example:
import pandas as pd
df = pd.read_excel(excel_file.xlsx)
df.to_latex(output.tex)

edited Nov 05 '18 at 16:08

answered Nov 05 '18 at 15:41

Mibi

486

2

Thank you for suggesting a solution. Unfortunately, I have not used Python before. – Super_positive_Gaussian Nov 05 '18 at 15:48
Thank you! The only fix is that pandas does not interpret xlsx, only xls. But it is a great solution! – Pereira May 01 '21 at 22:28

score 3 · Answer 2 · answered Nov 08 '18 at 23:04

3

Have you tried saving the excel file as a CSV and importing it to:

https://www.tablesgenerator.com/

You will have to do the formatting again but you can get it exactly how you want it and fairly quickly

answered Nov 08 '18 at 23:04

Hugo Russell

31

I've used this before, but this site seems to be broken now: it dumps all the table's data into just the first column. – Aaron Bramson Feb 10 '19 at 04:17
1

works for me real good. – Cohensius Oct 24 '19 at 12:11

score 2 · Answer 3 · answered Jun 26 '21 at 10:51

2

A bit late answer, but I hope that future users would be able to take advantage of this. Tables Generator now gives the possibility of generating a LaTeX table directly from copy-paste a table from Excel. Just create the table in Excel, copy it, than on Tables Generator click File -> Paste table data. It is also possible to paste with formatting. The only feature you will lose is the border widths.

answered Jun 26 '21 at 10:51

mao95

121

1

This is cool! Just what is needed.. fast, simple, loads of features! Thanks for finding and sharing! – Srichakradhar Dec 16 '21 at 23:42

score 1 · Answer 4 · answered Nov 08 '18 at 23:18

1

Generate your data as a CSV file. Use the datatool package to load and display the data.

\document{article}
\usepackage{datatool}
\DTLloaddb{data}{myfile.csv}
\begin{document}
\DTLdisplaydb{data}
\end{document}

answered Nov 08 '18 at 23:18

Jeffrey J Weimer

677

9Morgan8 · Answer 5 · 2023-07-26T05:35:22.997

0

By now you can also input your data as text in ChatGPT and ask it to "Please return the LaTeX code of the below table for me".

[Examplary table code]

It will produce a basic table you can then adjust.

edited Jul 26 '23 at 05:35

answered Jul 26 '23 at 05:33

9Morgan8

1

Export Excel tables to Overleaf

5 Answers5