I'm not aware of such a plugin. But what I would do is just convert your excel table into csv, and then would use command line tools (e.g. awk, sed, tr) to generate rows in latex format by e.g. simply substituting your csv separator with &. As a side node, you might want to look (if you didn't yet) into the LaTeX "longtable" package so that your big tables are nicely scattered across multiple pages.

Thank you for your quick reply, Vyacheslav. I figured .csv would be one possible strategy. I am already familiar with the longtable format.

I saw that there is a converter called Excel2LaTeX (http://mirror.hmc.edu/ctan/help/Catalogue/entries/excel2latex.html), but I haven't tried it yet, and some users seem to report errors with EXCEL Mac 2011.

Hello,

I have used datatool package for reading csv files,

here is an exemple

cordially,

Georges

Hello George,

this looks very good! I will remember next time when I have .csv type of data.

Meanwhile, I have successfully used the Excel2Latex plugin for Excel (Mac 2011, I have Version 14.2.5). There might be some issues with installing, but the help forums are useful, and once you get it running, it is very easy to convert a selected area from the excel spreadsheet into tex-format. You can then just copy the stuff to the clipboard and paste into your tex-editor (I use Sublime Text 2, a programmers tool).

In my opinion the main advantage of this plugin is that you don't have to do an intermediate step (.xls -> .csv -> import into Tex), but you can directly work from Excel to Latex.

In case of very long (multipage) tables where you need also multirows, multicolumns, text wrapping within cells and a defined table width, I have come across the longtabu environment, which I strongly recommend. Very easy to use (like tabular + longtable).

I have used Excel2LaTeX, an Excel add-on, before... it worked pretty well although you might need to do some bit of tweaking on the final presentation of the table to suit your taste...

Hey Maria. Did you try latable? In my experience, it's better than Excel2Latex in many respects. For instance, the latter has a funny way of dealing with merged rows and columns whereas with the former, it's a roller-coaster ride. In fact, with latable, you get almost WYSIWYG editing.

Hey Abiodun,

I downloaded LaTable just for fun, but it doesn't seem to work on my Mac. The program immediately closes after starting, I don't even have time to write down the error message.

I don't use Mac so I can't tell what the problem is.

Hey Maria,

I assume you have the basic LaTeX knowledge... why dont you create the simplest form of the table that you want yourself... use Excel2LaTeX or LaTable to import data from xls (or whatever form its in)... then replace the Excel2LaTeX or LaTable formatting code to marry your simple template to the desired data...

You get my drift?

I do not know why nobody mentioned, but I use the following solution:

1 step: In Excel: File -> Save As -> Tab Delimeted Text (data.txt)

2 step: In Latex: LOAD the file (data.txt) and FORMAT by using beautiful and very convenient package PgfplotsTable: http://pgfplots.sourceforge.net/pgfplotstable.pdf

A simlple solution for me was to make an Excel Macro that simply add the required "&" and "\\" between cells and rows. Then you have to copy to latex in the proper Table environment. I share the excel file.

Here is a helpful anwser for you. Good Luck!

http://www.ctan.org/tex-archive/support/excel2latex/

Did anybody has the way in Open office, I have Open office with me

Open Office (OO) can handle macros, but I´m not sure if they are correctly converted by OO. You can try to open this excel sheet in Calc and later, copy and paste the code (included in the txt file attached) in a New Macro in Calc. You can run the macro from an assigned button or from the menu. I hope this help you.

I think you should take a look to this link...if you use TexShop in Mac it works beautifully. Good luck!

http://heplife.blogspot.jp/2012/05/excel-to-latex.html

An extremely easy way to do this is to copy and paste your spreadsheet table into this online tool, which will automagically convert it to a LaTeX table!

http://www.tablesgenerator.com/latex_tables

if anybody should stumble over this, there was an update to the excel2latex package in 2016. The author claims compatibility with excel 2000 through 2016. Haven't tested it myself, yet. You can find it on ctan like every other package (even though it's not a package, but rather an excel plug-in.

Use Calc2LaTeX for converting spreadsheets into LaTeX: http://calc2latex.sourceforge.net/

Interesting answer from two years ago. I still haven't tested its contents, tbh.

I still do it the old fashioned way with a regular table in excel and LaTeX commands in a parallel table in the same sheet, then I copy the cells with LaTeX code and insert them in my document. Not much different than what I would need to do to insert an excel table in a, say, word document.*

This is a pretty robust method allowing future editing to the table without messing up everything. I wrote an answer on tex.se to a similar question that highlights what I do to make excel and LaTeX work together: https://tex.stackexchange.com/a/428659/117274

* I know I could have an excel-like table directly embedded in a word document, but that just bloats up the word document and is prone to being corrupted when editing stuff around the table. Because that's just how word and MS Office works in general. :D Word is made for text, excel for tabular calculations. I don't do my calculations in LaTeX, so why would I want to make them in word? That's messy.

I used the following package, I found these are very helpful.

https://www.ctan.org/pkg/excel2latex

https://tablesgenerator.com/latex_tables

I always benefit from the following package

http://www.tablesgenerator.com/latex_tables

Regards