ÃÛ¶¹ÊÓƵ

DocumentationAEMAEM TutorialsAEM Assets Tutorials

Using Metadata Import and Export in AEM Assets metadata-import-and-export

Last update: Sun Mar 23 2025 00:00:00 GMT+0000 (Coordinated Universal Time)
  • Applies to:
  • Experience Manager 6.4
  • Experience Manager 6.5
  • Experience Manager as a Cloud Service

CREATED FOR:

  • Intermediate
  • Admin

Learn how to use the import and export metadata features of ÃÛ¶¹ÊÓƵ Experience Manager Assets. The import and export capabilities allow content authors to bulk update metadata for existing assets.

Metadata Export metadata-export

video poster

TIP
When opening metadata export CSV file in Excel, use the rather than double-clicking the file to avoid issues with UTF-8 encoded CSV files.
To open the metadata export CSV file in Excel, follow these steps:
  1. Open Microsoft Excel
  2. Select File > New to create an empty spreadsheet
  3. With the empty spreadsheet open, select File > Import
  4. Select Text file and click Import
  5. Select the exported CSV file from the file system and click Get Data
  6. On step 1 of the import wizard, select Delimited and set File origin to Unicode (UTF-8), and click Next
  7. On step 2, set the Delimiters to Comma, and click Next
  8. On step 3, leave the Column data format as is, and click Finish
  9. Select Import to add the data to spreadsheet

Metadata Import metadata-import

video poster

NOTE
When preparing a CSV file to import, it is easier to generate a CSV with the list of assets by using the Metadata Export feature. You can then modify the generated CSV file and import it using the Import feature.

Metadata CSV File Format metadata-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 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 properties for that particular asset are not updated.
recommendation-more-help
a483189e-e5e6-49b5-a6dd-9c16d9dc0519