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.

“I liked how straight forward it was.”

Combine Tables

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.

Start Your Workspace

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.

Start Your Workspace