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.

  1. 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.

  2. 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.

  3. 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.

  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 · GNUMERIC

Gnumeric Workbook

Workbooks saved by Gnumeric, the GNOME spreadsheet, as gzipped XML.

Extensions
.gnumeric
MIME type
application/x-gnumeric
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 GNUMERIC to TSV conversion through the API, for your app or your agent.

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

Questions.What people ask about GNUMERIC to TSV.

01OF 04

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.

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