Convert SQLITE to ODS

Turn SQLITE files into ODS files. One spreadsheet per table, named after it, with one sheet; views are skipped.

Converted in an isolated sandbox on our serversDeleted after 24 hours

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

One spreadsheet for each table.Each table in the database becomes its own ODS file, named after the table.

  1. What you get

    One ODS file per table, named after that table. Each file holds one sheet with the table's rows.

    Views are skipped, so only real tables produce files.

  2. How values are stored

    Numbers, dates and times become typed cells. A spreadsheet program can sort, sum and format them as numbers and dates instead of treating them as plain text.

    Codes with a leading zero stay text. A value such as a zip code keeps its zero at the front.

  3. When a table fails

    A table with text stored in a number column fails. The column promises numbers, so the text in it cannot become a typed cell.

    To go the other way, use ODS to SQLITE.

SQLITE and ODS.What each format is.

The formats

From · SQLITE

SQLite Database

A whole relational database in one file. Tables, indexes and views.

Extensions
.sqlite .sqlite3 .db
MIME type
application/vnd.sqlite3
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 SQLITE to ODS conversion through the API, for your app or your agent.

terminal
$ cv convert report.sqlite report/ --to ods
$ cv convert report.sqlite report/ --to ods

Questions.What people ask about SQLITE to ODS.

01OF 04

Yes. Each table becomes one ODS file named after it, with one sheet.

No. Views are skipped, and only tables produce files.

Yes. Codes with a leading zero stay text, so the zeros are kept.

A table fails when it has text stored in a number column. Numbers become typed cells, and the text cannot.

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