Learn more

About exporting to Microsoft Excel

Exporting report data to Microsoft Excel

Exporting Quick Grid data to Microsoft Excel

Exporting Find query data to Microsoft Excel

Exporting Data to Microsoft Excel

You may need to get data out of a Sage 100 Contractor report, Quick Report, Quick Grid, or Find query and into a Microsoft Excel spreadsheet so that you can add to or reorder the data or combine data from different reports into one document.

In some situations, a grid may be displaying too many columns to be viewed in the Print to screen viewer or to be printed, even in landscape orientation. It is just situations that exporting to Microsoft Excel provides a solution. Microsoft Excel has the capability to capture all the data on any grid in Sage 100 Contractor.

  • If you do not have access rights to any data included in the export action, you are notified and no export file is created.
  • If support for Microsoft Excel Object Library is not present on the machine that initiates the export action, you are notified and no further actions are performed.

The exported data includes the following information:

  • Company name
  • Report title (grid or query name)
  • Selection criteria
  • Column headers
  • Labels
  • Data
  • Formulas

  • User name
  • Report number (for example, 3-5-0-21)
  • Date and time

The exported data excludes the following information:

  • Graphics, lines, double lines, boxes
  • Pagination
  • Checks

  1. From a main window, for example 4-2 Payable Invoices, on the toolbar, click the Print Records button.

    The Report Printing window opens.

  2. Select a report that you want to export to Excel.
  3. Click the Send report data to Excel button.

Your computer starts Excel, which displays a new worksheet populated with the report data.

  1. Open a Quick Grid window.

  2. On the toolbar, click the Print Records button.

    The Report Printing window opens.

  3. Click the Send report data to Excel button.

Your computer starts Excel, which opens displaying new worksheet with the quick grid data.

  1. Open a window that supports Find queries.

    The Query List window opens.

  2. Select a query, and then click Run.

    The Run Query window opens.

  3. Enter criteria, and then click Run.

    Your computer displays a quick grid populated with the query data.

  4. On the toolbar, click the Print Records button.

    The Report Printing window opens.

  5. Click the Send report data to Excel button.

Your computer launches Excel with a new worksheet populated with the selected data.