Convert CSV to ODS

Turn CSV files into ODS. One sheet named after the file, cut to 31 characters.

Converted in an isolated sandbox on our serversDeleted after 24 hours

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

A CSV table as an ODS spreadsheet.Your rows land on one sheet in a file LibreOffice Calc opens as its own.

  1. What you get

    One ODS file with one sheet. The sheet is named after your file and cut to 31 characters if the name is longer.

    ODS is the native format of LibreOffice Calc, so the table opens there as a normal spreadsheet.

  2. Header and delimiter

    Turn on Header row when the first row holds column names. That row stays text. Header row is off by default, so the first row is otherwise treated as data.

    Set Delimiter to the character between fields: comma, semicolon, tab or pipe. If you leave it out, the delimiter is guessed from the rows. Spreadsheets in many European locales use semicolons, so pick Delimiter there if the guess is wrong.

  3. Going back

    To turn a spreadsheet into a CSV again, use ODS to CSV. For other CSV conversions, see every CSV conversion.

CSV and ODS.What each format is, and the options this conversion takes.

  1. 01 · delimiter

    Delimiter

    The character between fields. It is guessed from the rows when left out. Spreadsheets in many European locales use semicolons.

    • comma A comma.
    • semicolon A semicolon.
    • tab A tab.
    • pipe A vertical bar.
    comma · semicolon · tab · pipe
  2. 02 · header

    Header row

    Whether the first row holds the column names rather than data.

    default false

The formats

From · CSV

CSV

Rows of comma-separated values. The plainest way to move a table between programs.

Extensions
.csv
MIME type
text/csv
Kind
Text and data
To · ODS

OpenDocument Spreadsheet

OpenDocument spreadsheet, the native format of LibreOffice Calc.

Extensions
.ods
MIME type
application/vnd.oasis.opendocument.spreadsheet
Kind
Documents

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

terminal
$ cv convert sheet.csv sheet.ods
$ cv convert sheet.csv sheet.ods

Questions.What people ask about CSV to ODS.

01OF 04

It takes the name of your file. Names longer than 31 characters are cut to 31.

Yes, when you turn on Header row. The first row then stays text.

Yes. Set Delimiter to semicolon, or leave it out and the delimiter is guessed from the rows.

One file, with one sheet in it.

More conversions.Other ways in and out of CSV and ODS.