Swap CSV Columns

Swap CSV Columns - Explanation & Examples

The Swap CSV Columns tool reorders the columns of a CSV, TSV, or custom-delimited file by letting you type the new column order as a simple list of column numbers. It also supports deleting columns (by leaving a number out) and duplicating columns (by listing a number more than once) — all processed instantly in your browser.

⭐ What Does This Tool Do?

• Parses your pasted CSV/TSV data, including quoted fields that contain the delimiter
• Reorders columns based on a comma-separated list of 1-based column numbers you type, such as 3,1,2
• Drops any column whose number you leave out of the list
• Duplicates any column you list more than once
• Shows a live preview table of the first 5 reordered rows
• Lets you copy the full result or download it as a file

🔎 Example: Simple Reorder

Input (columns A, B, C):

Name,Age,City
Alice,30,Paris
Bob,25,Berlin

Column order typed: 3,1,2

Output (columns C, A, B):

City,Name,Age
Paris,Alice,30
Berlin,Bob,25

🔎 Example: Delete and Duplicate a Column

Same input as above. Column order typed: 1,1

This drops column 2 (Age) and column 3 (City) entirely, and lists column 1 (Name) twice:

Name,Name
Alice,Alice
Bob,Bob

⚙️ How to Use the Tool

1. Paste your delimited data into the input box
2. Choose the delimiter used in your data (comma, tab, semicolon, pipe, or a custom character)
3. Type the new column order as 1-based numbers separated by commas, e.g. 3,1,2
4. Check the live preview table to confirm the result looks correct
5. Copy the full output or download it as a file

🔎 Supported CSV Parsing

The tool uses a lightweight CSV line parser that correctly handles double-quoted fields, including fields that contain the delimiter character or escaped double quotes ("") inside them. This covers the vast majority of real-world CSV and TSV files without requiring a full RFC 4180 parser.

⚠️ Important Notes

• Column numbers are 1-based — column 1 is the first column, not column 0
• "First row is header" only affects how the preview table displays the first row; it does not change which rows are included in the reordering or output
• Any column number not included in your column order list is simply dropped from the output, which is a quick way to delete unwanted columns
• Listing the same column number multiple times duplicates that column in the output
• All processing happens locally in your browser — your data is never uploaded to a server

This tool is also known as

• swap csv columns
• reorder csv columns
• delete csv column online
• rearrange csv columns
• csv column reorder tool