Tables, equations, and bibliography checks

A spreadsheet can go straight into the LaTeX or Typst document you’re writing, from the editor’s right-click menu. When you want one result without setting up a manuscript first, use one of the tools below.

Import a table from a data file

In a LaTeX or Typst document, right-click where the table should go and choose Table from CSV/XLSX…. The dialog, Import a spreadsheet as a table, works like this:

1. Choose Choose CSV, TSV, XLSX, or JSON and pick the file. Excel files (.xlsx and .xls) are read from their first sheet. A JSON file has to hold a list of records or a list of rows.
2. Check the preview. It shows the first rows and columns, and the whole table is inserted.
3. Leave First row is a header on if the first row holds column names.
4. Add a Caption and a Label if you want them. Both are optional. A label such as tab:results lets you cite the table with \ref{tab:results} in LaTeX or @tab:results in Typst.
5. Choose Insert at cursor, or Copy source to put the table on the clipboard instead.

The table is written in the document’s language. A LaTeX table uses booktabs for its top, middle, and bottom rules, so the document needs \usepackage{booktabs}. A Typst table uses the same three rules and needs no package. Special characters in the cells are escaped in both.

Keep a Typst table linked to its data

In a Typst document, the dialog also has Keep linked to the data file. With it on, Oleafly copies the data into the project’s data folder, and the table reads that file each time the document compiles. Edit the file and the table changes on the next compile, with no need to import it again. An Excel sheet is saved there as a CSV file. A linked table is inserted at the cursor, so Copy source isn’t offered for it.

LaTeX tables are always copied into the source as text. To update one, import the file again.

Start from what you have

These tools are part of Oleafly Tools. Enable LaTeX tools in Settings → Experimentation, then open Oleafly Tools from the library.

You have	You need	Open
A few rows and columns	An editable LaTeX table	Table to LaTeX
An Excel, CSV, or TSV file	A LaTeX table from the first sheet	Excel to LaTeX
An Excel, CSV, or TSV file	A Typst table from the first sheet	Excel to Typst
Typed notation or an equation image	Editable LaTeX math	Equation to LaTeX
Working LaTeX math	An SVG, PNG, MathML, or web snippet	LaTeX to Image
A .bib file	Structural errors and missing fields	BibTeX Validator

A small table example

Open Table to LaTeX, create three columns, and enter a header followed by your values:

Method	Accuracy	Time (s)
Baseline	0.81	12.4
Revised	0.86	10.1

Mark the first row as a header, right-align the numeric columns, and enable booktabs rules. Copy the generated source into the manuscript, add \usepackage{booktabs} if needed, and compile.

Use Excel to LaTeX instead when copying cells by hand would be error-prone. It reads the first worksheet and caps input at 10,000 rows, 100 columns, and 2 MB of cell text. Formula cells use the workbook’s cached result, so recalculate and save the sheet before importing it.

An equation in either direction

Use Equation to LaTeX for notation such as sqrt(x^2 + y^2) <= r or for a screenshot that needs transcription. Simple typed notation is normalized locally. Natural-language math and images need a compatible local Ollama model.

Use LaTeX to Image after the expression is correct. SVG stays sharp in a diagram or on the web; PNG works in software that cannot place SVG. Prefer MathML or an editable equation when the destination supports it, because an image alone does not expose mathematical structure to assistive technology.

Validate before the final compile

Paste a bibliography into BibTeX Validator to find parse errors, missing required fields, and duplicate keys. A clean result means the text is structurally valid. It does not confirm that the cited work exists or that its authors, title, year, and identifier are correct.

For project-wide key cleanup, safe duplicate handling, and citation updates, use References & citations.