Skip to main content

Export to CSV or Excel

Your assets and links can be exported to Excel or CSV files using the export functionality in the Repository or a Table Report.

  • Use Excel / .xlsx export for using the data with a spreadsheet application like LibreOffice Calc or Microsoft Excel.
  • Use CSV to import / use the data in any application that can handle CSV.

Note that the Excel export has the additional advantage of exporting links and assets at the same time. This is not possible in CSV due to limitations in the file format. However, it is possible to export the links also to CSV in a second export step.

Excel / .xlsx - Spreadsheet​

An exported *.xlsx file contains both the assets and the links of these assets. The link table contains all the links of the exported assets. They are referenced via the "source Asset id" and "target Asset Id" column. These values can be matched with the values of the column "TxtureId" in the assets table.

CSV​

CSV (comma separated values) is a very basic interchange format for tabular data. The export dialog allows to choose between link and asset exports as well as exports of comments.

The generated *.csv files can be viewed with the help of all major spreadsheet applications like Microsoft Excel or LibreOffice Calc. The format of the *.csv file should be automatically detected by the specific tool - otherwise, ; (semicolon) is the column separator and " (double quotes) for text. The text content is encoded in UTF-8.

In the exported *.csv file, the first line contains the text sep=; which is a format descriptor for MS Excel and can be deleted/ignored when working with Calc or any other program.

CSV encoding​

Please note that CSV by default has no meta information embedded regarding its content encoding.

If you experience encoding issues e.g. with German Umlaute (ä,ö,ü) in Microsoft Excel, you need to start Excel with a blank workbook open. After that select the Data tab in the ribbon menu and choose From Text. This way you can select a proper content encoding like UTF-8.

Alternatively just (re)export your data as an the Excel/*.xlsx file.