ods2sql

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

Details:

• to simplify things, all data from spreadsheet is treated as TEXT SQLite type.
• cells in the first row are used for SQLite column names
• 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.

Caution!

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

Patches for bugs are welcome.

Usage

To create spreadsheet.sqlite out of spreadsheet.ods:

bash ods2sql spreadsheet.ods

Install

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

Updating

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

bash cargo install --force ods2sql

License

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