Home

Inner Join Excel Files - Basic Version

File 1: All of file one's contents will be copied to the new file

File 2: Data will be copied to file 1 when there is a primary key match.

Images shown below illustrate how to files with common column (Primary Key) can be merged into one file. Be sure to set the "Primary Key Column" input field. Column A = 0.

Example: Excel File PO Report
Image of excel purchase order report
Fig 1 - Excel PO report with columns PO# and $ amount.
Example: Excel File Invoice Report
Image of excel invoice report
Fig 2 - Excel Invoice report with columns PO# and $ amount of PO and $ amount invoiced.
Example: PO and Invoice Report
Image of excel invoice report
Fig 3 - Excel PO and invoice reports side by side with primary key, PO #, highlighted.
Example: PO and Invoice Reports Joined
Image of excel report, a result of joining PO report (Fig 1) with Invoice report (Fig 2)
Fig 4 - A result of joining PO report (Fig 1) with Invoice report (Fig 2).