Column Swapper and Reorderer
Quick Tips
- • This tool runs entirely in your browser - your data stays private.
- • Press Ctrl+V (Cmd+V on Mac) to quickly paste text.
- • Use the Copy button to save your result to clipboard.
- • Bookmark this page for quick access!
Rearrange and swap columns in CSV and delimited data.
Examples
A,B,C 1,2,3
C,A,B 3,1,2 (order: 3,1,2)
First,Last,Email John,Doe,john@test.com
Email,First,Last john@test.com,John,Doe
a b c
c b a (reversed)
Frequently Asked Questions
Enter the column positions in your desired order, separated by commas. If you want columns 3, 1, 2 (move third column to first), enter "3,1,2". Column numbers start at 1 for the first column.
Yes, simply don't include unwanted column numbers. If you have 5 columns but only want columns 1, 3, and 5, enter "1,3,5". The output will only contain those columns in that order.
To swap columns 2 and 3 in a 4-column file, enter "1,3,2,4". This keeps columns 1 and 4 in place while swapping 2 and 3. List all columns with the two you want swapped in exchanged positions.
Yes, header rows are reordered along with the data. You can also choose to reference columns by header name instead of position number, making complex reordering more intuitive.
Yes, include a column number multiple times to duplicate it. "1,2,1,3" outputs column 1, then 2, then 1 again, then 3. This is useful when you need the same data in multiple positions.
Related Tools
Merge Columns
<p>Our Merge Columns tool combines multiple columns into a s...
List to CSV Row
<p>Our List to CSV converter transforms line-separated lists...
Split Text
<p>The <strong>Split Text Tool</strong> is an essential util...
Join Text
Join multiple lines into a single line with a custom delimit...
Extract Column
<p>The <strong>Extract Column Tool</strong> pulls specific c...
Related Articles
Create ASCII Tables from Data: Complete Generator Guide
Transform CSV and tabular data into professional ASCII tables for documentation, emails, and terminal output. Learn formatting options and best practices.
Read moreNatural Sorting Explained: Sort Text Like Humans Read Numbers
Discover how natural sorting handles numbers the way humans expect. Learn why file1, file2, file10 sort correctly with natural order algorithms.
Read moreExtract Unique Lines: Remove Duplicates from Text Efficiently
Learn how to extract unique lines and remove duplicates from any text. Essential techniques for data cleaning, list management, and text processing.
Read more