Using spreadsheet as the database table

[Roman001]

Hello. While reading about working with databases I can’t find one usefull for me information. How can I use a Calc spreadsheet as a db table and use SQL queries above it? I would use such ability in Excel

[sokol92]

The most useful thing to do is to do your own research.
Menu / File / New / Database.
Connect to an existing database: Spreadsheet.
…

[Villeroy]

Pass Entire sheet to a formula, is this possible?

And while we are in it, Base can represent Calc “tables”, so they can be queried by plain, simple SQL. A rectangle of Calc cells qualifies as a pseudo-table if the table is a normalized one that qualifies for a pivot table according to Database normalization description - Microsoft 365 Apps | Microsoft Learn the table represents some sheet’s one and only content if there is other content on the same sheet, you can isolate the table as a database range (menu:Data>Define…) After connecting a B…

[Regina]

If you will use SQL queries, then you need an odb-file, generated from the spreadsheet. See the “Base Guide” how to create one. Don’t mind that the guide is for LO 7.3. There had been no large changes to the Base module. English documentation II | LibreOffice Documentation - LibreOffice User Guides


Are you sure you need SQL? Otherwise the database ranges in Calc might be sufficient. LibreOffice has in the meantime not only the Sort and Filter features from the Data menu, but a lot of new functions for queries and sorting.

[Roman001]

@Regina

queries, then y

I prefer SQL), it is universal and familiar, there are lot of languages and formats but SQL is one). Thanks a lot