I have encountered a problem when downloading the output file from a pilot survey in Pavlovia. When I open the output file in Excel, the file is not arranged correctly and is missing data. An error message pops up in Excel saying “POSSIBLE DATA LOSS some features might be lost if you save this workbook in the text (.txt) file format. To preserve these features, save it in an Excel file format.”
My University IT department suggested that this was because it is downloading as a JSON file format and to contact Pavlovia for further support in relation to downloading it as a true .csv or crosstabs file.
Sorry, I didn’t notice you were asking about a survey. What are you pressing to download your data? There is a download button which downloads the survey itself as a json. Maybe you are pressing that
Ah. I think it’s because you’re piloting. Surveys are automatically database. If you switch to running then you can see the data in the data tab or download the CSV. If you open the JSON in a text editor then it should have the data for a single pilot. I’ll raise an issue about this.
I tried that and it does download as a CSV. file (thank you!) but the responses still seem to be coming out wrong and some of the data is missing? I’ve attached a screenshot.
Thanks so much for your help with this, that’s all sorted now! I have one other question if that’s ok: when I ran the survey and accessed it on a phone an error message came up and wouldn’t let me take the survey:
