Editing LaTeX tables in MS Excel

I have a big LaTeX table that I want modify it in Excel, is there any solution? There is some good solutions for converting Excel table to Latex tables.

asked Apr 4, 2013 at 16:30 Real Dreams Real Dreams 8,358 12 12 gold badges 58 58 silver badges 78 78 bronze badges You can use CSV files and set up it to use & as the values separators. Commented Apr 4, 2013 at 16:33 excel2latex . I only know that it exist, never used it. Commented Apr 4, 2013 at 16:38 Have a look at datatool. what kind of modification in excel that it cannot be done in latex itself? Commented Apr 4, 2013 at 16:40 Commented Apr 4, 2013 at 16:41

@Sigur Thanks. My table is not so simple, it contains merged cells and indeed I want change the merging style.

Commented Apr 4, 2013 at 16:51

3 Answers 3

You can import a latex table into excel.

  1. In the excel main menu select File -> import .
  2. choose csv or text as file type
  3. choose "&" as your delimiter (un-select all others)
  4. finish
answered Jan 26, 2018 at 17:23 201 2 2 silver badges 3 3 bronze badges

As far as I know there exists no solution you want, even if you want to merge cells.

The only thing that exists is excel2latex, but I never saw a result of this Excel macro that has not to be reworked.

Perhaps a pretty printing of your table could help you. For example write all & below each other so you can see the columns of your table in your tex file.

\beginl*c> \toprule \multicolumn<> & & \multicolumn \\ \cmidrule \multicolumn & 25 & 28 & 29 & 31 & 32 \\ \midrule 9/29/2007 00 &00 & \ding & \ding & \ding & \ding & \ding \\ 9/29/2007 01 &00 & \ding & \ding & \ding & \ding & \ding \\ 9/29/2007 23 &00 & \ding & \ding & \ding & \ding & \ding \\ \midrule 9/29/2007 23 &00 & \textbullet & \textbullet & \textbullet & \textopenbullet & \textopenbullet \\ \midrule 9/29/2007 23 &00 & $\blacksquare$ & $\blacksquare$ & $\blacksquare$ & $\square$ & $\square$ \\ \bottomrule \end

In this was you can easy see the columns of your table and you can change the mergin style by inserting \multicolumn . The bad example would be something like this:

\beginl*c> \toprule \multicolumn<> & & \multicolumn \\ \cmidrule \multicolumn & 25 & 28 & 29 & 31 & 32 \\ \midrule 9/29/2007 00&00 & \ding & \ding & \ding & \ding & \ding \\ 9/29/2007 01&00 & \ding & \ding & \ding & \ding & \ding \\ 9/29/2007 23&00 & \ding & \ding & \ding & \ding & \ding \\ \midrule 9/29/2007 23&00 & \textbullet & \textbullet & \textbullet & \textopenbullet & \textopenbullet \\ \midrule 9/29/2007 23&00 & $\blacksquare$ & $\blacksquare$ & $\blacksquare$ & $\square$ & $\square$ \\ \bottomrule \end