Convert ODS to SQLITE

Turn ODS spreadsheets into SQLITE. A SQLite database with one table per worksheet, named after it, hidden ones included; chart sheets and empty sheets are skipped.

Converted in an isolated sandbox on our serversDeleted after 24 hours

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

A database from your spreadsheet.Each worksheet in the ODS file becomes a table in one SQLite file.

  1. What you get

    A single SQLite database with one table per worksheet. Each table is named after its worksheet. Hidden worksheets are included.

    The first row of each worksheet gives the column names. The column types come from the values below it. Cells that hold formulas give their last computed values.

  2. What is skipped

    Chart sheets are not turned into tables. Empty worksheets are skipped too, so they do not appear in the database.

  3. Converting one worksheet

    Every worksheet is converted when you leave out the Sheet option. Set Sheet to a worksheet name, or to its number counting from 1, to convert only that one.

    To go the other way, use SQLITE to ODS.

ODS and SQLITE.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 · ODS

OpenDocument Spreadsheet

OpenDocument spreadsheet, the native format of LibreOffice Calc.

Extensions
.ods
MIME type
application/vnd.oasis.opendocument.spreadsheet
Kind
Documents
To · 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

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

terminal
$ cv convert sheet.ods sheet.sqlite
$ cv convert sheet.ods sheet.sqlite

Questions.What people ask about ODS to SQLITE.

01OF 04

Yes. Each worksheet becomes one table, named after the worksheet. Chart sheets and empty sheets are skipped.

From the first row of the worksheet. The column types are taken from the values in the cells.

Yes. Hidden worksheets become tables like the others.

The table holds the last computed value of each formula, not the formula itself.

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