Excel usable reports

[ohms_law]

Is there any way that outputting the various reports into an excel friendly format (CSV seems easiest) would be possible?

Thanks.

Sent from my keyboard using my fingers.

[21C]

There is an option to output data to csv format.
Out of the Park Baseball Manual

You can also open most game reports in an external browser and then copy & paste the information into Excel.

[RchW]

Originally Posted by 21C

There is an option to output data to csv format.
Out of the Park Baseball Manual

You can also open most game reports in an external browser and then copy & paste the information into Excel.

You can open any csv file in excel. No need to copy/paste.

[21C]

I was talking about the html pages.

[1998 Yankees]

Originally Posted by ohms_law

Is there any way that outputting the various reports into an excel friendly format (CSV seems easiest) would be possible?

Thanks.

Sent from my keyboard using my fingers.

I think, in addition to what the guys were talking about above, export/import rosters and stats, that you are talking about the various reports that you see in the game itself. Well, it takes some doing, but you can get those into Excel by using the "Open in External Browser" button wherever it appears and then using your browser's "File, Save As" feature to save the page as html. Use the complete web page version instead of html only when saving.

Then, open the page in Excel. You may have to select Files of Type: "All Web Pages *htm, *html, etc." in order to see the saved page to be opened. Then, you will have some formatting work to do (for example, the font may be white against a white background, but the numbers are there, just camouflaged) but the good news is that you do have labels and numbers arranged as a spreadsheet, ready for manipulating, analysis, and review.

By the way, thanks for this: "Sent from my keyboard using my fingers." I really am tired of seeing this or that message was sent by somebody's Blackberry (oh, sorry, that model's already obsolete, isn't it?) or some other smart phone. Who cares? Long live the computer and keyboard.

[statfreak]

Originally Posted by 1998 Yankees

I think, in addition to what the guys were talking about above, export/import rosters and stats, that you are talking about the various reports that you see in the game itself. Well, it takes some doing, but you can get those into Excel by using the "Open in External Browser" button wherever it appears and then using your browser's "File, Save As" feature to save the page as html. Use the complete web page version instead of html only when saving.

Then, open the page in Excel. You may have to select Files of Type: "All Web Pages *htm, *html, etc." in order to see the saved page to be opened. Then, you will have some formatting work to do (for example, the font may be white against a white background, but the numbers are there, just camouflaged) but the good news is that you do have labels and numbers arranged as a spreadsheet, ready for manipulating, analysis, and review.

IMO, much easier to open the report in the external browser then just select, copy, and paste into Excel.

I use the below macro to just paste the "values" without any other formatting. Despite its name, numbers are pasted as numbers (does the same thing as Paste Special... paste as Text).

Sub pasteText()
     
        ActiveSheet.PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:=False
End Sub

[1998 Yankees]

Originally Posted by statfreak

IMO, much easier to open the report in the external browser then just select, copy, and paste into Excel.

I use the below macro to just paste the "values" without any other formatting. Despite its name, numbers are pasted as numbers (does the same thing as Paste Special... paste as Text).

Sub pasteText()
     
        ActiveSheet.PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:=False
End Sub

Yes! Absolutely correct, thanks. Ohms Law, just make sure to select only the data and column headings in the web page before copying. And I don't think you need the macro, just select Paste, Paste Special, Text in Excel:

[RchW]

This would be great but the HTML reports don't contain all the stats I need. Thanks for the tip but I'll have to keep using the csv files.

Boy I'm whiney today.

[ohms_law]

Thanks for the tips, I'm sure some people reading this will be happy to learn about them (I already knew how to do all that and more, but feel free to keep posting how too's. Plenty of people will see this thread for months to come.)

Anyway, yea, 1998 Yankees is correct: I was talking about the in game reports that are only exportable (apparently) through the use of HTML... er, reports.
Maybe I'm missing something, but as far as I can tell the reports that are exportable through the import/export functions don't include the same information that the in game reports do (especially the roster screens, with all of the individual ratings).