Exporting data from Base
You copy a table from Base to a new Calc sheet, then you can save or export the data to any file format that Calc supports.
-
Open the database file that contains the database table to be exported. Click Tables to view the tables, or click Queries to view the queries.
-
Choose File - New - Spreadsheet.
-
In the Base window, right-click the name of the table to export. Choose Copy from the context menu.
-
Click cell A1 in the new Calc window, then choose Edit - Paste.
Now you can save or export the data to many file types.
https://help.libreoffice.org/6.2/en-US/text/shared/guide/data_im_export.html