ods2sql

ods2sql creates [SQLite] database out of your ODS spreadsheet.

Details:

Cell values in the first row are used for SQLite column names.
To simplify things, all data from spreadsheet is treated as TEXT SQLite type.
- Boolean cell values (e.g. true/false) are converted to TEXT type and saved as true / false text.
Empty cells/errors are inserted as NULL SQLite value.
Maximum number of columns is limited by:
- [SQLITE_LIMIT_VARIABLE_NUMBER] to 999 parameters in INSERT statements.
- [SQLITE_MAX_COLUMN] to 2000 columns in a table.
- LibreOffice has a hardcoded [limit of 1024 columns].

Caution!

It works for me, and if it eats your data that's your problem. Read the [LICENSE].

Patches for bugs are welcome.

To create spreadsheet.sqlite out of spreadsheet.ods:

bash ods2sql spreadsheet.ods

The easiest way is to use [Cargo]:

bash cargo install ods2sql

Don't forget to add place where Cargo installs binaries to your PATH for convenience, e.g.:

bash echo 'export PATH="$PATH:$HOME/.cargo/bin"' >> ~/.bashrc source ~/.bashrc

In case of newer version, updating is almost like installing:

bash cargo install --force ods2sql

Licensed under AGPLv3+. For details, see [LICENSE].