Using Metadata Import and Export in AEM Assets

AEM Assets metadata import and export capabilities allow content authors to easily move asset metadata in and out of AEM and leverage the power of Microsoft Excel to manipulate metadata at scale, facilitating the bulk update metadata for existing assets in AEM.

Metadata Export

Metadata Import

Download WeRetail sports folder

Download Asset metadata package

Metadata File Format

CSV File Format

First Row

• The first row of the CSV file defines the metadata schema.

• The First column defaults to assetPath, which holds the absolute JCR Path for an asset.

• Subsequent columns in the first-row point to other metadata properties of an asset.

  • For example : dc:title, dc:description, jcr:title

• Single Value Property format

  • <metadata property name> {{<property type}}
  • If property type is not specified it defaults to String.
  • For example: dc:title {{String}}

• Property Name is case sensitive

  • Correct : dc:title {{String}}
  • Incorrect: Dc:Title {{String}}

• Property Type is case insensitive

• All valid JCR Property types are supported

• Multi Value Property format - <metadata property name> {{<property type : MULTI }}

Second Row to N rows

• The first column holds the absolute JCR path for an asset. For example: /content/dam/asset1.jpg
• Metadata property for an asset could have missing values in the CSV file. Missing metadata property for that particular asset will not be updated.