Preparing Metric Spreadsheets for External Visual Production
The column structure and annotation conventions that let a visual production studio deliver accurate figures on the first draft — and avoid costly revision cycles.
The quality of finished ESG report visuals depends almost entirely on the metric spreadsheets clients provide at kickoff. A well-structured workbook accelerates first-draft delivery; a disorganised one consumes revision rounds that neither party planned for.
Required columns for every data row
Each metric row in your submission spreadsheet should include: indicator or figure reference number, metric name, reporting period, unit of measurement, numeric value, prior-year value (if comparison required), data source reference (worksheet name or database query ID), and any calculation methodology note. Missing any of these fields generates a clarification request that delays production.
Separate worksheets by disclosure chapter
Do not mix emissions data, social metrics, and governance indicators in one sheet. We map worksheets to report chapters during kickoff. A single "master" sheet with 200 rows across all topics forces manual sorting and introduces transcription errors.
Flag restatements explicitly
If you restated 2022 figures since last year's report, mark restated values in a dedicated column — do not silently replace prior-year numbers. Visual production treats unmarked changes as errors and flags them for confirmation, adding a full revision cycle.
Unit consistency
Convert all emissions to a single unit (typically tCO₂e) before submission. Mixed units (kg here, tonnes there, Mt elsewhere) are the most common cause of first-draft corrections. If different scopes use different units in your source systems, normalise in the spreadsheet and document the conversion factor in a methodology tab.
Version control
Name your file with a date stamp and version number: ClientName_Metrics_2025-03-15_v2.xlsx. Email is not a version control system — we receive an average of three updated spreadsheets per commission, and filename discipline prevents working from superseded data.
What to send alongside the spreadsheet
Include your disclosure outline (GRI content index or equivalent), brand guidelines if they exist, target print dimensions, and a list of figures you consider highest priority if timeline pressure requires phased delivery. These attachments reduce kickoff meeting duration and get production started faster.
Well-prepared data is the single highest-leverage action a sustainability team can take before engaging external visual production. The figures we deliver are only as traceable as the worksheets they come from.