Export Shopify Survey Responses to CSV: Filters and Row Counts

To export Shopify survey responses from OrderSurvey, open Responses, choose the survey and date range, then select Export CSV. Export requires Unlimited. Before counting answers, check which export you downloaded: the Responses page and an individual survey's view produce different columns and date formats.

This guide explains those differences, why a CSV can contain more rows than the app's response list, and how to open the file without changing order IDs. It describes OrderSurvey's exports, not Shopify's separate order export.

Choose the export that fits your report

For a report that needs precise date boundaries or the page where an answer was submitted, start from Responses. For a single survey's answers with a dedicated NPS Score column, use Export CSV in that survey's view.

Both files include Order ID, Question, Answer, Other Text, Tags and Customer Tag Status. Their column order differs, so match headers when preparing a spreadsheet template. Do not paste a new file into an old template solely by column position.

The Responses export does not include a Survey column. If two surveys use the same question wording, selecting All surveys can make their rows difficult to distinguish. Export each survey separately when you need survey-level results. Neither layout includes question IDs to distinguish identical question wording within one survey.

Set the survey and reporting dates

On Responses, choose a survey before exporting. The date choices are All Time, Today, Last 7 Days and Last 30 Days. The export carries the page's selected survey and date filters.

Use a rolling shortcut for a quick operational review. For a fixed calendar month, choose All Time, save the file and apply exact boundaries in your spreadsheet. A download made on the fifth of a month with Last 30 Days selected is not the previous calendar month's report.

The exported Date records when the answer was submitted, not when the order was placed. An answer on Order status may refer to an older purchase. Define whether you need an answer-date report or a purchase-date cohort before comparing it with sales. The channel-report guide explains the separate order-matching work needed for purchase-based reporting.

For answer-date reporting, keep the full timestamp from the Responses export. Convert UTC to your chosen reporting time zone consistently, then include the start of the month and exclude the start of the next month. Record that time zone and the download date. The survey-view export's date-only column cannot recover the missing time of day for a precise local-time boundary.

The individual survey view's Export CSV button downloads all retained responses for that survey. It does not carry the Responses page's date selection into that separate download.

Count answers, responses and orders separately

The Responses list shows the latest 100 matching responses. Its export includes all matching retained responses, rather than only those visible rows. Each response can then expand into several CSV rows because each answered question gets its own row.

Illustrative example, not customer results: three orders submit one response each. Each answers a discovery question, two answer a follow-up, and two answer a product question. That produces seven CSV rows: three discovery answers, two follow-up answers and two product answers. It still represents only three responding orders in this example.

For a discovery-source breakdown, filter to the exact discovery question first. Then review missing or repeated Order IDs and count distinct answering orders within that question. Keep conditional follow-ups separate; the people who answered a follow-up may be only part of the original group.

An order count is not a unique-customer count. The CSV also does not provide all eligible orders or everyone who saw the survey, so it cannot supply a response-rate denominator on its own. Use the response-rate guide when choosing that denominator.

In the survey-view export, a response's NPS Score can appear on its follow-up question rows as well. Do not count every nonempty NPS Score cell as another NPS respondent. Isolate the intended NPS question and resolve repeated order references before calculating the score. The NPS calculation guide covers the scoring method.

Open the CSV without changing the data

Keep the original download and make a working copy. In Excel, importing through Data → Get Data → From File → From Text/CSV gives you control over how the file is read. If accented characters look wrong, use UTF-8 when importing; Microsoft documents this approach in its UTF-8 CSV guidance.

Set Order ID to Text before loading it into the worksheet. It is an identifier, not an amount to add or round. Microsoft's guidance on leading zeros and large numbers explains why automatic numeric conversion can alter long identifiers. Formatting a rounded value as text afterward does not restore the original digits; reimport the original file instead.

Use a CSV-aware importer rather than splitting each line at every comma. A buyer's answer can contain commas, quotation marks or a line break. Inspect a few rows against the app before building formulas, especially answers with Other Text. For grouping those comments into themes, follow the free-text coding workflow.

Keep a small export record

Alongside the original CSV, record the store, survey, export location, selected date range, download date and reporting time zone. Add the question being analyzed and any known tests or unresolved rows you excluded. Retention can remove older answers; an export is a snapshot of the answers still retained when you download it.

For a recurring client deliverable, the monthly agency report template turns reviewed answering-order counts into a consistent report. Keep each client's files and permissions separate, and share only the detail needed for the agreed work.

OrderSurvey Unlimited is $24 USD per store per month and includes CSV export and unlimited responses. Free includes unlimited surveys and up to 100 responses across the store per rolling 30 days; review the current plan details before upgrading.

Install OrderSurvey from the Shopify App Store, or book personal setup help with Dennis. We can help verify the Thank you and Order status survey blocks and a saved answer, then show you which export fits your reporting question.

Frequently asked questions