For zip-files:
find <path_of_your_zips> -type f -name "*.zip" -exec unzip {} -d <out> \;
https://askubuntu.com/questions/620571/how-do-i-gunzip-all-files-recursively-in-a-target-directory
You can open the LibreOffice window completely by pressing the CTRL+Shift+J keys together.