Exporting grid data

You can export grid value to use it elsewhere in the product.

About this task

You can export grid data in comma-separated value (.csv) format. Note the following criteria.

  • All pages (if the data is paginated) are exported.
  • All rows except the Summary row are exported.
  • All columns (including hidden columns) are exported.
  • Exported rows are in the same order as in the current view. If you are viewing the grid alphabetized by ID, the exported data is also alphabetized by ID.

Procedure

  1. Go to the grid to export.
  2. Click the Export icon (Up arrow out of bin image (small)).
  3. In the File Download dialog box, choose one of the following.
    • Click Open to display the file in Microsoft Excel.
    • Click Save to save the file to disk.
    • Click Cancel to close the dialog box without exporting the data.