Short answer. Stay on a spreadsheet while you have one legal entity, a handful of sites, Scope 1 and 2 only, and one person who owns the file. Switch to carbon accounting software when at least two of these change: several entities, recurring Scope 3 requests, external assurance, or more people entering data than one file can safely handle. Buying earlier mostly adds a subscription to a data problem.
Checked on 17 November 2026. Sources and unresolved points are in the method note at the end.
Almost every article that answers this question is written by a company that sells the software. That does not make them wrong, but it does make "when should you switch" read a lot like "now". The honest answer depends on a short list of triggers, and most small companies hit none of them in their first two years.
Key takeaways
- A spreadsheet handles one entity well. Scope 1 and 2 need no software.
- Count triggers, not ambitions. Two or more triggers justify a switch.
- Scope 3 is the usual tipping point. Supplier data multiplies rows fast.
- Assurance changes the calculus. Auditors need traceable, controlled data.
- Migration has its own cost. Restating a baseline takes time.
What can a spreadsheet do well?
Everything a single-site or small multi-site company needs for Scope 1 and 2. That means collecting monthly activity data, applying dated emission factors from a named source, reporting location-based and market-based Scope 2, and keeping a change log.
The conditions are discipline, not features. Inputs sit on one tab, factors on another, calculations use formulas only, and one named person owns the file. Our guide to Scope 1 and 2 in a spreadsheet sets out a five-tab structure that meets them.
That covers what the voluntary SME standard's basic module asks for on emissions, which is also what most customer questionnaires request from small suppliers.
Which triggers mean it is time to switch?
Five, and the rule of thumb is that one trigger can be managed in a spreadsheet while two or more usually cannot. The table sets out what each looks like and why it strains a file.
| Trigger | What it looks like | Why a spreadsheet struggles | Spreadsheet still workable? |
|---|---|---|---|
| Several legal entities | A group with subsidiaries reporting separately and consolidated | Boundaries, ownership shares and intercompany energy get tangled | For two or three entities, with care |
| Recurring Scope 3 requests | Customers ask for purchased goods, transport or use-phase emissions | Spend or supplier data runs to thousands of rows with changing factors | For one or two categories using spend data |
| External assurance | An auditor or verifier must sign off the figures | Needs access controls, audit trails and locked versions | Rarely, without significant controls |
| Many contributors | Sites or departments enter their own data | Version conflicts and overwritten formulas | Up to two or three disciplined users |
| Frequent reporting cycles | Quarterly reports, several frameworks, or monthly customer feeds | Rebuilding outputs each cycle costs more than a licence | For an annual cycle, yes |
Notice what is missing from the table. Wanting a dashboard, a net zero target or a more professional look is not a trigger, because none of them changes how hard the data is to manage.
Why is Scope 3 usually the tipping point?
Because it changes the shape of the data. Scope 1 and 2 for a small company is a few dozen lines a year; Scope 3 purchased goods alone can be every invoice line, each needing a category and a factor.
Spend-based estimates can still live in a spreadsheet for a year or two, especially for one or two categories. Once customers start asking for supplier-specific figures or product-level footprints, the mapping and maintenance work is what software is built to carry.
If Scope 3 requests are only arriving occasionally, answer them with a documented spend-based estimate first. That buys time to see whether the requests become recurring before committing to a contract.
What does switching actually cost?
More than the subscription. Vendors rarely publish prices, quotes bundle different things, and the licence is often not the largest line, as we set out in our analysis of the real software cost.
On top of that sit costs specific to moving from a spreadsheet. Your historical data has to be migrated and checked, your baseline may need restating if the software applies different factors or boundaries, and someone has to learn a new system while still answering requests.
A good spreadsheet makes all of this cheaper. Clean inputs, documented factors and a change log are exactly what an implementation team asks for first, so the time spent structuring the file is not wasted when you do switch.
How do you prepare for the switch before it happens?
Build the spreadsheet as if it will be migrated. Keep one row per activity per month, use consistent units, record every factor's source and year, and never type a number into a calculation cell.
Then set a review point. Once a year, after the accounts close, check the five triggers in the table. If two apply, start a vendor comparison with written quotes; if not, roll the spreadsheet forward another year.
If two triggers apply, take our demo questions into every vendor call.
Method note
The triggers and thresholds in this article are Green Insider's assessment based on how emissions data scales with entities, scopes and contributors, and on the structure of the GHG Protocol Corporate Standard and Scope 3 Standard. They are not drawn from any vendor's guidance, and no vendor is named or recommended.
The reference to the basic module follows Delegated Regulation (EU) 2026/1560. Requirements for external assurance depend on the framework and jurisdiction you report under, so check what applies to you before treating assurance as a trigger.
All sources read on 17 November 2026. This article is not legal or financial advice.
What to do this week
- Count how many of the five triggers apply to you today.
- If none or one applies, restructure your spreadsheet along the five-tab model.
- If two or more apply, list your entities, sites, users and Scope 3 categories before any vendor call.
- Ask every vendor for total three-year cost in writing, with exclusions listed.
- Set a yearly review date to recheck the triggers.
You can read who writes Green Insider, and why, on the about page.
Frequently asked questions
Is a spreadsheet good enough for carbon accounting?
For one entity reporting Scope 1 and 2, yes, provided inputs, factors and calculations are separated and one named person owns the file.
When does carbon accounting software become worth it?
Usually when two or more triggers apply: several entities, recurring Scope 3 requests, external assurance, many contributors or frequent reporting cycles.
Can I do Scope 3 in a spreadsheet?
For one or two categories using spend-based estimates, often yes. Supplier-specific or product-level Scope 3 is where software earns its cost.
Will switching change my baseline?
It can, if the software applies different factors or boundaries. Plan to compare both calculations for the base year and document any restatement.
What should I prepare before talking to vendors?
Your entities, sites, user count, Scope 3 categories needed now and a clean history of activity data. Every quote is built on those inputs.
Green Insider is independent. No vendor paid for a mention in this article, none was given advance sight of it, and no vendor is named or recommended here.




