Typeform responses to dashboard
Typeform answers, charted without renaming a single column.
Export responses from Typeform and drop the CSV here. Typeform uses the full question text as each column header, so headers are whole sentences containing commas and question marks. This page handles that, buckets a zero to ten question into promoters, passives and detractors, and computes completion time from the separate start and submit stamps.
Prefer the full explorer? Open the app, or start from the generic dashboard builder.
Your column headers are sentences, and they change when you edit a question
Typeform is unusual in that the header row of your export is your questionnaire. A column is literally called Would you recommend us? (0-10), punctuation and all. That is lovely for readability and awkward for tooling: the header contains commas, so it must be quoted, and it contains question marks, which upsets some naive parsers. Any script that references columns by name is also referencing prose somebody in marketing can edit at will.
Which is the real trap. Change the wording of a question and the next export has a different column name for the same question, and every saved formula, chart or script silently loses its reference. Nothing errors; the column just is not there any more. This is why a Typeform analysis that lives in a spreadsheet tends to break every few months and nobody can work out why. Reading the file fresh each time, as this page does, sidesteps the problem entirely.
How to export from Typeform
- Open the form in Typeform Sign in at typeform.com, open the form you want, and switch to the Results tab at the top of the editor.
- Go to Responses Results splits into Summary, Responses and Insights. Responses is the table view, and it is the one that exports rows.
- Decide about partial responses The toggle for including incomplete submissions is right there. Including them lets you measure drop-off; excluding them gives you a clean completed set. Pick deliberately.
- Download as CSV The download control offers CSV and Excel. Take the CSV, since the Excel version can reformat the numeric answer columns unhelpfully.
- Drop it on this page Every choice question becomes a breakdown, the zero to ten question becomes an NPS panel, and free text stays in the grid where you can read it.
If you have logic jumps in the form, respondents skip questions, and those cells are blank rather than zero. That is real information about the path they took, not missing data.
Try with sample Typeform data (the same columns, 86 rows, no upload needed).
What the dashboard shows
Every panel below is built from a column that is actually in the export, named the way Typeform names it.
- Response volume over time. Submitted At bucketed by day, which shows the effect of whatever you did to promote the form.
- NPS breakdown. Promoters, passives and detractors as counts and as the standard net score, rather than an average of the raw zero to ten values.
- Every choice question as a bar. Each single-select question becomes its own ranked breakdown automatically, using the real question text as the panel title.
- Completion time distribution. Submit Date minus Start Date. A long tail here usually means one question is confusing people.
- Attribution. The how did you hear about us question cross-filtered against satisfaction, which is where the interesting correlations hide.
- Free text kept readable. Open answers stay in the grid, filterable by any chart click, because there is no substitute for reading them.
#,Token,Submitted At,Start Date (UTC),Submit Date (UTC),Network ID,How did you hear about us?,What are you hoping to do?,How satisfied are you so far?,Would you recommend us? (0-10),Which plan are you considering?,Anything else?,EmailTypeform export details
- Headers are the question text. Complete with commas and question marks. They are quoted correctly in the file, but any tool that splits on commas without respecting quotes will destroy the header row.
- Editing a question renames a column. Silently. Saved formulas and scripts referencing the old name stop finding it, and most of them fail quietly rather than loudly.
- Skipped questions are blank, not zero. Logic jumps mean a respondent legitimately never saw a question. Treating that blank as a zero drags every average down.
- Partial responses are optional at export time. The setting is not recorded in the file, so two exports of the same period can have different row counts for no visible reason.
- There are two timestamps. Start Date and Submit Date, both UTC, which is genuinely useful and unusual. It is the only reliable way to measure how long the form takes.
- Multi-select answers are comma-joined. Inside one cell. A choice whose own label contains a comma is then indistinguishable from two choices.
Bucket the NPS rather than averaging it, treat blanks as skips, and never build a formula that hardcodes a question's wording. Do that and the export is one of the friendlier survey files to work with.
Frequently asked questions
Why do my column headers contain commas and question marks?
Because Typeform uses the full question text as the header, so a column really is called something like How satisfied are you so far?. The fields are properly quoted in the CSV, so a compliant parser handles it. What breaks is anything that splits lines on commas without respecting quotes, which is a surprising amount of homemade tooling.
How should I calculate NPS?
Bucket the zero to ten answers: nine and ten are promoters, seven and eight are passives, zero through six are detractors. The score is the percentage of promoters minus the percentage of detractors, expressed as a whole number between -100 and 100. Averaging the raw responses gives you a mean satisfaction figure, which is a legitimate number but is not NPS and is not comparable to anybody else's.
What happens when I edit a question?
The column name in every future export changes to match. Old exports keep the old wording, so a merged dataset ends up with two columns holding the same question under different names. Nothing warns you. If you plan to track a metric over a long period, decide the exact wording once and leave it alone, however tempting a small improvement looks.
Should I include partial responses?
It depends on the question you are asking. Include them if you want to measure drop-off and see which question people abandon at, since that is often the most valuable finding in a survey. Exclude them if you are reporting on the answers themselves, because a partial response is a biased sample of people who found the form too long.
How long is my form taking people?
Subtract Start Date from Submit Date. Both are exported in UTC so the arithmetic is safe, and having both is unusual enough among survey tools to be worth exploiting. Look at the distribution rather than the mean. A long right tail almost always indicates one specific question where people stop and think, or go and look something up.
Are the free-text answers private here?
They stay on your machine. Open text fields in a survey collect whatever people decide to type, which regularly includes names, company details and complaints about individuals. The file is parsed in your browser tab, nothing is uploaded, and there is no account. That is the only responsible way to handle a column whose contents you cannot predict.
Related tools
Chart a survey without touching a header
86 responses with real question-text headers, a zero to ten recommendation question, free text and a realistic spread of completion times.
Open the sample Typeform dashboard