If you have permission, you can export data about assets in the Acquia DAM in order to get a full picture of how those assets are being used. Exports can be in CSV, PDF, TXT, or XLSX formats, depending on the type of export, and can include up to 1.5 million rows of information about assets. When exports are under 10,000 rows, they'll be sorted by the date assets were added. A sort won't be applied when exports are over 10,000 rows.

Data within exports can be used as a guide for future creation of assets or shared with leadership.

Create exports from:

• The Admin app for orders, uploads, and users
• Advanced searches
• Insights app report
• Order pickup pages
• Quick Insights and asset insights
• Search results

If you have permission, you can export data about assets in the Acquia DAM in order to get a full picture of how those assets are being used. Exports can be in CSV, PDF, TXT, or XLSX formats, depending on the type of export, and can include up to 1.5 million rows of information about assets. When exports are under 10,000 rows, they'll be sorted by the date assets were added. A sort won't be applied when exports are over 10,000 rows.

Data within exports can be used as a guide for future creation of assets or shared with leadership.

Create exports from:

• The Admin app for orders, uploads, and users
• Advanced searches
• Insights app report
• Order pickup pages
• Quick Insights and asset insights
• Search results

After exports process, you'll be directed to the Exports page to download the export and open the file. Exports run in the background of your computer, and you can continue to work in the site until exports are ready for download.

Exports are available on the Exports page for up to two weeks from the date you create them. Access the Exports page from the Activity menu on the dashboard. The Exports listing will display in the menu only if you have exports to view and download.

Enable alerts or email notifications to receive notifications when the export is ready. To review and sort data, download the export by clicking its name or the download arrow, then open the file.

You must be logged in to the DAM to view exports. If you're not logged in, you'll be required to log in to view and export details.

Exporting a list of assets and URLs

If you need an inventory export that includes URLs, first determine which URL type you need:

• Asset download link (included in CSV exports)
• Share link (public URL once created, if the asset is released and not expired)
• Embed link or Embed code (for publishing assets in another system)

For CSV exports that include asset download links, see How do I export search results?

For definitions and examples, see What are share links, embed codes, and embed links?

For site domain options that affect Share link URLs, see What URL options are available for my Acquia DAM site?

For programmatic inventories, see How do I search for assets via the API?

Import CSV exports into Excel

When opening CSV files, you'll need to import the information into Excel in order to avoid seeing invalid characters in the document. To import:

1. Open a new Excel workbook.
2. Click the Data tab.
3. Click Text.
4. Select the downloaded CSV file.
5. Click Get Data.
6. In the Text Import Wizard:
   1. For the original data type, select Delimited.
   2. For the file origin, select Unicode UTF-8. If there are multiple versions of Unicode UTF-8, select the highest version number.
   3. On the next page for delimiters, check Comma and uncheck Tab.
7. Click Finish.
8. In the Import Data box, click OK.