Data & CSV

CSV group and concatenate

Collect text values into one ordered list per group.

CSV group and concatenate
Esc to restore

Your inputs

Up to 25 MB per file, 50,000 data rows, 200 columns and 2 million data cells. Fully blank rows and columns are ignored before row, column and cell limits are checked. Individual tools may have smaller result or chart limits.

Results update as you type. Larger files run when you press Update result.

Processed on your device

Your result

LOCAL & PRIVATE

Your result will appear here.

Your inputs stay in this browser. Nothing is uploaded or saved.

A clear answer. Here’s how.

Groups exact keys in first-seen order and concatenates target strings in input order. Optional uniqueness uses exact cell text; empty strings participate. Includes source row counts even when deduplicating values. This is a text aggregation, with ordinary result size/cell limits.

See a worked example

Worked example

A fixed demonstration, separate from the values you enter above.

Your CSV
ID,Name,Team,Amount,Date
001,Ada,Design,120,2026-01-05
002,Sam,Writing,80,2026-01-06
003,Jo,Design,150,2026-01-07
Column separator
Comma
Values to join
Name
Group column
Team
Join separator
,
Keep duplicate values
Keep every occurrence

Example result

Example result
GroupJoined valuesSource row count
DesignAda, Jo2
WritingSam1

Groups and values retain first-seen order. Empty values participate; distinctness uses exact strings.

Keep going.

CSV dataset diffCSV rule validatorCSV calculated columnCSV rank and percentile