ConsoliSheet

How to Combine Excel Files From Multiple Suppliers

Supplier data rarely arrives in one perfect format. One supplier may send SKU and Unit Cost, another Product Code and Price, while a third adds fields that nobody else supplies.

Quick answerDefine the fields your business actually needs, map each supplier’s terminology to that target schema, preserve supplier-specific gaps rather than shifting data, and flag ambiguous fields for review before creating the combined dataset.

Here is what that looks like in practice. Three suppliers, three spreadsheets, three different names for the same underlying information:

Supplier A

SKU Product Wholesale Price Stock
1 ABC-1001 Steel Bracket £2.40 340
2 ABC-1002 Wall Fixing £0.85 1,200

Supplier B

Product Code Description Trade Price Qty Available
1 BR-204 Steel Bracket, 40mm 2.25 510
2 WF-118 Wall Fixing Set 0.90 75

Supplier C

Item ID Product Name Cost Inventory
1 9981 Steel Bracket 2.60 90
2 9982 Wall Fixing 0.88 640

None of these files is wrong. Each supplier is describing the same products through its own system. The task is deciding that Product Code, Item ID and SKU mean the same thing, while noticing that Trade Price, Cost and Wholesale Price do not necessarily mean the same thing.

  • Product Code (Supplier B)
  • Item ID (Supplier C)
  • SKU (Supplier A)

SKU

Doing this once, for one order, is manageable by eye. Doing it every week across twenty supplier files is where the manual process becomes the bottleneck rather than the ordering itself.

Why supplier spreadsheets are difficult to combine

Each supplier controls its own systems and vocabulary. Forcing every external party to change their export may be impractical. The consolidation layer therefore needs to separate harmless naming differences from genuinely different data.

Important: Similar labels do not necessarily have the same meaning. Unit Cost, List Price and Net Cost, for example, may represent different commercial values.

The main ways to combine supplier files

Method Best when Watch out for
Copy and paste You have a very small, one-off job. Manual errors and poor repeatability.
Excel Consolidate You want to summarise values such as totals or averages. It is not the same as appending every source row.
Power Query You have a repeatable process and can configure transformations. Inconsistent schemas require additional transformation work.
ConsoliSheet You receive files whose headings or structures need matching and review. Ambiguous mappings should still be checked by a human.

A reliable supplier-data workflow

1. Define your master fields. Use your organisation’s terminology rather than adopting one supplier’s structure.
2. Map supplier headings. Record clear equivalents where they genuinely mean the same thing.
3. Check units and meaning. Similar wording does not guarantee equivalent values.
4. Preserve missing data honestly. Do not populate a field from an unrelated source column.
5. Add provenance. Retain supplier or source-file information for investigation.

Common questions

Do all suppliers need to use the same template?

No. Consistent templates make consolidation easier, but mapping can bridge structural differences between supplier exports.

Can I combine XLSX and CSV supplier files?

Yes, provided the consolidation workflow supports both formats and validates their structures.

What if two supplier fields sound similar but mean different things?

Treat the mapping as ambiguous and review it. Similar wording alone is not sufficient evidence that two business fields are equivalent.

Have spreadsheets like these?

ConsoliSheet is built for files that need to become one clean dataset. Upload your Excel or CSV files, review how the columns have been matched, then create a consolidated workbook.

Try Quick Consolidate

Further reading: Microsoft documents Excel Consolidate and Power Query as different approaches to working with data from multiple sources. Always check current Microsoft documentation for features available in your version of Excel.

Where it gets difficult

The difficult part is that every supplier is different, on purpose

Suppliers will not change their export format for you. Column names, units and even what counts as “cost” can vary from one supplier to the next.

That is the point where a process that looks like a simple Excel task starts consuming time in checking, remapping and correcting spreadsheets.

THE CONSOLISHEET APPROACH
Supplier A
Supplier B
Supplier C

ConsoliSheet
Match columns
Flag differences
Review decisions
ONE CLEAN OUTPUT
One supplier master list

Where ConsoliSheet fits

When the spreadsheet structure is the problem

ConsoliSheet is built for files from parties you do not control, using terminology you do not control.

Upload each supplier’s file, review how their columns map to your fields, and export one supplier dataset with every row traceable to its source.


Try it with your spreadsheets →


Every spreadsheet. One clean dataset.

Stop fixing the spreadsheets before you can use the data

Upload the Excel or CSV files you need to combine.
ConsoliSheet matches the columns, flags the differences
and gives you one clean consolidated output.

Free for up to 5 business columns. No account needed.


Consolidate spreadsheets free →