ods2sql

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

Note: to simplify things, all data from spreadsheet is treated as TEXT Sqlite type.

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] to install it:

bash cargo install ods2sql

If your distribution has been updated in recent years, it is very likely that [Cargo] is already available. However if that's not the case, you can use [Nix] package manager to get some newer stuff. Or just install [Cargo] without using package manager. Whatever floats your boat.

Updating

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

bash cargo install --force ods2sql

License

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