Convert OTS to TSV

Turn OTS documents into TSV files. One TSV per worksheet, hidden ones included.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop OTS files on the dialor turn it to pick what to do

Each worksheet as its own TSV.Cell values come out as plain text, one file per worksheet.

  1. What you get

    One TSV file for each worksheet in the OTS template. Hidden worksheets are included.

    Formulas give their last computed values. Dates are written as YYYY-MM-DD, and numbers are written without their display format.

    Cells that hold a tab, a quote or a line break are quoted.

  2. What is skipped

    Chart sheets and empty sheets produce no file. Only worksheets with content become TSV files.

    Because TSV is plain text, the display format of numbers is not kept. Only the values are written.

  3. Choosing one sheet

    Set Sheet to convert a single worksheet. Give its name, or its number counting from 1. When Sheet is left out, every worksheet is converted.

    To work with the results afterward, you can merge TSV files into one.

OTS and TSV.What each format is, and the options this conversion takes.

  1. 01 · sheet

    Sheet

    The one worksheet to convert, by its name or by its number counting from 1. Every worksheet is converted when it is left out.

The formats

From · OTS

OpenDocument Spreadsheet Template

A LibreOffice Calc template. New spreadsheets start from a copy of it.

Extensions
.ots
MIME type
application/vnd.oasis.opendocument.spreadsheet-template
Kind
Documents
To · TSV

Tab-Separated Values

Tab-separated values.

Extensions
.tsv .tab
MIME type
text/tab-separated-values
Kind
Text and data

In your code.The same OTS to TSV conversion through the API, for your app or your agent.

terminal
$ cv convert report.ots report/ --to tsv
$ cv convert report.ots report/ --to tsv

Questions.What people ask about OTS to TSV.

01OF 04

Yes. Hidden worksheets are converted like the others.

One TSV per worksheet. Chart sheets and empty sheets are skipped, so they add no file.

No. Each formula cell gives its last computed value, not the formula.

As YYYY-MM-DD. Numbers are written without their display format.

More conversions.Other ways in and out of OTS and TSV.