in reply to Excel - usable format

I'm looking for a good method for translating an excel database in this format: ...

If this is a one-shot conversion, you can manually save each sheet as a CSV (comma-separated value) file, then process them either directly or via File::CSV.

If this is something you'll be doing frequently, consult OLE - Getting all rows from Excel for some example code that'll get you 95% of the way there.