Skip to content

CSV Data Export#

You can export data directly from the IT documentation in CSV format and process it further in a spreadsheet application. Three methods are available.

Exporting Object Lists#

Open the object list and click the CSV button in the action bar. The exported columns correspond to the configured attributes of the list view.

If you have set a filter, you only export the filtered results.

CSV export in action bar

Exporting Category Lists#

The CSV export supports many category lists (multi-value). Click the CSV button within a category list to download all entries and attributes.

The attribute names serve as column headers. i-doit exports multi-value data comma-separated.

Multi-value category

Exporting Reports#

The Report Manager also offers CSV export. Open a report and click CSV.

Report display

CSV Format#

The exported file is a simple text file. Per line, the values are separated by a semicolon. The encoding is Unicode (UTF-8).

Microsoft Excel

Excel sometimes does not display CSV files correctly -- especially umlauts and special characters are lost. Therefore, do not open the file directly but import it:

  1. Export and save the CSV file
  2. Open Excel
  3. Click From Text in the Data tab
  4. Open the CSV file
  5. In the Text Import Wizard dialog, set the File origin to 65001 : Unicode (UTF-8)
  6. Click Next
  7. Select the Semicolon checkbox as the Delimiter
  8. Click Finish