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.”
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.
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 |