Combine Tables

  • Add all rows from separate files into a single table (concatenating the sheets into one)
  • Add all rows from separate files, with differing columns, into a single master table with consistent columns


merge any number of files

Upload and combine any number of CSV or Excel files.

get results in real time

Have your files merged in minutes and export results quickly.

Combine Tables

Is this what I need?

Do you need to add all rows from separate files into a single table?

For example, you have 3 spreadsheets, each containing a single worksheet with columns OrderNumber, OrderDate, Item, Units, Ship Mode. Each spreadsheet has this column structure and you’d like to concatenate these together into just one sheet in one spreadsheet. If this is what you need to do, Combine Tables can help you achieve it.

Do you need to add all rows from separate files, with differing columns, into a single spreadsheet with consistent columns?

For example, you have 3 spreadsheets, each containing a single worksheet:
  • The first has columns Region, Item, Units, Ship_Mode, Order_Number, Order_Date.
  • The second has columns Order_Number, Order_Date, Region, Item, Units, Unit_Cost, Total.
  • The third has columns Order_Number, Units, Unit_Cost, Total, Order_Date, Region, Item.
Here, you’d like to merge the data from each spreadsheet into just one sheet in one spreadsheet with the same set of columns: Order_Number, Order_Date, Region, Item, Units, Unit_Cost, Total, Ship_Mode. If this is what you need to do, Combine Tables should help you achieve it.

You can merge any number of files.

How it works?

Example – Combine 3 files

File #1
  • contains all columns
  • rows contain complete data
File #2
  • contains all columns
  • ID column is missing values
File #3
  • missing Username column
  • existing columns contain complete data
ID First Name Last Name Username
1 Peter Sanchez @hellop
2 Maria Livingston @living
ID First Name Last Name Username
  Mark Otto @mdo
  Jacob Thornton @thor
ID First Name Last Name
5 Joe Smith
6 Jane Johnson
Result:
  • Data from all 3 files are correctly aligned into columns.
  • Missing values or columns are properly handled.
ID First Name Last Name Username
1 Peter Sanchez @hellop
2 Maria Livingston @living
  Mark Otto @mdo
  Jacob Thornton @thor
5 Joe Smith
6 Jane Johnson

Have your files merged in minutes and export results quickly.