Waimao6

CSV · Split by column value

CSV · Split by column value. Use CSV · Split by column value on your input. Configure Table data, Column names / key columns (comma-separated) and inspect the result before copying it.

Processed locally · Files stay on your device

Text and transformation

Runs in this browser
Example data · Edit directly

Result

Set the inputs and run the tool to view the result.

How to use CSV · Split by column value

  1. Review the populated example and the input units, then replace it with your data.
  2. Use CSV · Split by column value on your input. Configure Table data, Column names / key columns (comma-separated) and inspect the result before copying it.
  3. Run the tool, inspect the result, then copy or download what you need.

Method and scope

Use CSV · Split by column value on your input. Configure Table data, Column names / key columns (comma-separated) and inspect the result before copying it.

Preserves data, not Excel macros, formula evaluation or styling. The first row is a header; names must be nonempty and unique. CSV export guards text beginning with = + - @ against formula injection. Prefer files below 20 MB.

Input example

Table data: SKU,Name,Quantity,Price
A01,Glass cup,100,12.5
A02,"Cup,Blue",80,15
A01,Glass cup,100,12.5
Column names / key columns (comma-separated): SKU

Questions and result checks

How does CSV · Split by column value determine the result?

Use CSV · Split by column value on your input. Configure Table data, Column names / key columns (comma-separated) and inspect the result before copying it.

What should I check before processing?

Preserves data, not Excel macros, formula evaluation or styling. The first row is a header; names must be nonempty and unique. CSV export guards text beginning with = + - @ against formula injection. Prefer files below 20 MB.

How can I verify the output?

Use the supplied example as a check, then compare important results with the original source or business document.

Table data: SKU,Name,Quantity,Price
A01,Glass cup,100,12.5
A02,"Cup,Blue",80,15
A01,Glass cup,100,12.5
Column names / key columns (comma-separated): SKU

Related tools