Write a Python Script to Modify and add Rows in a Spreadsheet

I have a folder with a lot of zip or binary files, the zip files contain the binary files. I want to look at each binary file wether in a zip or not and CRC32 the entire binary file. Using that CRC32 as a lookup in one of the spreadsheet fields I want to extract other information from the file. File Size, partial area checksum, end of data and fill in the information in the missing columns. Creating new rows if a row does not exist.