home

PDS

RealmRealm AccountingMinistryPlatformGivingPDSACSConnectShepherdGrowth MethodHeadMasterRefresh WebsitesTrust CenterGo MethodMissionInsite
RealmRealm AccountingMinistryPlatformGivingPDSACSConnectShepherdGrowth MethodHeadMasterRefresh WebsitesTrust CenterGo MethodMissionInsite

What would you like to know more about?

Show Contents

thumbnailPDS

Reports

Export to Excel or OpenOffice

You can export any report to an .xls file, which can then be opened in Excel or OpenOffice. This is most useful for a listing report, where the data will display in columns and rows. There are several ways of exporting, and it may vary based on the version of Excel or OpenOffice you're using. These steps provide the recommended way that produces the best looking file.
Tip: If you're seeing a lot of spacing between columns when you export, this should help!
  1. Open the report you want to export, and make your selections.
  2. Click Print Report.
  3. In the Print dialog box, select Print to File.
  4. For Type, select [Old] - Excel Document. (This will work for both Excel and OpenOffice.)
  5. Select Show advanced dialog.
  6. Click OK.
  7. In the Excel Export Setup dialog box, click the Formatting tab.
  8. For Column Spacing, select No Blank.

    Excel Export Setup dialog box showing the Formatting tab with the Column Spacing option set as No Blank

  9. Click OK.

Your report opens in your default program, either Excel or OpenOffice. You can adjust column widths as needed.

If you'd prefer a little more spacing, you can follow the same steps and select a different Column Spacing option, such as One Blank.

Here's an idea of what the file would look like with the Column Spacing set to No Blank.

Example of a listing report exported to OpenOffice with the specified settings

thumb_upYes thumb_downNo

Last updated: March 6, 2025

Related Articles: