1. Upload all your files to the tool

You can always upload unlimited files under a total size of 1 MB. If you want to upload files that have a total size of over 1 MB, you can upgrade to a pro plan for just $4 per month.. With the pro plan, you can upload however big files you want.

2. Tool will merge automatically based on column names

The tool will automatically align columns with the same name. The name must be completely identical. Completely.

The sample of the how the final file will look will appear. It only shows the first row from each file so it might happen that the sample row appears blank.

3. Pick download options and download your combined excel file

You can pick two options and click Download to download the .xlsx file. You need to give the file a name before downloading.

Picking Remove Duplicates will keep the first row of identical duplicates from the merged file. This will be done automatically when you download. The example below is done manually just for example purposes.

Picking Add Source File Names will add a new column with the source file name and sheet name that a row comes from.

Additional Features

Change Column Names

1. Select which row the column names are on

Column names are not always on the first row of a file, if they even exist.

If they are on another row, then we need to tell the tool which row they are on. This can be done with the Start at Row option.

If there are no headers in the file, then you can check the Does File Have a Header? checkbox.

The columns will then be renamed in the format: [Filename]_[Column Number].
E.g., if [Filename] is Small-Demo-Data then column 1 will be renamed: Small-Demo-Data_1, column 2 will be: Small-Demo-Data_2...

These options can be selected in the Read File Options under File Options. If all the files need to be changed then you can click on Read All File Options over the sample.

2. Rename the columns

The merged columns can be renamed by clicking on the name.

This will show up in the Downloaded Merged File.

Move Columns

1. Change the column order from each file

Using the Detailed View you can actually change the order the columns append. You can click on the values and move them to another column in the same row.

This is extremely useful when the column names don't match up.

2. Change the order of the merged columns

You can change the order of the merged columns by clicking on the left and right buttons.

3. Remove merged columns

Simply click on the close button on the column

Move File Order

You can move the order in which the files appear by going into the File Options and clicking on Move File Up or Move File Down

Parting Thoughts

This is one way of merging spreadsheets. There are many other ways of combining excel files but we believe our tool is the easiest.

If you know Python, we have written another guide on Merging Spreadsheets with Python-Append on our blog at Medium.

1. Upload your files to the tool under the join tab

You can always upload unlimited files under a total size of 1 MB. If you want to upload files that have a total size of over 1 MB, you can upgrade to a pro plan for just $4. With the pro plan, you can upload however big files you want.

2. Select the Left file, Right file and Join Type

You need to select three things in order for the files to join

• Left File when merging spreadsheets all the values on the left side will come from this file
• Right File when merging spreadsheets all the values on the right side will come from this file
• Join Type is to select how the two excel files should be combined. It is a slightly advanced topic but nothing you can't wrap your head around with a few examples.
  
  

  There are 4 Join Types: Inner, Left, Right and Full. They all merge the file differently

  
  

  Read all about joins in our A Brief (yet Comprehensive) Introduction to SQL Joins

3. Select the column(s) you want to join on

Finally, you need to select the column(s) whose values you want to join on. You need to pick the column name for both the left and right files. You can pick as many columns as you want. The joining will be done on the values of all the columns selected.

4. Download your merged excel file

Give the file a name and download your merged and joined file.

Additional Features

Change Column Names

1. Select which row the column names are on

Column names are not always on the first row of a file, if they even exist.

If they are on another row, then we need to tell the tool which row they are on. This can be done with the Start at Row option.

If there are no headers in the file, then you can check the Does File Have a Header? checkbox.

The columns will then be renamed in the format: [Filename]_[Column Number].
E.g., if [Filename] is Small-Demo-Data then column 1 will be renamed: Small-Demo-Data_1, column 2 will be: Small-Demo-Data_2...

These options can be selected in the Read File Options under File Options.

Parting Thoughts

This is one way of joining spreadsheets. There are some other ways but we believe our tool is the easiest.

If you know Python, we have written another guide on Merging Spreadsheets with Python-Join on our blog at Medium.