Convert GNUMERIC to TSV
Turn GNUMERIC documents into TSV files. One TSV per worksheet, hidden ones included.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop GNUMERIC files on the dialor turn it to pick what to do
One TSV for each worksheet in the workbook.Hidden sheets are included. Values come out as plain text.
What you get
Each worksheet in the Gnumeric workbook becomes its own TSV file, so a workbook with several sheets gives you several files. Hidden worksheets are converted too.
Formulas are written as the values Gnumeric computes, not as the formulas. Dates are written as YYYY-MM-DD, and numbers are written without their display format.
Quoting in cells
A cell that holds a tab, a quote or a line break is quoted. This keeps the cell in one field, so the columns of the row stay where they belong.
Converting 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 join the resulting files afterwards, you can merge TSV.
GNUMERIC 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
Gnumeric Workbook
Workbooks saved by Gnumeric, the GNOME spreadsheet, as gzipped XML.
- Extensions
- .gnumeric
- MIME type
- application
/x -gnumeric - 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 GNUMERIC to TSV conversion through the API, for your app or your agent.
$ cv convert report.gnumeric report/ --to tsv$ cv convert report.gnumeric report/ --to tsvQuestions.What people ask about GNUMERIC to TSV.
One TSV per worksheet, so a workbook with more than one sheet gives more than one file. Set Sheet to get only one.
Yes. Hidden worksheets are included along with the visible ones.
You get the values Gnumeric computes. The formulas themselves are not written.
As YYYY-MM-DD. Numbers are written without their display format.