This script consumes a LaTeX source code file containing multiple tabular environments and generates an Excel workbook where each table is stored in an individual worksheet. In addition to traditional commands like
\multicolumn, many commands from the
booktabs package are also supported. I wrote this script during my tenure as a research assistant.
Try it out!
Make sure you have
pip installed. Then run
pip install latex2excel or
pip3 install latex2excel.
Dummies’ Guide for macOS Users
If on macOS, run the following:
/usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"
brew install python3
pip3 install latex2excel
in a terminal window. this sets up Homebrew and installs python3 using Homebrew.
latex2excel recent_table.texwill generate an Excel file with the name
recent_table.xlsxat same directory as
latex2excel recent_table.tex table_03will generate an Excel file with the name
table_03.xlsxin the current working directory (use
pwdto get the current working directory)
- It does not support nested tables.
- Does not support nested commands in general because this script uses simple regex to identify tabular environment and various commands.