> For the complete documentation index, see [llms.txt](https://docs.epicollect.net/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.epicollect.net/web-application/downloading-data.md).

# 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":

![](/files/QPcXHbcC2wZzXLXCmAu8)

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

![](/files/30GRsqKcYp3yuZzJqaj5)

A panel will slide in from the left:

![](/files/v6vJCz0R8OJo7yYrgide)

### Select the mapping

(The default mapping is always pre-selected). [**More on mapping data**](/web-application/mapping-data.md)

{% 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.

![](/files/TWbI0WImZedMFIbdqx9X)

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

![](/files/q7pdG8aAsFK0BETrLLgI)

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**](/common-use-cases/consolidate-data.md)**.**
{% 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
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

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

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.