For AI agents: the complete documentation index is available at https://docs.clickmax.io/en/llms.txt, the full documentation bundle is available at https://docs.clickmax.io/en/llms-full.txt, and this page is available as Markdown at https://docs.clickmax.io/en/features/create/quiz/export-submissions.md.
  • English
  • 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

    1. In Projects → Quiz (or Forms), click Export responses, next to Create quiz / Create form.
    2. 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.
    3. 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).
    4. 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.
    5. Click Export. You will see Export started and the task shows up in the running-tasks bar.
    6. 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.

    GroupColumns
    Form (always)ID do formulário, Formulário, Tipo (Quiz or Formulário)
    SubmissionID da submissão (always), Data, Status (Concluída or Parcial), Resultado, Pontuação, Dispositivo
    ContactID do contato, Nome do contato, E-mail do contato
    UTMsUTM Source, UTM Medium, UTM Campaign, UTM Term, UTM Content
    Answer (always)ID da pergunta, Pergunta, Resposta
    • Column headers are in Portuguese, the same as every other export of the platform.
    • ID do contato is 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 original ID 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.

    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.