Export Standard or Crystal Reports from Sage 100 to Excel

Instead of attempting to analyze data from Sage 100 using printouts of standard or Crystal reports, here’s an easier solution! Export it into Excel, where you can electronically sort and filter the fields.

Migration-banner - Micro Accounting

How to Export Standard or Crystal Reports from Sage 100 to Excel

We’ll start with the General Ledger Detail Report, with the Report Setting as “Standard” (Image 1).

ExportingCrystalExcel_Image01

Image 1

To export this report into Excel, first set the parameters.

Check the box next to “Print Condensed.”

Change the printer on the bottom left to “Export.” Another printer option is “Data Only Export.” This choice, however, will exclude the report headers in the Excel file that you create.

Click “Print.” This will bring you to the “Export” window (Image 2).

ExportingCrystalExcel_Image02

Image 2

Select Format: From the drop-down menu, choose the version of Excel you wish to use.

Select Destination: From the drop-down menu, select “Application” so you can open the report directly in Excel.
Click “OK.

You will now see the “Excel Format Options” window (Image 3).

ExportingCrystalExcel_Image03

Image 3

Select: “Column width based on objects in the:
From the drop-down menu, select: “Details

Click “OK.

Your report is now exported into Excel.

Read more great ways to use Excel with Sage 100:

Export Grids from Sage 100 to Excel

How to Export Budgets from Excel to Sage 100


To learn more about how to use Sage 100 for your business or to discuss upgrade options, please contact a MicroAccounting representative. We look forward to talking with you.