Swap Columns

About Swap Columns

The Swap Columns tool allows you to exchange the positions of two specific columns in a dataset. It handles CSV files, pipe-delimited text, or any custom list. This is extremely useful for reordering data (e.g., changing “First Name, Last Name” to “Last Name, First Name”) without using spreadsheet software.

Example

Input:

First Name, Last Name, Age
John, Doe, 30
Jane, Smith, 25

Settings: Swap Column 1 with Column 2 (Delimiter: ,)

Output:

Last Name, First Name, Age
Doe, John, 30
Smith, Jane, 25

How to Use

• Step 1: Paste your text data into the input field.
• Step 2: Set the Delimiter (usually a comma for CSVs).
• Step 3: Enter the numbers of the two columns you want to swap (e.g., 1 and 2).
• Step 4: Click “Swap Columns” and copy the result.

Who needs this?

This tool is widely used by Database Administrators formatting imports, Marketers adjusting mail merge lists, and Developers manipulating log files.

Related Tools

• Extract Column
• Split Text
• Concatenate Text