Column Tools help

Column Tools reshapes delimited text by column. Choose which columns to keep and in what order, drop some, add a blank one, or convert between commas, tabs, and semicolons.

Steps

  1. Paste your delimited text and set the delimiter.
  2. Enter a column spec like 1,3,2 or 2-4, and pick an action.
  3. Copy the result.

Common questions

How do I write the column spec?

A comma-separated list of 1-based positions, with ranges like 2-4 and negative numbers counting from the end, so -1 is the last column.

Does it keep quotes?

It re-quotes any field that needs it for the output delimiter, and leaves the rest bare.

Can it change a comma file to tabs?

Yes. Set the input delimiter, choose the output delimiter, and use the swap action.

Does anything leave my browser?

No. The tool runs entirely on this page.

Everything runs in your browser. Nothing you enter or drop is uploaded.

Back to Column Tools