Exporting tables to CSV files

Many EAC view panes include an Export button so you can define a filtered and sorted table and export it to a comma-separated values (CSV) file (also called a comma-delimited plain-text file). Using a CSV file, support, finance, third parties, or product management can pull the selected data into their tools of choice to build reports, billing invoices, or adoption models.

To export a CSV file:

  1. Click Export in the view pane.

    The Export dialog appears.

  2. In the Columns dropdown menu, select either:

    • All. This creates a CSV that includes all columns in your table.

    • Selected. This opens a new dropdown menu that allows you to select individual columns to include in the CSV file, while excluding others.

  3. If you selected Selected, then from the new dropdown menu that appears, select the checkboxes next to the columns you want to include in the CSV file. Leave checkboxes cleared next to the columns you want to exclude from your CSV file. You can search to display only those columns whose name matches the characters you type.

  4. In the Sort dropdown menu, select either:

    • None. This creates a CSV with your current column selections, sorted in the order they appear currently listed.

    • <a column name>. This creates a CSV with your current column selections, sorted in either ascending or descending order (selected next) by the results in the column selected. You can search to show only those columns whose name matches the characters you type.

  5. If you selected one of the column names, then from the Direction dropdown menu, select either Ascending or Descending.

  6. Select the Current page only checkbox if you want to export your selected options as they appear only on the first page of the table. Selecting this checkbox forces the Sort dropdown menu to None.

    or

    Clear the Current page only checkbox if you want to export all items for your selected options in the table, including items on all pages.

  7. Click Request.

    The EAC queues the creation of the CSV file. The file name uses the format <view name>-<times tamp>.csv...

    ...where <view name> is the name of the view from which you exported the file and where <time stamp> is the time stamp, in Unix seconds, when the file was created by the EAC.

  8. Navigate to the Exports page by clicking Exports in the navigation menu.

    The Exports page displays all the exports you have requested. Exports are user specific. The Exports page is available to all utility roles.

  9. When export's status is Completed, click the name to download the file to your computer (at your browser's default location).