Export CSV has no comma between fields

Export CSV has no comma between fields

by Low Jiun Jack -
Number of replies: 2
Hi,

I am using questionnaire 3.3.1 (Build - 2017051800) on Moodle 3.3 (Build: 20170515) .

I have created a questionnaire that has about 80 questions for my students to tell me about my teachers.

I need to export the data into CSV for my analysis. When I tried to export to CSV, it forces into TXT file. When I convert the file extension TXT to CSV and open in excel, i find all data were mixed up, I cannot separate which number is for which data column because there is missing comma "," between data fields.

What should I do?



Average of ratings: -
In reply to Low Jiun Jack

Re: Export CSV has no comma between fields

by C Behan -

Hi Low,


I believe it's separated by tabs rather than commas. 


Catherine

Average of ratings: -
In reply to Low Jiun Jack

Re: Export CSV has no comma between fields

by Christop Castro -

You need just Open .txt in Excel 2010 and you can see the txt in a sheet correctly 

Average of ratings: -