ConsoliSheetBranches tend to send the same report in slightly different shapes. The useful step is making those differences visible before the rows get combined, not after.
- Leeds branch — “Location”
- Bristol branch — “Site”
- Derby branch — “Store”
Why branch reports drift apart
Each location edits its own copy of the report. Over time, someone adds a note column, renames a heading to match local language, or reorders fields without meaning any harm. None of it is wrong locally — it only becomes a problem the moment the files are combined.
Common questions
Do all branches need to use the same template?
It helps, but a consolidation process that only works when every file is identical will fail the first time one branch deviates — which they eventually will.
How can I consolidate spreadsheets without forcing everyone to use exactly the same template?
Agree the fields the combined report needs, then match each branch’s columns to them by heading rather than position. Tolerate harmless differences such as column order and capitalisation, keep extra columns visible, and review anything whose meaning is uncertain before it is merged.
How do I merge spreadsheets from multiple people?
Collect the files unchanged, find the real table in each one, line the columns up by heading, decide deliberately about differently named or missing columns, and add a Source File column so every row can be traced back to the person who sent it.
Collecting from several branches already?
Upload the branch files together. Headings that differ only in capitals, spaces, underscores or hyphens are matched automatically. Differently worded headings are combined only when you accept one of ConsoliSheet’s suggestions or combine them yourself, such as Site and Store into Location. Over five business columns, review and the preview stay free; you pay only for the complete file. Compare One-off and Pro
Try Quick Consolidate