Import asset sheet column data

You can enter column data into manual-entry columns by importing a CSV sheet. Columns are limited to those of numeric data elements on the asset form.

First, export the CSV structure, enter the data into the CSV file, and then re-import the CSV file.

To export a manual-entry column

  1. Open the asset sheet.
  2. Click Export > Column Data.
  3. Save the CSV file to your local drive.

To enter column data

  1. Open the CSV file.
  2. Enter column data for each listed asset. Be careful not to change the CSV file structure.
  3. Save the CSV file.

To import column data

  1. Open the asset sheet.
  2. Click Import > Column Data.
  3. Browse to the CSV file containing the column data and click OK.

Last Published Monday, August 28, 2023