# Downloading data

**URL:** <https://forum.avicennaresearch.com/t/downloading-data/66>\
**Category:** Support\
**Created:** [August 16, 2019, 3:20pm UTC](https://forum.avicennaresearch.com/t/downloading-data/66 "2019-08-16T15:20:33Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![uofldailymoodstudy](https://forum.avicennaresearch.com/letter_avatar_proxy/v4/letter/u/94ad74/32.png) [@uofldailymoodstudy](https://forum.avicennaresearch.com/u/uofldailymoodstudy)\
**Post date:** [August 16, 2019, 3:20pm UTC](https://forum.avicennaresearch.com/t/downloading-data/66/1 "2019-08-16T15:20:33Z")

</div>

Can someone help provide more detailed instructions on downloading Ethica data in a CSV or SPSS format? All I can find on Ethica learn or FAQ pages are very broad. I am hoping to test the data export to make sure I am setting up the surveys in a format that is easy to analyze.

---

<div class="post-metadata">

**Author:** ![atdutoit](https://forum.avicennaresearch.com/letter_avatar_proxy/v4/letter/a/779978/32.png) [@atdutoit](https://forum.avicennaresearch.com/u/atdutoit)\
**Post date:** [August 17, 2019, 4:54am UTC](https://forum.avicennaresearch.com/t/downloading-data/66/2 "2019-08-17T04:54:12Z")

</div>

To download a CSV file of survey responses:

1. go to [your study]/surveys/responses/
2. select which participants’ surveys you want to see
3. select either a survey, or all the surveys, (it’s either one or all AFAIK)
4. then click the download button; you get a dropdown menu with CSV and JSON format; select CSV

… et voila. You get a zipped CSV file(s) per your specifications. It’s been a long while since I used SPSS but I’m sure it will read it OK.

Two notes, while I’m thinking of it:

- If you do save the CSV file in XLSX format for whatever reason, it is highly likely that Excel will mess up the dates and times
- I have some R code which cleans the extra words out of the CSV file and renames columns according to a consistent schema – let me know if you might like to use it

---

<div class="post-metadata">

**Author:** ![m.hashemian](https://forum.avicennaresearch.com/letter_avatar_proxy/v4/letter/m/a5b964/32.png) [@m.hashemian](https://forum.avicennaresearch.com/u/m.hashemian)\
**Post date:** [August 18, 2019, 4:20pm UTC](https://forum.avicennaresearch.com/t/downloading-data/66/3 "2019-08-18T16:20:26Z")

</div>

Thanks @atdutoit for the help 🙂

---

<div class="post-metadata">

**Author:** ![uofldailymoodstudy](https://forum.avicennaresearch.com/letter_avatar_proxy/v4/letter/u/94ad74/32.png) [@uofldailymoodstudy](https://forum.avicennaresearch.com/u/uofldailymoodstudy)\
**Post date:** [August 20, 2019, 1:56am UTC](https://forum.avicennaresearch.com/t/downloading-data/66/4 "2019-08-20T01:56:27Z")

</div>

Thank you!! If you are willing to share your R code that would be very helpful!

---

<div class="post-metadata">

**Author:** ![atdutoit](https://forum.avicennaresearch.com/letter_avatar_proxy/v4/letter/a/779978/32.png) [@atdutoit](https://forum.avicennaresearch.com/u/atdutoit)\
**Post date:** [August 20, 2019, 6:11am UTC](https://forum.avicennaresearch.com/t/downloading-data/66/5 "2019-08-20T06:11:57Z")

</div>

The code is here:

[My github page](https://github.com/benifex/ethica_utilities)

… free as in beer (though citations gratefully accepted 🙂 )

Flick me an email at A dot dutoit at westernsydney edu au – the instructions may not be that great.