Text utilities

Select CSV Columns

Extract or reorder CSV columns using their column numbers.

Text stays in your browserCopy your result
Data workspace
Data workspace

Check delimiters and structure before downloading the output.

See the method

Your source data

Runs on your device

Your transformed data

Your result

Let’s calculate.

Use the Calculate button to see your result.

Your content is processed locally.

How to use this tool

  1. Enter csv with a header row, columns in output order.
  2. Select Update result to view the result.
  3. Check the method and assumptions below before using the result.

Input reference and sample values

Use the units and choices shown for each field. Sample values are provided for practice, not as recommendations.

InputFormat and unitsSample
CSV with a header rowKeep the structure and separators shown in the sample. Line breaks are retained in this input.name,score Ava,20 Ben,30 Ava,20
Columns in output orderEnter text using the format shown in the sample.2,1

Result for these sample inputs

score,name
20,Ava
30,Ben
20,Ava

Processed locally. Review the output before using it.

Select Try the example in the form to load these values and calculate them again. This replaces the current form inputs. Compare the result with the method and worked explanation below.

The method, explained

Select each numbered column for every row, including the header. Column numbering starts at one.

A WORKED EXAMPLE

Enter 2,1 to put score before name.

What to keep in mind

Invalid and duplicate column numbers are rejected. Original cell text is preserved.

Common questions

How does this tool handle my input?

Processing happens in your browser. Your pasted content is not uploaded, included in URLs or stored as a calculation history.

What input should I use?

CSV with a header row: use the example already shown, then replace it with your own content. Invalid and duplicate column numbers are rejected. Original cell text is preserved.

Methodology maintained by ClarityKit. How these tools are built and checked.