Opening CSV-files

Opening CSV-files

Excel
The CSV format is not straight forward to open in Excel. To do this, you need to first open a new spreadsheet.
Next, import the file from the file-menu option. 

It is important that you select CSV as file type, file origina as UTF-8, (only) comma as delimiter and " as text qualifier.

OpenOffice
In OpenOffice you will go directly to an import dialogue when opening a CSV-file. Remember to use the following settings when file is opened:
Comma as delimiter,  UTF-8 as encoding and " as text qualifier.

    • Related Articles

    • Data export

      To get raw data from a survey, the tenant admin can download a CSV file from surveys list. Click the download button on the right side of the survey row. The file will be downloaded directly. In the file you will find all completed responses. Where ...

    • Javascript (JS) question - store and retrieve values

      The Javascript question is in itself not storing any data in the survey. To store and retrieve respondent actions, you need to implement the following code in your javascript To store data from javascript: ...

    • Getting started as tenant admin

      Welcome as an Effect IO tenant administrator! Below you find an overview of the steps needed to go from a survey to exporting data. Effect IO is optimized for simplicity and flexibility for running projects. Working with surveys, reports and products ...