Reverse Column Order in CSV Data

Reversing CSV Column Order

Reversing column order in CSV data is a practical application of word reversal where the delimiter is a comma instead of a space. This is useful when you need to restructure data exports.

Basic Approach

Each row of CSV data can be treated as a line where "words" are separated by commas:

Input:
  Name,Age,City,Country
  Alice,30,Tokyo,Japan
  Bob,25,London,UK

Output:
  Country,City,Age,Name
  Japan,Tokyo,30,Alice
  UK,London,25,Bob

Implementation

function reverseCsvColumns(csv) {
  return csv
    .split("\n")
    .map(line => line.split(",").reverse().join(","))
    .join("\n");
}

Handling Quoted Fields

Real CSV data often contains quoted fields with commas inside:

Name,Address,City
"Smith, John","123 Main St, Apt 4",London

A naive split on commas would break quoted fields. You need a proper CSV parser to handle this correctly.

Selective Column Reversal

Sometimes you want to reverse only the data columns while keeping a key column in place:

Input:  ID,Col1,Col2,Col3
Output: ID,Col3,Col2,Col1

When to Use Column Reversal

• Report reformatting: Moving the most important columns to the left
• Data export preparation: Matching the column order expected by an import tool
• Spreadsheet preparation: Reorganizing data before sharing
• ETL pipelines: Transforming data layout between systems

Combining with Line Reversal

You can combine column reversal with line reversal to completely mirror a dataset:

Original:    A,B,C     Columns reversed: C,B,A
             1,2,3                        3,2,1
             4,5,6                        6,5,4

Lines also reversed: 6,5,4
                      3,2,1
                      C,B,A