Repository navigation
Thanks for this wonderful piece of software #1
Description
I was always wandering how to easily convert my libreoffice calc data sheets to a database. Thereby combine intiuation , ease and flexibility of spreadsheet and processing power of database .
Your script does a important step towards it.
Thanks a lot for sharing it.
I have used the script slightly differently on my linux mint machine.
In order to avoid all the mess with initiating virtual python environment and other dependency complications, I just copy pasted ods2sql.py file to /usr/bin/ and made it executable.
Thereby from any bash shell or script I could execute it universally simply by -->
#BASH
ods2sql.py "/path/to/file.ods" | sqlite3 "path/to/database.sqlite"
And it works like a charm.
Activity
[-]Thanks for this wonderful peice of software[/-][+]Thanks for this wonderful piece of software[/+]arturormk commentedon Jun 15, 2026
Thank you. I came up with this "it's obvious when you think about it" idea many years ago, while dealing with the SAE J1939 Standard spreadsheets. and had been using my "human slop" version ever since for anything where LibreOffice Calc is a good database UI but the data is too big to efficiently process row by row.
Last year I began exploring how to best develop 100% AI-written code and this was an obvious starter project: well understood, simple, and actually useful.
It sounds funny now, but one year ago people were still saying that AI could not be trusted to write code. My methodological principle of not allowing a single human-written line of code because it confuses AI sounded radical back then :).