⇄
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.