1. On the navigation bar, click Export
  2. Select File, New Export from the menu bar or click New Export in the action bar
    For example: Client, Vendor, Student, or Applicant
  3. Select the export format
    For example: Excel 5-7 (XLS), Comma-Separated Values, or Blackbaud Report Writer Database (MDB)
  4. Click Create Now
  5. On the Filters tab, click Include to select a query, if appropriate. Mark the Create Control Report checkbox.
  6. Select the Output tab and select the fields to export
  7. Click Export Now
  8. Browse to the file location and enter a file name
  9. Click Save

Note: Export is not designed as a reporting module, it is only designed to group records. Depending on the filters and criteria selected in the export, the output may contain duplicates.

Helpful Hints:

  • Preview Your Exports - Before exporting data, click the preview toolbar button or select File, Preview Export File Layout from the menu bar to quickly ensure you're exporting the correct information, saving time you might otherwise spend troubleshooting.
  • Export Locally - Rather than exporting directly to a network drive or a disk, export to your local hard drive (usually C:\) instead. By doing so, you'll avoid having to re-export the file if you lose your network connection or if the file won't fit on a disk. Once the export completes, move the file to its final destination.
  • Print the Control Report - The Control Report includes useful information such as the name and location of the export file, the exported data fields, and the number of records included, so make sure you always print a copy.
  • Query Output Fields Do Not Transfer - When using a query for your export, the query's sort order applies to the export but the output fields do not. You have to select output fields in Export even if you selected them previously in Query.