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
.txtfile 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.
0and2to 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
.txtfile. - 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,ChicagoColumn A: 0
Column B: 2
Output:
Location,Age,Name
New York,30,Alice
Los Angeles,25,Bob
Chicago,35,CharlieCommon 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.