How to Bulk Update Your Assets
The Asset Importer allows you to update existing assets in bulk by uploading a spreadsheet. You’ll map your columns to system fields, make any needed corrections, and confirm your updates before importing. This article walks you through each step to successfully bulk update your assets.
In order to bulk update your assets you will need to Export the assets you wish to update, Update the desired fields in your spreadsheet, Save the file, and then Import the updated file to AMFJ.
For instructions on how to Export your assets check out How to Export Your Assets.
The article below explains how to import your updated assets step by step.
Step-by-Step Guide
1. Start the Import
- From the main Asset page, click the Import button to open the Asset Importer tool.
2. Upload Your File
- Click Upload File and select your spreadsheet.
3. Select Import Type
- Choose Update Existing Assets as your import option.
Select your ID column for asset matching.
4. Map Your Columns
- Match each spreadsheet column to a system field.
- You can create new fields during this step if needed by clicking + Create New Field.
- Supported field types include dropdown, text, number, and date.
5. Verify Your Data
- Review any invalid data, if applicable.
Edit data directly in this screen to fix issues.
Red highlights may remain until you click into another cell or toggle “Show Invalid Data" box.
6. Import Your Updates
- Click the Import button to import your file.
- Your assets will be updated based on your spreadsheet.
Once the import finishes, you'll see a confirmation message acknowledging how many assets were updated.
For details on how to import new assets please go to this article here