Downloading Data
Download project data as csv or json files
Last updated
Download project data as csv or json files
Last updated
Users must be logged in to download data, even if the project is public.
To download data for a project, go to the project home page and click on "View Data":
On the navigation bar at the top, click on "download" to open a left side panel with the download settings:
A panel will slide in from the left:
if you do not know what mapping is, just ignore it.
Pick JSON
or CSV
format.
You can also select which timeframe you are interested in.The default is "LIFETIME" to get all the data since the project was created.
If you need a custom timeframe, select "CUSTOM" and pick the start and end date.
Click on the project zip file to download it.
(The default mapping is always pre-selected).
How to merge the data (if needed) il left to the user. For example, using Excel, there are several ways to merge tables based on common columns (in Epicollect5, look at ec5_uuid, ec5_parent_uuid for child forms and ec5_branch_owner_uuid for branch forms),
An example using Google Sheet can be found .
Checkbox questions can have multiple answers. Epicollect5 saves the answers to a question in a single column incsv
format like "one, two, three". If you need a column per each answer, It can be easily done in Google Sheets () or Excel ().