Share

Export table data as CSV

You can export data from any table in Flow Production Tracking as Comma-separated Values (CSV). You copy the values from a table using the contextual menu, and then can paste these values to a text file or a spreadsheet.

  • Copy Selected <Column> Values (CSV) copies the values of the selected rows from the column you right-click.
  • Copy Selected Rows Values (CSV) copies the values for all columns on the selected rows.
  • Advanced Copy (CSV)… opens up a dialog box with more options about what to copy.

All these options generate text in the format of comma- and newline-separated values and adds that text to the copy clipboard.

The copy actions wont export the id or project fields unless explicitly shown and selected.

The two Copy Selected.. options don't export the column names. If you need to export the column name, use Advanced Copy (CSV)….

Copy values from a column

  1. In a table, select the rows that contain the data to export.

  2. Right-click the column that contains the data, and select Copy Selected <Column> Values (CSV).

    The column's data is copied to the clipboard, as comma-separated values. If you paste it to an application like Microsoft Excel, you can usually have it formatted on import.

Copy values from rows

  1. In a table, select the rows that contain the data to export.

  2. Right-click the selection, and select Copy Selected Rows Values (CSV).

    The column's data is copied to the clipboard, as comma-separated values. If you paste it to an application like Microsoft Excel, you can usually have it formatted on import.

Select the data to copy

  1. In a table, select the rows that contain the data to export.

  2. Right-click the selection, and select Advanced Copy (CSV)….

  3. In the Advanced Copy dialog box, you select the data to copy.

    • Selection Type: Pick between using the selected rows, or using all rows (including the rows not shown on the page).

    • Include Column Headers: Include the column names as a header row on the data.

    • Columns: Select the columns to export. You can only select the columns currently shown on the page. If you don’t see the column you want to copy, make sure it is showing on the page first.

    The column's data is copied to the clipboard, as comma-separated values. If you paste it to an application like Microsoft Excel, you can usually have it formatted on import.

Was this information helpful?