Exporting report data to excel

Our organization has an extensive list of reports in SAP BO. I am trying to create a report catalog. In many cases I am having to cut and paste or type the needed information into an Excel spreadsheet. Only a minimal amount of data can be exported. Are there any tools you provide or can you direct me as to where I may find guidance on how to make this effort (extracting info from reports to an excel catalog) more efficient? Thank you.