Exporting SBM Data to Microsoft Excel®

You can use reports to export SBM primary and auxiliary item data.

There are two methods of getting SBM data into Excel:

Using the Excel Link – This method enables you to quickly export static data into Excel. You can export listing-type, tabular-formatted, and graphical reports and most search results. When you export SBM graphical reports to Excel, report data is exported into a spreadsheet. For details, refer to Using the Excel Link.
Using Microsoft Excel's Web Query Feature – This method enables you to manually import "dynamic" data into Excel. If you use a Web query in Excel, data in your spreadsheet is updated each time that you open it. For details, refer to the Knowledgebase at serena.com.