Skip to main content

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.

  • 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.

  • We have to label every row again

    Hand-coding hundreds of quotes is slow, and doing it twice is worse.

  • Our totals never match the app

    When a spreadsheet count and the dashboard disagree, people stop trusting both.

  • 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.

  • Two brands in one analysis

    Comparing brands in one sheet is useful but easy to muddle.

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.

The CSV is loaded with From Text/CSV, not double-clicked
A raw tab holds the export exactly as downloaded
Coding columns are added by hand on the working tab
Counts come from PivotTables, not hand tallies
Totals are reconciled with the dashboard
The workbook is shared only with people who need it

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. 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. 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. 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. 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

  1. Import or export text (.txt or .csv) files, Microsoft Support. Checked 2026-11-19.

Last updated 2026-11-19.