How to join two Excel tables

Joining is where we take two Excel tables and merge the rows, side-by-side, using a common (‘key’) column. For example to turn:

Join Excel sheets

Into:

Joined Excel sheets

(You can also merge tables one on top of another)

Excel doesn’t really support joining. One option is to write some VBA script to do this for you. Another is to import the data into a database and do an SQL join. But both these are time-consuming and require technical skills.

However it is really easy in Easy Data Transform:

  1. Install Easy Data Transform on your PC or Mac, if you haven’t done so already. It will only take a minute. There is a fully fuctional free trial and you don’t have to give us your email or sign up to anything.
  2. Start Easy Data Transform.
  3. Drag the Excel spreadsheets you want to merge onto Easy Data Transform. A pink input item will be added for each sheet with data.
  4. Drag the input items into the order you want to stack them (one you want on the left, at the top).
  5. Select the two input items you wish to join using Ctrl+click (PC)/Cmd+click (Mac) (or dragging a box around them).
  6. Click the Join button in the left pane. A blue transform item is added and selected.
  7. Set the Top key column and Bottom key column to the common (‘key’) column (Easy Data transform may have already guessed them correctly).

Join two Excel sheets

The Excel tables are now joined with the top input item on the left of the table. Easy!

Note:

When you are happy with the results output the result into a new Excel spreadsheet or CSV file.

Join is just one of the 38 transforms that Easy Data Transform supports.

Try it free now!

Windows Logo Windows Download

v1.1.0 for Windows 10 / 8 / 7 (22 MB)

Apple Logo Mac Download

v1.1.0 for Mac 10.15 to 10.12 (21 MB)


Questions or problems?

Email support@easydatatransform.com


Do you have a question?
We would love to help.

This pop-up will not be shown again