From scattered spreadsheets to a clearer data platform
Spreadsheets are not the problem. Unclear definitions, copied files and missing owners are. A practical path towards data people can trust.

Most organisations run on spreadsheets, and many of them work well. Trouble starts when the same figure lives in several files, each slightly different, and nobody is sure which one the monthly report used.
A data platform can help, but buying one does not resolve those questions. This is the sequence we suggest for moving from scattered files to reporting people can rely on.
Begin with the decisions, not the data
List the decisions people make regularly and the figures they look at to make them. That short list is a better starting point than an inventory of every file, because it shows which data matters and how fresh it needs to be.
Agree definitions before building reports
Many reporting disagreements are definition disagreements. Does a “customer” include lapsed accounts? Is revenue counted when invoiced or when paid? Write the agreed definition beside each important measure, and name the person who decides when it changes.
- A plain-language definition for each key measure.
- The source system or file it is calculated from.
- An owner who approves changes.
- How often it is refreshed, and who is told when it fails.
Find the true source of each figure
For every measure, trace the figure back to where it is first recorded. Sometimes that is a business system; sometimes it really is a spreadsheet maintained by one careful person. Both are acceptable sources if they are known, owned and protected. Copies of copies are what cause trouble.
Build one shared foundation
Once sources and definitions are clear, bring the data into a shared foundation that reports can read from, instead of each report reaching into files independently. Modern platforms are designed around this idea. Microsoft describes OneLake in Microsoft Fabric as a single, unified, logical data lake for the whole organisation. [1]
The platform matters less than the discipline: one governed copy of each dataset, documented transformations and access granted by role rather than by forwarding files.
Deliver one trusted report first
Choose one decision from your list and build the report that supports it, end to end: source, transformation, definition and visual. Review it with the people who use it. A single report people trust does more for adoption than a large catalogue nobody is sure about.
- Pick one recurring decision.
- Agree its measures and definitions.
- Connect the true sources.
- Build and review the report with its users.
- Retire the spreadsheets it replaces, with their owners’ agreement.
Sources
Product-specific statements refer to the official documentation below. Other guidance is Sixsparks’ proposed approach.
- OneLake, the OneDrive for data — Microsoft Learn. Describes OneLake as a single, unified, logical data lake for the whole organisation, included with Microsoft Fabric.
A next step
Working on something similar?
If your reporting depends on files nobody fully trusts, we can help you map the decisions, definitions and sources before choosing a platform.

