For parsing logs: Apache::ParseLog may work for you, or you may have to write something from scratch. That's not too onerous.

For writing data into an Excel Spreadsheet: Spreadsheet::WriteExcel.

Next time, I strongly recommend you show us how far you got, and which approaches you tried. To wax poetic for a moment, we're happy to help push you out of a ditch, but we're not going to teach you how to drive.