Merge and combine multiple datasets with join operations and relationship mapping
Upload multiple datasets and combine them with various join operations
Drag & drop multiple CSV or JSON files here, or click to select
You can upload multiple files at once to merge them together
No datasets uploaded yet
Upload at least 2 datasets to start merging
A data merger tool combines multiple datasets into a single unified dataset. This tool supports various join operations (inner, left, right, full, union) similar to SQL database joins. Upload your CSV or JSON files, select join keys for matching records, choose your join type, and the tool will merge the data according to your specifications.
The tool supports five join types: Inner Join (only matching records from both datasets), Left Join (all records from left dataset), Right Join (all records from right dataset), Full Join (all records from both datasets), and Union (combine all records without requiring join keys). Each join type serves different data merging needs.
The tool automatically handles datasets with different columns. When merging, select join keys (matching columns) from each dataset. The merged result includes all columns from both datasets. If column names conflict, the tool appends '_right' to duplicate column names from the right dataset to avoid conflicts.
For Union operations, you can merge unlimited datasets as they simply stack all records together. For join operations (inner, left, right, full), you can merge exactly two datasets at a time. To merge multiple datasets with joins, perform sequential merge operations by first merging two datasets, then merging the result with a third dataset.
The tool offers three duplicate handling options: Keep All (preserves all duplicate rows), Remove (eliminates exact duplicate rows from the merged result), and Merge (intelligently combines duplicate data). Choose the option that best fits your data analysis needs before merging.
The data merger supports CSV (Comma-Separated Values) and JSON (JavaScript Object Notation) file formats. You can mix formats - for example, merge a CSV file with a JSON file. Both formats are parsed automatically, and the data is normalized for merging regardless of the original format.
Absolutely! All data merging operations are performed entirely in your browser using client-side JavaScript. No files are uploaded to any server, and no data is transmitted anywhere. Your datasets remain completely private and secure on your local device throughout the entire merge process.
Yes! After merging your datasets, you can download the results as a CSV file by clicking the Download button. You can also copy the merged data to your clipboard for pasting into other applications. The exported file includes all columns from the merged result with proper formatting.