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. Since that's what I've used in my spreadsheet.

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

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].