Use the Export Tool in KB Tools to export data from SFX.
Explain what fields of data each export will provide.
Advanced doesn't export column headings, so include a spreadsheet with the column headings to use for pasting into your export files.
In either kind of export, you can export the following kinds of records, for All or Selected Target Services
There are other options as well, but I don't know what they do yet, so I'm not going to explain them here.
If your export contains more than 65,000 lines, you'll need to use Excel 2007 or greater. Earlier versions of Excel can't handle that many lines of data.
Your export will be a .txt file from SFX. The best way to see your data in Excel is to:
Keep in mind that Brio Query doesn't talk to Excel files greater than Excel 5.0. So if you have a .xlsx file, or even a .xls in Excel 2003, Brio will refuse to read your file. Save it down to Excel 5.0 (Microsoft Excel 5.0/95 Workbook (*.xls)), and Brio will be happy.
Put something in about using Pivot tables? How else is Brio useful in working with SFX exports?