< back

BalanceAAP > Data > Export Data

KEY TOPICS:

  • Include or Exclude Data for Export
  • Export Compensation Data

Export Data for Use Outside the System

Available from Data > Advanced, Export Data allows Reference and Data Tables to be selected and exported into Excel or text formats.

Select Export Options

Select the file type to export to from the drop down list: Excel 2007, Excel 97-2003, or as a text file.

(Optional) Limit the data to codes in use by checking the box next to the tagline: Only include used codes (for Department Codes, Grade, Job Group, and Job Code tables).

Select Tables for Export

If a Data or Reference table already has a customized setting, a [Custom view ON] icon will be displayed to right of the table name.

Check off one or more tables you wish to export, and click [Export].

Note: Multiple tables will export as individual sheets in an Excel file, or as multiple text files, depending on the file type selected above.

Export Data

Depending on the number of files and the amount of data, the Export Data process may take some time to complete. You may choose [Run in Background]. A Notification panel at the top of the page will provide a message when the process is complete (or click the Notifications icon in the header bar later).

Use the [Download] to save the exported file to your computer or network.

Quick Tip: The Notifications list stores recent data exports. To save time, use the notification icon Notifications icon instead of the [Export] button.