Loading CSV files in Excel
To collect all the information in a way that can easily be matched with other excerpts and registers, the export format from Engage is in .csv. CSV is a fairly common format that is often used for exports from systems.
In short, all columns are "defined" with semicolon (;) in each row. The idea is exactly the same as Excel. Here are some examples:
The following in a CSV file:
is the equivalent of this in an Excel file:
In most cases, it is possible to double-click the CSV file and it is correctly loaded in Excel. However, there are cases where this does not work. Therefore, we recommend that you always do the following:
Go to File > Open in Excel and then go to the folder you have downloaded the file to. Open the file in Excel.
Then select how the file should be loaded with the formatting into the CSV file. "File Source" should always be Unicode (UTF-8).
The principle is exactly the same as MacOS but in Windows, Excel is often, by default, set to look only for * .xls - / * .xlsx files. In order for Excel to find a file with a different extension, you only have to choose that Excel should display all files.
Go to File > Open in Excel and then go to the folder you have downloaded the file to. In order to open the CSV file, you may need to search All Files.
Open the CSV file by clicking on it. Then follow the same steps as for MacOS!