csvstack

Stack multiple CSV files

$ csvstack [file1.csv] [file2.csv] > [combined.csv]

$ csvstack -g [source1,source2] [file1.csv] [file2.csv]

$ csvstack -g [a,b] -n [source] [file1.csv] [file2.csv]

$ csvstack -H [file1.csv] [file2.csv]

$ csvstack -d ";" [file1.csv] [file2.csv]

csvstack [options] files...

csvstack concatenates multiple CSV files vertically (row-wise). Part of csvkit, it aligns columns by header name and can add a grouping column to track source files.
The tool handles files with different column orders by matching header names, making it robust for combining datasets from different sources.

-g names

Add grouping column with values.

Name for grouping column.

Inputs have no header row.

Use filenames as group values.

Field delimiter.

Quote character.

Input encoding.

All files should have matching columns for clean output. Missing columns filled with empty values. Part of csvkit, requires Python. Headers from first file used if different.

csvstack is part of csvkit, created by Christopher Groskopf in 2011. It simplifies combining multiple data files, a common task in data processing and analysis workflows.

csvcut(1), csvlook(1), cat(1), csvjoin(1)