Toggle Help Topics Menu >

Join Tables

The Join Tables tool lets you combine the columns from two tables (worksheet ranges) to create a new table.

Form Fields

  • Join Type:
  • Matching rows: Known as an SQL inner join, this option outputs only rows where there is a match between columns.
  • All table 1 items: Known as an SQL left outer join, this option outputs all of the table 1 fields and only the table 2 fields where the columns match.
  • All table 2 items: Known as an SQL right outer join, this option outputs all of the table 2 fields and only the table 1 fields where the columns match.
  • Table 1: Select the workbook, worksheet, and range where Table 1 is located. The "tables" do not have to be Excel tables - any range will work.
  • Table 2: Select the workbook, worksheet, and range where Table 1 is located.
  • Select Matching Columns: In the second step of the Join Tables dialog, you select the columns to match on between table 1 and table 2.
  • Ignore case for text matching: If checked, the text casing is ignored when comparing the fields in matching columns.
  • Select Output Columns: Select the columns that you want included in the output table.
  • Output To: You can output to a new worksheet (in the same workbook as Table 1) or to a new workbook.
  • Worksheet name: Optional field to name the output worksheet.