Excel Sheet Merger

Purpose

This tool helps combine data from two Excel sheets by matching one or more columns and returning selected information from another sheet.

Key Features

• Exact Matching
• Partial Matching
• Fuzzy Matching
• Multiple Key Columns
• Duplicate Handling
• Inner Join
• Left Join
• Right Join
• Full Outer Join
• Excel Export

How To Use

1. Upload Excel Workbook (.xlsx, .xlsm, .xls or .csv)
2. Select Sheet 1 (Source Sheet)
3. Select Sheet 2 (Lookup Sheet)
4. Choose matching columns between both sheets
5. Select Match Type:
   • Exact
   • Partial
   • Fuzzy
6. Choose Duplicate Handling:
   • Return All Matches
   • First Match Only
7. Choose Merge Mode:
   • Inner Join
   • Left Join
   • Right Join
   • Full Outer Join
8. Select columns to return from Sheet 2
9. Click Run Merge
10. Review results and download output file

Example

The tool will match Vendor Code and return Vendor Name from Sheet 2.

Frequently Asked Questions

What is Exact Match?

Values must be identical.

What is Partial Match?

One value can contain another value.

What is Fuzzy Match?

Similar text values are matched even with minor spelling differences.

Can I use multiple columns?

Yes. You can match using 1, 2, 3 or custom number of columns.