ConsoliSheetStandardising column names is not the same job as matching them. Matching decides that two spreadsheets are talking about the same field; standardising decides what to call it once everyone agrees.
Formatting differences
Examples“customer name ” vs “Customer Name”; trailing spaces; inconsistent capitalisation.
RuleNormalise automatically. No business meaning is at stake.
Plausible aliases
Examples“Client” and “Customer” may be equivalent; “Customer Name” and “Company” need separate checking.
RuleConfirm the meaning for this job; record reusable decisions in your own mapping log.
Different fields
Examples“Account” (a number) vs “Account Name”; “Net Cost” vs “List Price”.
RuleA similarity score is not proof of identical meaning.
Normalisation and mapping are different jobs
Turning “Customer Name ” into “customer name” is normalisation: mechanical, reversible, safe to automate completely. Deciding that “Client” and “Customer Name” refer to the same underlying field is mapping: a judgement call about business meaning, and judgement calls deserve a human the first time they come up.
Record mapping decisions for recurring work
For recurring reporting, keep a record of approved mappings outside the tool so the next month’s decisions are easier to review. ConsoliSheet’s accepted suggestions and manually combined headings currently apply to the active consolidation only; it does not yet remember aliases for future jobs.
Common questions
Should similar-looking headers be merged automatically?
Only when the similarity is purely formatting. Business-term differences deserve a one-off human check, not an automatic guess.
What is a target schema?
The agreed structure of your final dataset: the field names you want, and what each one is supposed to mean.
Does ConsoliSheet remember my column mappings for future jobs?
No. Suggested matches can be accepted and other headings can be combined manually for the current consolidation, but approved aliases are not saved for future jobs. Keep a separate mapping log if you repeat the process.
What happens when two columns look similar but don’t necessarily mean the same thing?
Treat them as different until someone who knows the data confirms otherwise. Compare a few sample values and the definitions behind them. Net Cost and List Price, or Revenue and Sales, can look interchangeable and still describe different figures.
Building a standard column list?
ConsoliSheet matches harmless heading-format differences automatically, offers selected possible synonyms for your approval and lets you map additional columns manually. Suggested matches are kept separate unless you accept them, and accepted aliases are not saved between jobs.
Try Quick Consolidate