TeX - LaTeX Asked on July 17, 2021
I usually do all of my tables using Google Docs spreadsheet. This is a good and quick way to organize information and create quick tables.
Now I am writing a document in Latex and I would like to port the tables.
I tried downloading the sheet as a CSV file and then using the csvsimple
package to convert it into latex, but this has several faults (does not copy cell borders, does not respect page width and height, etc), and in the end with all the configurations it is almost just as complex as creating the tables myself.
I recognize some of the problems are inherent to the CSV file format (no package can guess information that the CSV file does not contain), so I was wondering: Is any other way of quickly porting my Google Doc tables to latex?
Here is a link with a simple set of three tables and a graph that I would like to port to latex:
This is exactly the same problem I and my classmates were having when writing our lab reports on Experimental Physics. Since we work in groups it's great to have data on the cloud. The problem was converting sometimes dozens of tables to Latex...
So, I and a classmate of mine came up with LatexKit, a google sheets add-on that creates and exports to your Google Drive a text file containing the tabular environment of a given table.
For your case, this won't handle page width or height, nor copy the exact borders you have configured (although there is a way to overcome this, keep reading), but it can help you get started with little trouble and systematically for multiple tables.
This add-on is developed using Google apps script so, unfortunately, the lack of some features is not easily overcomeable.
It does, however, help a lot when converting tables from Google Sheets to Latex
It has some additional features that could help you or someone else in the future.
Current Features:
Handles multirow and multicolumn environment using the multirow package
Handles uncertainties notation $pm$ (especially useful to us at experimental physics)
Features that can or will be implemented (given the time and will of the community):
Here's LatexKit in action
This is the table on the spreadsheet:
This is the exact code produced by LatexKit using the template 'grid':
begin{tabular}{|c|c|}
hline
Time (h) & Temperature (C) hline
12 & 19.5 $pm$ 0.4 hline
13 & 20.3 $pm$ 0.6 hline
14 & 21.8 $pm$ 0.7 hline
15 & 20.9 $pm$ 0.6 hline
16 & 19.7 $pm$ 0.4 hline
end{tabular}
This is the result when compiled in Latex:
This is really a project to the community so we would gladly take your advice to improve!
Correct answer by Daniel H. on July 17, 2021
You can use the google docs extension LatexKit
Answered by user128666 on July 17, 2021
You can use Spread-LaTeX, a simple add-on which was designed for converting a Google spreadsheet table to a LaTeX table or a LaTeX table to a Google Spreadsheet table.
Answered by yihang.zhu on July 17, 2021
Perhaps the most non-invasive way would be to download the table as a CSV and then use a trusted tool for conversion of CSV into a LaTeX table.
I haven't personally used this, but you can try csv2latex.
Answered by helperFunction on July 17, 2021
Get help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP