Skip to main content
Premium Feature - Available on the Premium plan ($7.99/month)

​
What is CSV Export?

CSV Export allows you to download all your customer rating data in a spreadsheet-friendly format. Perfect for deeper analysis, reporting, or importing into other tools.

​
What’s Included in the Export?

Each exported row contains:
ColumnDescriptionExample
Rating0-10 score9
CategoryPromoter, Passive, or DetractorPromoter
Order NumberShopify order number#1234
CommentCustomer feedback (if provided)“Great service!”
DateWhen rating was submitted01/15/2025

​
How to Export Data

1

Open Dashboard

Navigate to the Simple NPS Survey dashboard in your Shopify admin
2

Apply Filters (Optional)

Use the filter buttons to narrow down data:
  • All responses
  • Promoters only (9-10)
  • Passives only (7-8)
  • Detractors only (0-6)
3

Click Export to CSV

Click the “Export to CSV” button in the top right of the responses section
4

Download File

Your browser will automatically download a file named nps-responses-YYYY-MM-DD.csv
The export includes only the filtered data. Apply filters before exporting if you want a subset of your data.

​
Using Exported Data

​
Open in Excel or Google Sheets

  1. Open Microsoft Excel
  2. Click File → Open
  3. Select your downloaded CSV file
  4. Data will automatically populate in columns

​
Analysis Use Cases

Pivot Tables

Create pivot tables to analyze rating trends by month, category, or product

Charts & Graphs

Visualize data with custom charts beyond the dashboard

Email Lists

Extract order numbers for targeted email campaigns

Custom Reports

Build monthly or quarterly reports for stakeholders

​
Advanced Analysis Examples

​
1. Month-over-Month Comparison

1

Export data for two months

Export all data from your dashboard
2

Group by month in Excel

Use Excel’s GROUP BY or pivot table features
3

Compare NPS scores

Calculate NPS for each month and compare trends

​
2. Comment Sentiment Analysis

1

Export promoter comments

Filter for Promoters (9-10) and export
2

Identify common themes

Read through comments and tag common positive themes
3

Leverage in marketing

Use recurring praise in product descriptions and ads

​
Integration with Other Tools

​
Import into CRM

Many CRMs accept CSV imports:
  • HubSpot - Import contacts with custom NPS field
  • Salesforce - Add NPS data to customer records
  • ActiveCampaign - Create segments based on NPS

​
Analytics Platforms

Analyze data in dedicated tools:
  • Google Data Studio - Create custom dashboards
  • Tableau - Build advanced visualizations
  • Power BI - Enterprise reporting

​
Email Marketing

Use for targeted campaigns:
  • Klaviyo - Segment by NPS score
  • Mailchimp - Import as tags or custom fields
  • Omnisend - Create automation workflows
When importing to other tools, the “Order Number” column helps you match ratings back to customers and products.

​
CSV File Format

The exported file uses standard CSV format: 
Rating,Category,Order Number,Comment,Date
9,Promoter,#1234,"Great service!",01/15/2025
7,Passive,#1235,,01/15/2025
10,Promoter,#1236,"Best store ever!",01/16/2025
Comments with quotes or commas are automatically escaped for compatibility with all spreadsheet software.

​
Export Best Practices

Monthly exports work well for most stores. Export at the end of each month for consistent records.
It depends on your use case:
  • Full exports: Good for complete backups
  • Filtered exports: Useful for targeted campaigns (e.g., only Promoters for review requests)
For thousands of ratings:
  • Use Excel’s Power Query for advanced filtering
  • Consider database tools like MySQL or PostgreSQL

​
Upgrade to Premium

CSV Export is included in the Premium plan.

Upgrade Now

Get unlimited ratings + CSV export + auto-tagging for $7.99/month

​
Need Help?

FAQ

More questions about CSV export

Contact Support

Get help from our team