App Icon
Yi-Hang Zhu
•  88,703
Overview
The add-on is for converting a Google Spreadsheet table to a LaTeX table or a LaTeX table to a Google Spreadsheet table.
It is rather painful to migrate information from a spreadsheet table to LaTeX or restore a spreadsheet table from LaTeX.

Spread-LaTeX add-on is built to solve this problem. It simply contains two functions: convert a selected Google Spreadsheet table to a LaTeX table and convert a LaTeX table to a Google Spreadsheet table.

========== How to use Spread-LaTeX? ==========
Install the add-on:
(1) open a Google Spreadsheet, 
(2) click "Add-ons" ---> "Get add-ons" ---> search "Spread-LaTeX" and install. 

Convert a spreadsheet table to LaTeX: 
(1) select a table in a Google Spreadsheet, 
(2) click "Add-ons" ---> "Spread-LaTeX" ---> "Convert sheet->LaTeX", 
(3) a window will popup, type in the total number of rows for column names and click "OK", 
(4) select all the generated LaTeX code (e.g. Ctrl + A) and copy (e.g. Ctrl + C). 

Convert a LaTeX table to a spreadsheet table:
(1) copy the LaTeX code between \toprule and \bottomrule of a table and paste it to any place in a Google spreadsheet,
(2) click "Add-ons" ---> "Spread-LaTeX" ---> "Convert LaTeX->sheet",
(3) the current sheet will be cleaned and a generated table will be presented in the same sheet.
*Errors may occur if the LaTeX table was not generated by Spread-LaTeX.

========== Settings ==========

(1) Package {booktabs} is used for borders. 
(2) Package {xcolor} is used for cell colours. 
(3) Package {soul} is used for underlines. 
(3) Environments {tabular} and {table} are used. 
(4) Special LaTeX chars: only "%"s are replaced with "\%". The rest special LaTeX chars remains intact, given that they may not be plain text. For example, $x$ may be a mathematical notation.
(5) For the purpose of simplicity, this add-on only reads the following information from a spreadsheet table: the data, data formats, highlights, font weights, underlines and merged ranges.
(6) Tables’ configurations such as alignments and borders are generated via the code using a default setting.
Reviews
Language:
Sort by:
Profile Picture
Asha Ram Gairola
November 13, 2020
Thank you very much Dear Yi-Hang Zhu. It was really very helpful.
Is this review helpful?
Yes
No
Profile Picture
Simon George
September 10, 2020
Seems to work well.
Is this review helpful?
Yes
No
Profile Picture
Owen Davis
July 27, 2020
Nicely done, very straightforward. Simple and clean.
Is this review helpful?
Yes
No
1-3 of 3
Additional information
Yi-Hang Zhu
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu