When the dashboard answers the first question and you have five more
Analyze Exported Testimonials in Excel
The analytics dashboard tells you how many testimonials arrive, their ratings and where they come from. Questions that cross those lines, such as which product earns the longest written answers from new customers, need the rows themselves. Export a space to CSV, load it into Excel the careful way, and build a workbook your team can reuse every quarter. Score your current setup first.
- Six habits of a workbook you can trust
- A score with the next fix to make
- Built on the CSV export of each space
The problem, solved
What goes wrong when testimonials meet a spreadsheet
Excel steps follow Microsoft’s support article as read on 2026-11-19; menus can differ by version.
The dashboard cannot answer our question
Cross-cutting questions need the rows, and screenshots of charts cannot be filtered.
With StoryProof: Every plan has an analytics dashboard for the headline figures. For the rest, export each space’s testimonials as a CSV from the workspace settings and work on the rows.
Excel mangled our dates on opening
Double-clicking a CSV lets Excel apply its own formats to every column, so dates flip and numbers lose their zeros.
With StoryProof: Load the export through Data, From Text/CSV instead, which shows a preview and lets you control column types before anything lands in the sheet.
We have to label every row again
Hand-coding hundreds of quotes is slow, and doing it twice is worse.
With StoryProof: Tag testimonials in the StoryProof library as you approve them, and filter by tag there. Whatever tags your export carries can seed the coding columns, so check the file.
Our totals never match the app
When a spreadsheet count and the dashboard disagree, people stop trusting both.
With StoryProof: Analytics show how many testimonials you collect, their ratings, where they come from and how often you approve them. Write those figures on the workbook’s first tab and reconcile against them.
Which channel brings the useful ones?
Counting by source is easy in the app. Knowing which source brings the long, specific answers needs the text.
With StoryProof: The sources chart splits testimonials by where they arrived from. Use it for counts, and use the spreadsheet for your own judgements about quality by source.
Two brands in one analysis
Comparing brands in one sheet is useful but easy to muddle.
With StoryProof: Exports run per brand space. Load each space’s file into its own raw tab and add a brand column in the working tab before combining.
Flip the switch to see how StoryProof handles each one.
Workbook scorecard
How analysis-ready is your testimonial workbook?
Rate each habit yes, partly or no for the workbook you use today. The score tells you whether its numbers can be trusted, and every gap shows its fix.
Answers are scored in your browser. Nothing is recorded.
A sample coding scheme
Illustrative sample, not real customer data
The working tab keeps the export columns as they arrive and adds four columns on the right. Each takes only values from a short list, so PivotTables group cleanly.
Theme: onboarding, support, price, results, other. Product: one value per product line. Stage: trial, first year, long term. Length: short, medium, long.
A PivotTable with Theme as rows and Stage as columns then shows, for instance, whether long-term customers talk about support more than new ones.
- Raw tab
- Raw 2026-11-19 (export as downloaded)
- Working tab
- Copy of Raw plus four coding columns
- Readme tab
- Dashboard totals on export day
In StoryProof
Set up the workbook once, refresh it each quarter
- You will need
- Excel with the Data tab’s Get and Transform group
- Access to workspace settings
- Your dashboard figures on the export day
- 1
Export the space
Download the space’s testimonials as a CSV from the workspace settings and write the dashboard totals down the same day.
- 2
Load it through From Text/CSV
On the Data tab choose From Text/CSV, pick the file, check the delimiter in the preview, and load it to a new sheet named Raw.
- 3
Add coding columns on a copy
Duplicate the sheet as Working and add your coding columns with fixed values. Read each quote and code it yourself.
- 4
Count with PivotTables and reconcile
Build PivotTables from Working, then check their totals against the figures you noted from the dashboard.
What happens next: Next quarter, replace Raw with a fresh export, extend Working with the new rows only, and refresh the PivotTables.
Before you start
Limits worth knowing
Columns are not listed here
This page does not say which fields the export contains. Open the first export and design your coding around what is there.
No automated analysis is claimed
The themes in your coding columns come from people reading quotes. Nothing here says StoryProof labels or scores the text for you.
Excel steps can change
The From Text/CSV path follows Microsoft’s help as read on 2026-11-19. Menu names differ in older versions and on the web.
The dashboard is not a spreadsheet
This page makes no claim about date ranges or filters on the dashboard. Note the figures on the day you export so the two line up.
FAQ
Questions people ask
Short answers to what usually comes up next.
Why not just double-click the CSV?
Excel then applies its own default formats column by column. Loading through From Text/CSV gives you a preview and more control, which matters for dates and long text.
Can the same workbook cover several brands?
Yes. Load each space’s export into its own raw tab, add a brand column on the working copy, then combine them.
How many coding columns should we use?
Few enough that two people code the same quote the same way. Four or five with short value lists is a workable start.
Can we share the workbook with the wider company?
Share PivotTable summaries freely. Share the rows only with people who need names and quotes, and strip columns they do not need.
Still have a question? Ask the StoryProof team or book a demo.
Collect it in one library, analyse it anywhere
Approve and tag in StoryProof, then export a space to CSV whenever you need the rows.
Sources
- Import or export text (.txt or .csv) files, Microsoft Support. Checked 2026-11-19.
Last updated 2026-11-19.