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
  1. Integrations

Google Sheets

Connect a Google spreadsheet to an Epicollect5 public project

PreviousSurvey ToolkitNextMatrix Style Questions

Last updated 7 months ago

Using the Epicollect5 API, it is possible to export entries in csv format.

The project must be public to work with Google Sheets.

If you have a private project, have a look at the Survey Toolkit code .

Google Sheets features the =IMPORTDATA() function to import data at a given url in .csv (comma-separated value)

IMPORTDATA() Official Docs ->

Create a new sheet and click on the first cell. Paste the following in:

=IMPORTDATA("")

After the entries are loaded, it will look like below.

For this example, the public was used.

The URL passed in the IMPORTDATA() function will load the latest 1000 entries as we passed the parameter per_page=1000 and page=1

To get more entries (if any) we need to add more IMPORTDATA() calls and tweak the URL to get a different page ie. 2, 3, 4 and so on.

It is possible to have up to 50 IMPORTDATA()calls on a single spreadsheet in Google Sheets.

One way to do that would be to create another sheet on the same file and repeat the procedure above, this time using a parameterpage=2in the URL.

Another option is to load the first 1000 entries and the headers on the first cell, then on row 1002 load the next 1000 entries omitting the headers in the request by passing the parameter headers=false. This way 2000 entries will be loaded on the same sheet.

Resource at URL content exceeded maximum size

This error on Google Sheets means the dataset you are trying to import is too big in size.

Try to lower the number of entries on eachimportdata() call.

The spreadsheet in the example can be viewed at

Full API guide at

https://docs.google.com/spreadsheets/d/1XibVZ5RXxT9ZfrDUx403I0ZTS0MHe1h26tlFP0dM-bU/edit?usp=sharing
https://developers.epicollect.net
here
https://support.google.com/docs/answer/3093335?hl=en
https://five.epicollect.net/api/export/entries/ec5-demo-project?form_ref=b963c3867b1441b89cb552b982f04bc8_5784e0609397d&format=csv&per_page=1000&page=1
EC5 Demo Project
Entries loaded in Google Sheets
Loading entries in separate sheets
Loading entries in the same sheet