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.
Your Recent Tools
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)
Why Use This Tool?
What problems does this solve?
Rearranging columns in CSV or tabular data without spreadsheet software is cumbersome. This tool swaps column positions instantly.
Common use cases:
- Reordering CSV columns for import requirements
- Swapping first/last name column order
- Rearranging data to match expected formats
Who benefits from this tool?
Data analysts rearranging columns. Developers formatting data. Anyone working with structured text without spreadsheet software.
Privacy first: All processing happens in your browser. Your data never leaves your device.
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...
Multi-Column Text
<p>Our Multi-Column Text Tool arranges text into newspaper-s...
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