ODS to TSV

Your files never leave your device.

Choose a format
Choose a format

Each sheet becomes its own TSV file. Cells are saved as your spreadsheet app displays them, so formulas become their results.

Questions about ODS to TSV

How does ODS to TSV work?

ODS to TSV writes each sheet of an OpenDocument spreadsheet to its own tab-separated file. Values are taken as displayed, so formulas become their results and formatted numbers and dates are written as shown. Styling is dropped, and commas in your data need no quoting.

Is formatting kept?

Colours, fonts, borders and column widths are dropped, since TSV is plain text. Number formats do shape the output, though: a cell showing 25% is written as 25%, not 0.25.

How are the files named?

After the original file and the sheet, like data-Sheet1.tsv and data-Sheet2.tsv. A spreadsheet with only one sheet gives a single data.tsv.

Can a value contain line breaks?

Yes. A cell with several lines is written inside double quotes with its line breaks kept, so a TSV reader that understands quotes reads it back as one value.