Swap Columns

About the Swap Columns Tool

The Swap Columns tool by Mass Tools swaps two columns in delimited text or files. Paste text or upload TXT, CSV, or XLSX files for instant column swapping.

Why Use This Tool?

• Data Reorganization: Rearrange columns like names or values in lists.
• Data Formatting: Adjust column order for reporting or analysis.
• CSV/Excel Processing: Swap columns in structured data files.
• Batch Editing: Handle large datasets efficiently.

How to Use

• Paste text (e.g., "Collins, Maria Ann") or upload a TXT, CSV, or XLSX file.
• Enter the delimiter (e.g., ", " for comma and space).
• Specify the two column numbers to swap (e.g., 1 for surname, 2 for first name).
• Check "Trim Output" to remove extra spaces.
• Click "Swap Columns" to view results.
• Use "Undo" or "Redo" to revert or restore changes.
• Copy or download the modified text.
• Reset to clear inputs and results.

Tips

• Use files under 10MB for best performance.
• Ensure correct delimiter (e.g., ", " for comma-space, "," for comma).
• Combine with Extract Column or Concatenate Text for advanced workflows.
• Contact us at byrolaa@gmail.com for support.

Related Tools

• Split Text - Split text into individual columns or by a new line.
• Extract Column - Extract a specific column from delimited text.
• Concatenate Text - Combine or merge two lists/columns line by line.