PowerTrove
EN
Get PowerTrove

Data tools

Merge CSV Files

Combines rows from several CSV or TSV tables into one new CSV, matching columns by their headers.

Illustration · Several inputs, one result

At a glance

Input
Select at least two local CSV or TSV files in File Explorer.
Selection
At least 2 items
Result
Combines rows from several CSV or TSV tables into one new CSV, matching columns by their headers. Source files stay unchanged.
Before it runs
You see the options and a preview first.
Pack
Data tools · Included in the full edition

How it works

  1. Select at least two local CSV or TSV files in File Explorer.
  2. Press Alt + Space and type “Merge CSV Files”.
  3. Require identical headers or choose the union of columns to combine different table layouts.
  4. Start the action and check the result.

A practical example

Combine monthly exports into one table instead of pasting rows manually.

All actions in Data tools →
Convert CSV to JSONConverts rows from CSV or TSV into a new JSON file for use in scripts and data imports.Convert CSV to MarkdownTurns a CSV or TSV table into a Markdown table in a new .md file, ready for documentation.Convert CSV to SQLCreates a .sql file with INSERT statements from CSV or TSV data; it does not connect to a database.Convert CSV to Excel FileCreates an Excel workbook from each CSV or TSV file without requiring Microsoft Excel.Convert JSON to CSVConverts tabular JSON into a new CSV file that can be opened in spreadsheet software.Merge Text FilesJoins several text files into one new text file in natural filename order.