How to combine Excel sheets

Stacking is where we want to take two or more Excel sheets and combine the columns, one on top of the other. For example to turn:

Merge Excel sheet

Merge

Merge Excel sheet

Into:

Merged Excel sheet

(You can also merge sheets side-by-side using a common ‘key’ column)

Obviously it is easy enough to do the simple example above in Excel using copy and paste. But that becomes a tedious and error prone if there are multiple large tables. And it becomes a real headache if the columns are not identical in the two tables.

However it is trivial to do 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 vertical the order you want to stack them (the top one at the top).
  5. Select the two or more input items you wish to stack using Ctrl+click (PC)/Cmd+click (Mac) (or by dragging a box around them).
  6. Click the Stack button in the left pane. A blue transform item is added.

Combine Excel sheets

The Excel tables are now stacked in the vertical order shown on screen. Swap the vertical order of the input items to change the stacking order.

If you want to stack column N of the first table above column N of the second table (regardless of column name), set Align columns by to Column number.

Align columns by number

If you want to stack columns by common column header names (even if the columns aren’t in the same order), set Align columns by to Header name. Matching is sensitive to case and white space.

Align columns by header name

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

Stack is just one of the 42 transforms that Easy Data Transform supports.

Try it free now!

Windows Logo Windows Download

v1.3.0 for Windows 10 / 8 / 7 (23 MB)

Apple Logo Mac Download

v1.3.0 for Mac 10.15 to 10.12 (22 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