Introduction to the

Latex is often used as a typesetting tool for writing papers, but the results of laboratory data are stored in Excel. How can I efficiently import excel data into latex with one click?

This problem must be troubling many researchers, today xiaobian to recommend you a commonly used form conversion website.

The Exceltolatex plugin works better if you’re running Windows, but it doesn’t work for MAC, so I’m writing this post for MAC users (Windows also works, of course).

Tableconvert.com

The home page is as follows:

Using the tutorial

  1. We selected and copied excel data

  1. Then click the Import button of the website and paste it into the interface as follows:

There are other forms of input, such as SQL, CSV, etc. Of course, you can also import your Excel spreadsheet in the lower right corner.

  1. Then select Import Data and hit Export format Latex to get the following screen:

Of course, in the upper right corner of the Options you can add table title, label, arrangement and so on.

  1. Then copy it, import it into latex, and use it. Small editor latex compilation results:

  1. Manually adjust the table format

Ugly though it is! But it’s very efficient, and then all you have to do is adjust the size of the table, the form, and so on.

You’d better have some knowledge of latex! If necessary, please leave a comment and write some common knowledge points about latex

For example, I made a small change to the latex statement and got the following compilation result.

\begin{table}[HTBP] \ Register {Press register: mark, mark, mark, mark, mark } \vskip 2mm \ setLength {\tabcolsep}{6mm} \begin{tabular}{LCCCCCC} \ Toprule \multirow{2}{*}{model} & \ multirow {2} {*}} {AIC & \ multicolumn {6} {c} {parameter estimation} \ \ \ cmidrule {8} 3 && $\ hat {b} $& $\ hat {c} $& $\ hat {d} $& $\ hat {\ sigma} $  & $\hat{a}_0$& $R_t $ \\ \midrule GH & 666 & 666 & 666 & 666 & 666 & 666 & 666 \\ TS & 666 & 666 & 666 & 666 & 666 & 666 & 666 \\ Pool & 666 & 666 & 666 & 666 & 666 & 666 & 666 \\ Fixed & 666 & 666 & 666 & 666 & 666 & 666 & 666 \\ \bottomrule \end{tabular}% \end{table}Copy the code

Xiaobian has something to say

  • This is a small, scientific must-have site for converting Excel data to latex, among other things. This is also a small paper preparation commonly used website, to share with you.
  • If feel useful, please help one key three connect! Also feel free to share your scientific research “small website” in the comments!