Using the "data basket" function, you can display a list (in tabular format) of all the indicators that you have selected.You can access the indicator itself by clicking on the relevant indicator key.You can use the "arrow up" and "arrow down" buttons to rearrange the sorting order of the list. You can remove indicators from the list by ticking the relevant checkboxes and then clicking "Remove selected items".
By selecting a download option , you will be redirected to a page where you can define the criteria for the file that you wish to download.
Depending on the selected format, this page shows the options for a matrix or snapshot download.
The standard file format is CSV and the standard language is the language of the page. Please note that the language you select determines whether your Excel program displays the file correctly after opening it.
You can choose between English CSV (entries are separated by commas, a period is used as the decimal separator) or Excel, or German CSV (entries are separated by semicolons, a comma is used as the decimal separator) or Excel.
In the "Reporting periods" (rows) section, you can set a limit on the period for which the indicators are to be displayed (entry format: yyyy-mm).These will then appear as rows in the resulting CSV or Excel file. The default setting is the entire period available.
The "Adjust limits" option can be selected only if a period was selected beforehand.
CSV is a text-based format which can be read by conventional spreadsheet programs such as Excel. In CSV format, there is one download file for each sheet.
In Excel format, the sheets belonging to a download are made available in an Excel workbook.
Download in matrix format
All the desired vintages of an indicator are listed next to each other in ascending order, thereby forming a matrix.Each of these vintages is generated as a new worksheet in the download file.
The worksheet name of the Excel file and the name of the CSV file correspond to the key of the entered indicator. The column heading corresponds to the publication date of a vintage and is displayed in the format yyyy-mm-dd. The row heading corresponds to the observation period and has the format yyyy-mm or yyyy-mm-dd. In the case of a vintage, the attributes are issued at first, followed by the values.
Download in snapshot format
For each indicator of the export list, the vintage that was available at the given date is selected. These are issued next to each other on a worksheet. There is one sheet for each snapshot time that was specified in the download options.
The worksheet name of the Excel file and the name of the CSV file correspond to the given snapshot date and has the format yyyy-mm-dd.
The complete key appears as the column heading. The row description corresponds to the observation period and has the format yyyy-mm or yyyy-mm-dd.
For each vintage, the attribute are issued first, followed by the values.
In the snapshot format, it may be the case that that different frequencies are written next to each other on a single worksheet. If so, the vintages share the date column and are always given in the format yyyy-mm. The date column is geared to the lowest available frequency.
In an Excel file, all the sheets belonging to the download are made available in a workbook.There is one tabular sheet for each frequency.
In CSV format, an individual CSV file is issued for each frequency.