Analyse Survey Results

From a messy sheet to findings and charts, in plain English.

You start withA raw export of your survey responses

You end withKey findings, a results table, themes from the open answers and next steps

Step 1

Use Julius

Upload the file and ask in plain English; it runs the numbers and draws the charts.

Save it as survey-clean.xlsx. Upload the export to Julius, ask it to clean the answers and export them as Excel, then click the download link it posts in the chat.

Step 2

Give your agent the XLSX skill

Builds count and percent tables with formulas that update as answers come in.

npx skills add anthropics/skills --skill xlsx

Save it as survey-tables.xlsx. Copy the Counts and Open answers tabs of survey-tables.xlsx into {{Survey questions and results}}.

Step 3

Run the Survey Results Analysis prompt

Key findings, a results table, themes from the open answers and next steps.

What the survey was forWho answered and how you ran itSurvey questions and results

Any capable chat assistant analyses a pasted survey well; for large exports, pick one that accepts spreadsheet uploads and can run calculations.