How to build a weekly executive report from multiple spreadsheets
Build a weekly executive report by defining a small decision-led metric set, mapping each source to approved definitions, running completeness and reconciliation controls, and writing fact, interpretation, risk, and action separately. Preserve the reporting cut-off so late source changes do not rewrite the signed record.
From the field · Executive assistant
Create a Friday leadership brief from four team exports
Finance reports revenue, sales reports pipeline, support reports backlog, and HR reports staffing. Sales uses month-to-date while finance uses posted transactions through Thursday, and one support extract arrives late.
Columns used in the example
reporting_week · metric · actual · target · prior_week · source · cutoff_time · owner · evidence_id
Follow it with your own file
- Align metric definitions and reporting cut-offs in a KPI dictionary.
- Load each source with an expected-file and freshness check.
- Calculate the small set of approved comparisons and material exceptions.
- Draft three takeaways with evidence, caveat, owner, and next action.
Check: Every reported value must trace to evidence available at the frozen cut-off; missing sources must remain visibly missing; action status must carry into the following week.
A useful mental model
- Choose material outcomes, risks, and actions for the executive audience.
- Check file, period, grain, definition, and owner for every metric.
- Run completeness, row, amount, denominator, and cross-report controls.
- Publish a dated version and carry action owners and due dates into the next report.
Why the obvious method fails
Department owners send spreadsheets at different times and grains. The assistant spends hours copying figures, while definitions and the reporting cut-off drift from week to week.
Choose the approach that matches the evidence and repetition
| Approach | When it works | What to verify |
|---|---|---|
| Email roundup | Very small informal teams | Definitions and traceability |
| Live dashboard | Continuous monitoring | Frozen narrative and decisions |
| Versioned weekly report | Executive review and follow-up | Source discipline |
Patterns that need context
- The same KPI has different values in two department files.
- Late data silently changes last week's report.
- The pack contains many charts but no decision owner or next action.
A method you can follow
- Start from decisions: Choose material outcomes, risks, and actions for the executive audience.
- Apply source contracts: Check file, period, grain, definition, and owner for every metric.
- Verify before narrative: Run completeness, row, amount, denominator, and cross-report controls.
- Freeze and follow up: Publish a dated version and carry action owners and due dates into the next report.
The report is a decision record, not a data dump
A weekly brief earns attention by choosing material evidence and preserving its state at the decision moment. Detail can remain in supporting tables while the summary states what changed, why it matters, and who acts.
Where this usually goes wrong
Do not fill a missing department metric with the prior week's value without a prominent stale-data label. A complete-looking report can be less trustworthy than an explicit gap.
Doing these steps in Prepyr
Prepyr accepts CSV files only. Export the worksheet or table you need as a UTF-8 CSV first; workbook formulas, formatting, macros, charts, and other sheets will not be included. Describe the result you need: Build a recurring weekly executive report from multiple Excel and CSV sources. Check the columns selected, preview any proposed changes, and compare the output with the source before applying or exporting it.
Prepyr steps used here: Data cleaning · Verified analysis · Reusable workflows · Reports
What to verify before acting
- KPI dictionary used
- Sources and cut-offs checked
- Evidence reconciled
- Missing data disclosed
- Owners and actions carried forward
A concise weekly leadership report that can be reproduced, audited, and refreshed without copying figures into a new narrative from scratch.
Questions readers usually ask next
How many KPIs should a weekly executive report include?
Use the smallest set that supports current decisions and risks. There is no universal count; importance and audience determine it.
What should happen when one source is late?
Show the gap or clearly labeled stale value, name the cut-off, and avoid presenting the report as fully current.