On multiple occasions while using WISEflow it's possible to export lists of users or assessment exportation data to a CSV-file. Here's how to open them on a PC or a MAC.
There's different ways to open CSV-files whether you have a older or newer version of Excel. The two examples below give you two methods shown on both Mac and PC. The method can differ on your specific system and version, but these two examples should give you an idea of how to do the same either way.
Mac (Old versions of Excel)
- Go to the Data tab and click on From Text and find the .csv file to open.
- Find the CSV-file you downloaded from WISEflow in your file system and click Get Data.
This opens the Text Import Wizard.
- On Step 1 of the process make sure that File Origin is set to Unicode (UTF-8). And that the option Delimited is checked off
If this is not the case, find, Unicode (UTF-8) from the dropdown menu and check Delimited.
- "CSV" stands for "Comma-Separated-Values", meaning that columns are separated with commas in the file. For Excel to read this and convert them into actual columns, on Step 2, make sure that Comma is checked like below.
The preview below shows you how Excel will read the data. Play around with separators (e.g. comma, semicolon) until the preview is correct.
- It is possible that there are birth numbers (CPR) in one or more of the columns. Therefore, on Step 3 click the given column and set Column data format to Text, otherwise any 0's in front of the CPR might be deleted.
- Click Finish and OK to finalise the import.
PC (Newer versions of Excel)