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.
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.
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.
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.
- 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
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
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.
$ cv convert report.ots report/ --to tsv$ cv convert report.ots report/ --to tsvQuestions.What people ask about OTS to TSV.
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.