You can export supported collection properties, such as lists, sets, and maps, in either of the following formats:

For instructions, see Exporting Asset Data.

Items in map collections contain key/value pairs that map one thing to another. To represent these items, the key and the value are separated by an equals sign, for example, Alabama=AL,Alaska=AK.

Flat Format

In flat format, each row of the spreadsheet represents a single asset with all of its exported properties. This format allows you to export multiple properties for each asset. Individual values in a collection are separated by a comma, for example, blue,green,red, or a comma and a space if they are repository items, for example, cat110006, cat11008, cat11009.

The following table shows how the childSKUs collection property appears in flat format:

Note: If collection items contain only numbers, or contain a comma in a value, the items are enclosed in double quotation marks, for example, "123","124". This prevents Microsoft Excel from interpreting the list of numbers as a single number. If a value contains a comma, the double quotation mark indicates that the comma does not begin a new item. For example, a keyword collection could be exported as: winter accessories,"hats, scarves, and gloves",knitted gifts. The quotation marks are removed if you re-import the spreadsheet.

Itemized Format

In itemized format, collection items are separated into individual rows, so one asset might span several rows in the spreadsheet. If you choose to itemize a collection property, you can only select that one property for export.

The following table shows the products from the previous example with the childSKUs property in itemized format: