# Downloading Data

{% hint style="warning" %}
Users must be logged in to download data, even if the project is public.
{% endhint %}

To download data for a project, go to the project home page and click on "View Data":

![](https://3293478884-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F32OIF30CgrNUuRY6IjkW%2Fuploads%2Fgit-blob-bb9965385247109c353c0e589648c7807e128ee8%2Fdownload-data-1.jpg?alt=media)

On the navigation bar at the top, click on "download" to open a left side panel with the download settings:

![](https://3293478884-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F32OIF30CgrNUuRY6IjkW%2Fuploads%2Fgit-blob-e2d08bfb593d86957853a67354953a467affb481%2Fdownload-data-2.jpg?alt=media)

A panel will slide in from the left:

![](https://3293478884-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F32OIF30CgrNUuRY6IjkW%2Fuploads%2Fgit-blob-4322c8689e0b8cf7412cb2e9dd3e31044c921c8c%2Fdownload-data-3.jpg?alt=media)

### Select the mapping

(The default mapping is always pre-selected). [**More on mapping data**](https://docs.epicollect.net/web-application/mapping-data)

{% hint style="success" %}
if you do not know what mapping is, just ignore it.
{% endhint %}

Pick `JSON` or `CSV` format.

### Select date range

You can also select which timeframe you are interested in.The default is "LIFETIME" to get all the data since the project was created.

![](https://3293478884-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F32OIF30CgrNUuRY6IjkW%2Fuploads%2Fgit-blob-853c5c402fa5389b3e78481a9f18d53681560b80%2Fdownload-data-4.jpg?alt=media)

If you need a custom timeframe, select "CUSTOM" and pick the start and end date.

![](https://3293478884-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F32OIF30CgrNUuRY6IjkW%2Fuploads%2Fgit-blob-db8212c9ce77db349d8eca275ff7ac194ed4581d%2Fdownload-data-5.jpg?alt=media)

Click on the project zip file to download it.

{% hint style="info" %}
If you have more than one single form and branches, you will get separate files: one file per each form and one file per each branch.

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), [**have a look at this link.**](https://www.extendoffice.com/product/kutools-for-excel/excel-merge-tables-by-column.html)

An example using Google Sheet can be found [**here**](https://docs.epicollect.net/common-use-cases/consolidate-data)**.**
{% endhint %}

{% embed url="<https://www.youtube.com/watch?v=UvPw9l54P14>" %}

### Split data into multiple columns

Checkbox questions can have multiple answers. Epicollect5 saves the answers to a question in a single column in`csv`format like "one, two, three". If you need a column per each answer, It can be easily done in Google Sheets ([**see how**](https://support.google.com/docs/answer/6325535?co=GENIE.Platform%3DDesktop\&hl=en)) or Excel ([**see how**](https://support.microsoft.com/en-us/office/split-text-into-different-columns-with-the-convert-text-to-columns-wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7)).


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.epicollect.net/web-application/downloading-data.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.