Focused result
Match rows from two datasets by key and append columns from the second source. Load both datasets, choose the left and right keys, then select the join type.
Match rows from two datasets by key and append columns from the second source. Use this private browser tool to join a second dataset to JSON, review the changed rows and export the result without uploading the dataset.
Choose types first, add the source, then review the result and canvas before saving.
Loading data workspace…
Quick Tool Overview
Match rows from two datasets by key and append columns from the second source. Load both datasets, choose the left and right keys, then select the join type.
Inspect detected fields, sample rows, result details and a canvas summary before downloading.
Files stay in this tab. Parsing, transformation and output creation do not require a server upload.
About the Tool
Match rows from two datasets by key and append columns from the second source. Use this private browser tool to join a second dataset to JSON, review the changed rows and export the result without uploading the dataset.
Match rows from two datasets by key and append columns from the second source. Load both datasets, choose the left and right keys, then select the join type. The workspace keeps source and result separate, so the original file remains unchanged.
Key Features
The source is read using rules specific to JSON.
Searchable rows, field names, inferred values and counts make mistakes easier to catch.
Download a fresh result only after the preview and exact result details look correct.
How to Use
Review the prominent source and target controls. Use them to open a different canonical conversion when needed.
Drop a file or paste text where supported. The page reads it in this browser tab.
Match rows from two datasets by key and append columns from the second source. Load both datasets, choose the left and right keys, then select the join type.
Check the result table, canvas, counts and format note, then download a new file.
Detailed Guidance
Match rows from two datasets by key and append columns from the second source. Start with a representative JSON sample and compare the source row count with the transformed result.
Load both datasets, choose the left and right keys, then select the join type. Review the changed field list before passing the JSON dataset to another application.
Review unmatched keys, duplicate keys and the resulting row count. Export a new file only after the table and canvas previews match the intended transformation.

Frequently Asked Questions
Yes. Both parsing and the field transformation run locally in the browser.
No. The tool creates a new result and never overwrites the selected source file.
Compare source and result row counts, inspect the field list and review sample rows before downloading.
Review unmatched keys, duplicate keys and the resulting row count. Nested arrays and objects are preserved as JSON cell values when flattened into a table.
Keep exploring
Continue with related free tools selected from this category and the wider directory.
Data ConversionMatch rows from two datasets by key and append columns from the second source. Use this private browser tool to join a second dataset to JSON Lines / NDJSON, review the changed rows and export the result without uploading the dataset.
Data ConversionMatch rows from two datasets by key and append columns from the second source. Use this private browser tool to join a second dataset to Apache Avro, review the changed rows and export the result without uploading the dataset.
Data ConversionMatch rows from two datasets by key and append columns from the second source. Use this private browser tool to join a second dataset to Apache ORC, review the changed rows and export the result without uploading the dataset.
Data ConversionMatch rows from two datasets by key and append columns from the second source. Use this private browser tool to join a second dataset to Apache Parquet, review the changed rows and export the result without uploading the dataset.
Data ConversionMatch rows from two datasets by key and append columns from the second source. Use this private browser tool to join a second dataset to CSV, review the changed rows and export the result without uploading the dataset.
Data ConversionMatch rows from two datasets by key and append columns from the second source. Use this private browser tool to join a second dataset to Excel 2007+ Workbook, review the changed rows and export the result without uploading the dataset.
Data ConversionMatch rows from two datasets by key and append columns from the second source. Use this private browser tool to join a second dataset to Excel 97–2003 Workbook, review the changed rows and export the result without uploading the dataset.
Data ConversionMatch rows from two datasets by key and append columns from the second source. Use this private browser tool to join a second dataset to Excel Binary Workbook, review the changed rows and export the result without uploading the dataset.
Data ConversionMatch rows from two datasets by key and append columns from the second source. Use this private browser tool to join a second dataset to JPEG Image, review the changed rows and export the result without uploading the dataset.
Data ConversionMatch rows from two datasets by key and append columns from the second source. Use this private browser tool to join a second dataset to OFX, review the changed rows and export the result without uploading the dataset.
Data ConversionMatch rows from two datasets by key and append columns from the second source. Use this private browser tool to join a second dataset to PDF, review the changed rows and export the result without uploading the dataset.
Data ConversionMatch rows from two datasets by key and append columns from the second source. Use this private browser tool to join a second dataset to PNG Image, review the changed rows and export the result without uploading the dataset.
Data ConversionMatch rows from two datasets by key and append columns from the second source. Use this private browser tool to join a second dataset to QuickBooks QBO, review the changed rows and export the result without uploading the dataset.
Data ConversionMatch rows from two datasets by key and append columns from the second source. Use this private browser tool to join a second dataset to Quicken QFX, review the changed rows and export the result without uploading the dataset.
Data ConversionMatch rows from two datasets by key and append columns from the second source. Use this private browser tool to join a second dataset to TSV, review the changed rows and export the result without uploading the dataset.
Data ConversionMatch rows from two datasets by key and append columns from the second source. Use this private browser tool to join a second dataset to WebP Image, review the changed rows and export the result without uploading the dataset.
Data ConversionMatch rows from two datasets by key and append columns from the second source. Use this private browser tool to join a second dataset to XML, review the changed rows and export the result without uploading the dataset.
Data ConversionStack compatible rows from two files and create a combined field set. Use this private browser tool to merge another dataset with JSON Lines / NDJSON, review the changed rows and export the result without uploading the dataset.
Data ConversionCreate one or more new columns without replacing the original values. Use this private browser tool to add calculated or constant fields to JSON, review the changed rows and export the result without uploading the dataset.
Data ConversionCreate one or more new columns without replacing the original values. Use this private browser tool to add calculated or constant fields to JSON Lines / NDJSON, review the changed rows and export the result without uploading the dataset.