Note: The following applies exclusively to downloads within the "Payouts" category.
After a data export has been successfully initiated, a CSV file will be found in the 'Downloads' folder on the local PC for a moment. At the same time, a completed download in the browser should appear as follows:
Bearbeitung in Microsoft Excel:
Steps:
- Open of Microsoft Excel
- Choose an empty/new spreadsheet
- Choose, as shown in the picture, the library "Data"
- First, click on the arrow pointing downwards, and then on the 'From Text (Legacy)' field
- In the pop-up menu, select the Downloads folder and then choose the file you just downloaded. Click on 'Import Data'
- Following that, the following field should appear. For correct import, set the values to 'Delimited' and click 'Next'
- The second-to-last step involves specifying the correct delimiter, which in our case is a comma (,). Select this field accordingly and click 'Next'
-
In the final step, it is particularly important to pay attention to the formatting of the decimal places. To ensure this, click on the "Advanced" field and change the decimal separator from a comma (",") to a period ("."). Finally, go back and complete the data import by clicking "Finish"
- Now, finally, specify the desired location to import the data into your blank worksheet. To import the data to the top-left, type '=$A$1' into the placeholder
- The data should now have been inserted into the Excel sheet, separated by property as desired