Exporting data

To export rows of data to Microsoft Excel, follow these steps.

  1. Arrange the columns and filter the data grid to the desired layout.

    Note: Only data that is included in the grid will be exported.

  2. Right-click anywhere in the data grid and select Export Grid to Excel.

    Note: You can also select Export Selected Rows to Excel.

  3. In the Save As dialog box, identify the location and filename for the file.

  4. Click Save.
    A confirmation box is shown.

    The number of rows that were exported is included in the message.

    image1

  5. Click OK.
    In Excel, the data will be grouped as in Inventory Services.

    Data display in Inventory Services:

    image2

    Data display in Excel:

    image3