Join Tables
Join any number of tables by creating matching rules that will join rows into single table.
Join Tables
- Join any number of tables by creating matching rules that will join rows into single table.
- No need to write macros or use complicated formulas like VLOOKUP
- Simple Drag&Drop interface that utilizes full power of SQL behind the scenes.
- Export results and download them to your computer.
Drag & Drop interface
Simple and easy to use interface for creating powerful matching rules.
Connect rows
Join tables from different sheets or files and instantly see relations in your data.
“Much simpler than the other methods I attempted.”
Use Case: Merge Your Customers Records with Data from External Sources
What if the CRM software at your company doesn’t integrate with any existing customer survey service. With Gridoc, you can use your preferred customer survey service, and merge collected data with your existing CRM database using Join Tables feature.
Is this what I need?
Do you want to take values from cells in one sheet or file and add to rows in another?
For example, you have 3 spreadsheets, each containing a single worksheet:- The first has columns Order_Number, Order_Date, Item_Name.
- The second has columns Order number, Order status.
- The third has columns Item name, Inventory.
If this is what you need to do, use Join Rows:
- Create one matching rule for spreadsheet 1 & 2: Order_Number EQUALS Order number.
- Create one matching rule for spreadsheet 1 & 3: Item_Name EQUALS Item name.
Join Tables across Files
Join any number of tables by creating matching rules that will join them into single data table.
No need to write macros or use complicated formulas like VLOOKUP
Simple Drag&Drop interface that utilizes full power of SQL behind the scenes.
Export results and download them to your computer.
