Export data

Citation requirement

If you publish research conducted using oTree, you are required by the oTree license to cite this paper.

Citation:

Chen, D.L., Schonger, M., Wickens, C., 2016. oTree - An open-source platform for laboratory, online and field experiments. Journal of Behavioral and Experimental Finance, vol 9: 88-97


All apps (wide format)

Data for all apps in one file. There is one row per participant; different apps and rounds are stacked horizontally. This format is useful if you want to correlate participants' behavior in one app with their behavior in another app.

All apps (wide format) CSV Excel CSV
Show API URLs
CSV /api/export_wide
Excel CSV /api/export_wide?format=csv_bom
One session only /api/export_wide?session_code={SESSION_CODE}

Per-app data

One row per player in the given app. If there are multiple rounds, there will be multiple rows for the same participant.

Instructions CSV Excel CSV
Show API URLs
CSV /api/export_app?app=Instructions
Excel CSV /api/export_app?format=csv_bom&app=Instructions
One session only /api/export_app?app=Instructions&session_code={SESSION_CODE}
consent_intro CSV Excel CSV
Show API URLs
CSV /api/export_app?app=consent_intro
Excel CSV /api/export_app?format=csv_bom&app=consent_intro
One session only /api/export_app?app=consent_intro&session_code={SESSION_CODE}
main_tasks CSV Excel CSV
Show API URLs
CSV /api/export_app?app=main_tasks
Excel CSV /api/export_app?format=csv_bom&app=main_tasks
One session only /api/export_app?app=main_tasks&session_code={SESSION_CODE}
post_experiment CSV Excel CSV
Show API URLs
CSV /api/export_app?app=post_experiment
Excel CSV /api/export_app?format=csv_bom&app=post_experiment
One session only /api/export_app?app=post_experiment&session_code={SESSION_CODE}
practice_rounds2 CSV Excel CSV
Show API URLs
CSV /api/export_app?app=practice_rounds2
Excel CSV /api/export_app?format=csv_bom&app=practice_rounds2
One session only /api/export_app?app=practice_rounds2&session_code={SESSION_CODE}

Custom exports

main_tasks (custom_export) CSV Excel CSV
Show API URLs
CSV /api/export_app_custom?app=main_tasks&function_name=custom_export
Excel CSV /api/export_app_custom?format=csv_bom&app=main_tasks&function_name=custom_export
One session only /api/export_app_custom?app=main_tasks&function_name=custom_export&session_code={SESSION_CODE}
post_experiment (custom_export) CSV Excel CSV
Show API URLs
CSV /api/export_app_custom?app=post_experiment&function_name=custom_export
Excel CSV /api/export_app_custom?format=csv_bom&app=post_experiment&function_name=custom_export
One session only /api/export_app_custom?app=post_experiment&function_name=custom_export&session_code={SESSION_CODE}
practice_rounds2 (custom_export) CSV Excel CSV
Show API URLs
CSV /api/export_app_custom?app=practice_rounds2&function_name=custom_export
Excel CSV /api/export_app_custom?format=csv_bom&app=practice_rounds2&function_name=custom_export
One session only /api/export_app_custom?app=practice_rounds2&function_name=custom_export&session_code={SESSION_CODE}

Other exports

Page times CSV Excel CSV
Show API URLs
CSV /api/export_page_times
Excel CSV /api/export_page_times?format=csv_bom

Notes