Report extraction to Excel

When an administrator – with access to the report generator under Administrative tools – draws a report, certain values are “interpreted incorrectly” by Excel, for example some EKA codes. It cannot be corrected in the Digital Exam the risk of other errors.

Note: When Excel opens a .csv file, it uses the current default data format settings to interpret how to import each column of data. If you want more flexibility in converting columns to different data formats, you can use the Import Text Wizard.

However, there is a way around this, which Excel itself also indicates as a workaround. It is found on this page – here it is specified both for Office 2010-2016 and for newer versions (which are pasted below). The key is that the report should not be opened directly after download, but must be opened from within Excel by clicking on the Data and From Text tab and then the data must be defined as Delimited, that the semicolon is used as the delimiter and then the simplest thing is to mark all columns and click Finish

Import a text file by connecting to it
You can import data from a text file into an existing worksheet.

Click the cell where you want to put the data from the text file.

On the Data tab, in the Get External Data group, click From Text.

In the Import Data dialog box, locate and double-click the text file that you want to import, and click Import.

Follow the instructions in the Text Import Wizard. Click Help button image on any page of the Text Import Wizard for more information about using the wizard. When you are done with the steps in the wizard, click Finish to complete the import operation.

In the Import Data dialog box, do the following:

Under Where do you want to put the data?, do one of the following:

To return the data to the location that you selected, click Existing worksheet.

To return the data to the upper-left corner of a new worksheet, click New worksheet.

Optionally, click Properties to set refresh, formatting, and layout options for the imported data.

Click OK.

Excel puts the external data range in the location that you specify.