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

“I liked how straight forward it was.”

Use Case: Blend Data from different Sources into Single Master Table

Several contractors are doing market research for your company. Even though you specified the required format of data, each contractor provides you with slightly different order of columns in their report spreadsheets. With Gridoc, you can merge these spreadsheets into single table using Combine Tables feature that will correctly identify and align columns from different files, sparing you from error-prone manual copy&pasting and fixing the data.

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.