You should have a look at ?connections where you have a gzfile connection to read such file and extract the content.
The
R.utils has a nice wrapper function called gunzip to help decompress some *.gz file.
Once you have extracted to excel, you can manipulate the file (with openxlsx or readxl).
Then you can recompress it if you want (using R.utils::gzip)