Combine tables with Dataset Merge Tools
Bring CSV, TSV, spreadsheet, pasted table, JSON array, or JSONL data into Dataset Merger & Joiner. Append rows or join records by key, review applicable rows and conflicts, then export CSV, JSON, JSONL, or XLSX. The merge stays local in your browser, with no upload.
Choose append or a keyed join
Open Dataset Merger & Joiner when separate files or pasted tables need one result. It supports two operations:
- Append or union rows from multiple datasets. Column mapping and type coercion handle columns that do not line up exactly.
- Join records through a key with inner, left, right, or full joins. Duplicate-key and many-to-many policies handle repeated matches.
Review applicable rows and conflicts before exporting. The output formats are CSV, JSON, JSONL, and XLSX.
Bring together CSV, TSV, spreadsheet, and JSON data
Dataset Merger & Joiner accepts CSV and TSV files, spreadsheet data, pasted tables, JSON arrays, and JSONL datasets. You can combine data that started in different formats, then export it as CSV, JSON, JSONL, or XLSX.
Use append when the datasets contain the same kind of records and should become one longer collection. Column mapping connects differently named columns. Type coercion handles compatible values that arrive in different forms.
Join tables by a key
A keyed join connects records through a shared key. An inner join keeps applicable matches, while left, right, and full joins preserve different sides of the relationship. Duplicate-key and many-to-many policies handle keys that match more than one row.
Check rows and conflicts before export. You can inspect which rows apply and how overlapping data was treated before saving the combined result.
Examples of dataset merges
- Append two CSV exports with the same type of records into one dataset.
- Combine a pasted table with a JSON array, map the columns, and export JSONL.
- Join two datasets on a shared key, check duplicate matches and conflicts, and export XLSX.
Dataset Merge Tools and Dataset Tools
Use Dataset Tools to profile, clean, reshape, or generate tabular data. Use Dataset Merge Tools for append, union, or keyed join operations on input tables.
Frequently asked questions
How do I merge CSV files with these dataset merge tools?
Open Dataset Merger & Joiner and use the CSV inputs for an append or a keyed join. Review rows and conflicts, then export CSV, JSON, JSONL, or XLSX.
What is the difference between appending and joining datasets?
Appending or unioning adds rows together with column mapping and type coercion. Joining matches records through a key and offers inner, left, right, and full join choices.
Can I merge datasets without uploading them?
Yes. Dataset Merge Tools merge datasets locally in your browser, with no upload.
Which dataset tool should I start with?
Start with Dataset Merger & Joiner to combine tables or files. Choose Dataset Tools to profile, clean, reshape, or generate tabular data.