Query like SQL on office calc

Hi :),

Is it possible to query tables of a spreadsheet using SQL?

I saw a similar question but for me it wasn’t clear enough.

Thanks in advance


There is no SQL in Calc. This is available when using a database. In LibreOffice this is through use of Base and can be accessed in Calc when the Base file is registered. The “similar” question you mentioned is probable not so similar. That question was dealing with extracting specifics from a csv file. Calc did not seem to be a requirement but rather how the csv file was originally opened.

It also seems you question is not exactly clear. Main question states Query like SQL and detail states using SQL. So there seems to be the possibility of something other than SQL would solve your question but there is nothing stated as to what you are trying to accomplish.