This tool swaps the positions of two columns in a block of delimited text. You can choose the column indexes, define your own input and output delimiters, and instantly preview the modified output. It’s designed for quick column reordering in CSV, TSV, or custom formats.
How to Use:
- Paste your delimited text into the input box or import a
.txt
file using the Choose File button. - In the Options section:
- Set the Input Delimiter used to split values (e.g.
,
,|
,TAB
). - Enter the index of Column A and Column B (e.g.
0
and2
to swap first and third columns). - Set the Output Delimiter for the result.
- Set the Input Delimiter used to split values (e.g.
- The swapped output appears instantly on the right.
- Use Copy Output to copy the result to your clipboard.
- Use Export to File to download the result as a
.txt
file. - Click Clear All to reset the input, output, and options.
Example:
Input:
Name,Age,Location
Alice,30,New York
Bob,25,Los Angeles
Charlie,35,Chicago
Column A: 0
Column B: 2
Output:
Location,Age,Name
New York,30,Alice
Los Angeles,25,Bob
Chicago,35,Charlie
Common Use Cases:
Use the Text Column Swapper Tool to correct column order in structured data, prepare files for import into systems with strict column arrangements, or quickly reorganize values without opening spreadsheet software. It’s ideal for quick transformations of CSV, TSV, and other delimited formats.
Useful Tools & Suggestions:
If you’re rearranging columns, Text Column Delimiter Changer is a handy prep step it makes sure you’re working with clean, consistent breaks between columns. And once everything’s in place, Convert Text Columns to CSV lets you export the updated structure into a more portable format.