How do I export the responses of every quiz and form into a single file?
On the Quiz or Forms list, click Export responses. The platform generates, in the background, a CSV with the responses of every quiz (or form) in the workspace — or only the ones you pick — and hands you the download in the running-tasks notice, in the corner of the screen, as soon as the file is ready. Each row of the file is one answer (form · submission · question · answer), so quizzes with different questions fit in the same file.
Before you start
- Role: owner, admin, editor or collaborator — the roles that see Projects. Attendants, guests and the finance role do not see that section, so they cannot export — see what to do without permission.
- Where: menu Projects → Quiz (exports quizzes) or Projects → Forms (exports forms). The button only shows when the list has at least one quiz or form.
- To analyse one quiz with one column per question (wide format), use Export on that quiz's analytics screen. This page covers the consolidated export.
Step by step
- In Projects → Quiz (or Forms), click Export responses, next to Create quiz / Create form.
- Under Which quizzes (or Which forms), keep All quizzes or pick Choose which to export and tick the items in the list. Use Search by name... to filter the list.
- Under Period, choose Last 7 days, Last 30 days, Last 90 days, All time or Custom (fill in From and To; both days are included in full).
- Under File columns, switch the Submission details, Contact and UTMs groups on or off. The form, submission ID, question and answer columns are always included.
- Click Export. You will see Export started and the task shows up in the running-tasks bar.
- When the task Export responses from N quiz(zes) (or form(s)) finishes, click View details in the running-tasks notice and use Preview or download respostas-formularios.csv. Owners, admins and editors find the same download later in Contacts → Bulk actions.
What the file contains
One row per answer. A submission with three answered questions produces three rows, with the form, submission and contact columns repeated. A submission with no answers at all produces one row with empty question and answer, so the submission (and the captured contact) does not vanish from the file.
- Column headers are in Portuguese, the same as every other export of the platform.
ID do contatois the same column used by the contacts and opportunities exports: join the files on it to rebuild each person's journey.- Multiple-choice answers share one cell, separated by
|. Options show the text the visitor saw, not the internal code. - Empty values come out as
-. Dates use ISO format (2026-09-01T14:03:00.000Z, UTC). - If a question was removed from the quiz after being answered, the answer stays in the file with
Pergunta=-and the originalID da pergunta. - A paused quiz or form is exported as usual: the responses it already received stay in the file, so you take the full history with you. The same goes for ones still in draft.
- Deleted quizzes and forms are not exported.
Related
If it did not work
- The Export responses button is missing: the list is empty — create a quiz or form first.
- The export returns Could not start the export: your role may lack permission — see roles and permissions.
- You closed the running-tasks notice or reloaded the page before the task finished: the notice does not come back. Owners, admins and editors get the file in Contacts → Bulk actions; on the collaborator role, export again and keep the tab open until View details shows up.
- You chose Custom and could not export: fill in From and To, with the start date on or before the end date.
- The task finished with 0 results: there are no submissions in the chosen period — widen it or choose All time.
- Accents look wrong in Excel: import the CSV choosing the UTF-8 encoding.