The Scenario
Your skip-level just asked for a combined view of all three NPS surveys — not a summary, the raw responses — by end of week.
You run a Mopinion report that aggregates your post-onboarding, in-app, and post-support NPS datasets. Together they represent 600 responses from Q1. Your manager wants them in a single Excel workbook alongside revenue data so finance can run their own cut. You're the one who has to get the data there.
The bad version:
- Export each of the three underlying datasets separately as CSV files from the Mopinion interface.
- Import each one into a different worksheet, reconcile the column headers across all three (they're not identical — different surveys, different custom fields), and merge them manually into a single flat table.
- Discover that the combined file is missing the NPS score from the in-app survey because that field is named differently there, and spend another 40 minutes tracking it down.
Nobody told you the field names would diverge across datasets. Nobody told you they'd need to be reconciled by hand. You're the one who found out.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook and connects directly to Mopinion — so instead of exporting and merging three datasets by hand, you pull the whole report in one ask.
Pull every response from my Mopinion 'Q1 User Satisfaction' report and write them to Sheet1, with each feedback field in its own column.
What You Get
- Every response from all datasets in the report lands in a single flat table in Sheet1.
- Columns: timestamp, NPS score, open-text comment — one row per submission, regardless of which dataset it came from.
- The row count matches the total across all three underlying surveys.
- The worksheet is ready to share with finance without any additional cleanup.
What If the Data Is Not Quite Ready
The NPS score field has different names across datasets
One dataset uses "nps_score," another uses "rating." You need them in one consistent column.
Fetch all feedback from Mopinion report 22511 and write each response to Sheet1. Normalize the score field — if the response has nps_score use that, if it has rating use that — and write the value into a single Score column.
You only need responses from one quarter, not the full history
The report goes back 18 months, but you need Q1 2026 only.
Pull all feedback from Mopinion report 22511 submitted between 2026-01-01 and 2026-03-31 and write each response to the Q1 sheet with timestamp, score, open-text comment, and dataset name.
You need to flag which dataset each response came from
Finance wants to know whether a given row came from post-onboarding, in-app, or post-support.
Fetch all feedback from Mopinion report 22511 and write each response to Sheet1. Add a Source column that shows the dataset name for each row.
Pull, clean, and format for the executive deck in one step
The deck needs a clean table with no blank comment rows and a count of promoters (9–10), passives (7–8), and detractors (0–6).
Pull all responses from Mopinion report 22511, skip rows with a blank open-text comment, write the clean responses to the Data sheet, then add a Summary section below with total count, promoter count (score 9–10), passive count (7–8), and detractor count (0–6).
The practical pattern: pull the data and run the segmentation in the same ask, rather than pulling first and computing separately.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook where you're preparing NPS analysis. Pull your Mopinion report data with one prompt, then see how to compute summary statistics from that data or review the full Mopinion integration guide.