Epicollect5 User Guide
  • What is Epicollect5
  • About
    • Projects and Entries Syncing
    • Our Community
    • Privacy Policy
    • Cookie Policy
    • News & Papers
    • Epicollect5 Citation
  • Web Application
    • Intro
    • Create a Project
    • Project Info & Privacy
    • Delete Projects (Web)
    • View Projects
    • Search Projects
    • Viewing Entries
    • Print Entries
    • Add & Edit Entries
    • Manage Entries
      • Entries Limits
      • Entries Bulk Deletion
      • Entries Bulk Uploads
      • Entries Ownership & Metadata
    • Manage Users
    • Transfer Ownership
    • Manage Entries
    • Data Mapping
    • Downloading Data
    • Downloading Media
    • Metadata
    • Clone Project
    • Rename Projects
    • Import & Export Projects
    • Web Link to Add Entries
  • Formbuilder
    • Intro
    • Languages and Translations
    • Question Types
    • Add Questions
    • Edit Questions
    • Linking Forms
    • Rename Forms
    • Print Forms
    • Remove Forms
    • Search
    • Jumps (If-Else)
    • Branches
    • Groups
    • Title
    • Uniqueness
    • Double-entry Verification
    • Import & Export Forms
    • Import & Export Possible Answers
    • Edit Possible Answers
  • Mobile Application
    • Intro
    • Platforms and Media
    • Mobile App Authentication
    • Mobile App Permissions
    • Add Projects
    • Add Entries (Single Form)
    • Add Entries (Multiple Forms)
    • Edit Entries
    • Re-use answers
    • Save & Resume Entries
    • Upload Entries
      • Upload Errors
      • Incomplete Entries
      • Missing required aswers
      • Unsync entries
    • Entries Limits
    • Download Entries
    • Delete Entries
    • Delete Projects (App)
    • Location Questions
    • Add Bookmarks
    • Project Info
    • Share Media Files
    • Adjust Font Size
    • Filter Entries
    • Beta updates (Android)
    • Xiaomi Troubleshooting
  • Developers
    • Intro
    • API
    • Apps
  • Integrations
    • Google Maps
    • Google Earth
    • Microreact
    • Survey Toolkit
    • Google Sheets
  • Common Use Cases
    • Matrix Style Questions
    • Consolidate data
    • Jumps 101
    • Other, Please Specify
    • Non-Hierarchical Forms
    • Users Working Groups
    • Excel and UTF-8
    • Excel All Data in One Cell
    • Barcodes
    • Child Forms vs Branches
    • Dependent Dropdowns
    • Referencing Parent Form Responses
  • Extra
    • Useful Links
    • Demo Projects
    • FAQ
    • How-to Videos
    • Known Issues
Powered by GitBook
On this page
  • Select the mapping
  • Select date range
  • Split data into multiple columns
  1. Web Application

Downloading Data

Download project data as csv or json files

PreviousData MappingNextDownloading Media

Last updated 5 months ago

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:

Select the mapping

if you do not know what mapping is, just ignore it.

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.

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

Click on the project zip file to download it.

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.

Split data into multiple columns

(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 incsvformat like "one, two, three". If you need a column per each answer, It can be easily done in Google Sheets () or Excel ().

More on mapping data
have a look at this link.
here
see how
see how