Does this sort the rows of data, or the columns?

Only the columns; every column, along with all of its data, is moved into alphabetical order by its header name. Row order never changes.

What sort order does ascending use?

Standard string comparison (locale-aware `localeCompare`) on the header names, A to Z; descending reverses that order, Z to A.

What happens to a column's data when it moves?

The header cell and every data-row cell in that column travel together as a unit; only the column's position changes, not its content.

Is this the right tool if only two columns are out of order?

CSV Column Swapper is usually simpler for exchanging just two specific columns; this tool reorders every column at once by name.

Does capitalization affect the sort order?

Sorting uses `localeCompare`, which generally orders case-insensitively for the same letter before falling back to case as a tiebreaker, matching typical alphabetical expectations.

Can I sort by something other than the header name, like column content?

No, this tool sorts strictly by header text; use CSV Row Sorter if you want to reorder rows by a column's data values instead.

CSV Column Sorter - Reorder Columns by Header

Overview

Introduction

A CSV assembled from several sources or an ad hoc export often ends up with columns in an arbitrary, inconsistent order. Alphabetizing them by header name gives every version of the file a predictable, comparable layout.

This tool reorders the columns themselves, leaving the data rows exactly as they were, row for row.

What Is CSV Column Sorter?

A structural CSV tool that sorts columns alphabetically by their header name, ascending or descending, moving each column's data along with its header.

It's purely a column reordering: no cell values change, no rows are added or removed, and row order stays identical.

How CSV Column Sorter Works

The input is parsed and padded to a uniform grid, then the header row is used to compute a new column order via `localeCompare`, ascending or descending as chosen.

Every row is then rebuilt by picking its cells out in that new column order, and the result is re-serialized back into CSV text.

When To Use CSV Column Sorter

Use it to give merged or inconsistent exports a predictable, alphabetical column layout before sharing or diffing them.

It's also useful for quickly finding a specific column by name in a very wide CSV, once sorted, related columns tend to cluster together alphabetically.

Often used alongside CSV Column Swapper, CSV Column Rotator and CSV Row Sorter.

Features

Advantages

Reorders every column in one pass instead of requiring several manual swaps.
Keeps row order and cell contents completely intact, only column position changes.
Offers both ascending and descending alphabetical order via a simple toggle.

Limitations

Sorting is based purely on header text; there's no way to sort by column content or a custom order with this tool.
Duplicate header names sort next to each other but their relative order between duplicates follows the underlying sort's stability, not a separate tiebreaker.

Examples

Sorting columns alphabetically

Input

zip,name,age
10001,Ada,36
94105,Alan,41

Output

age,name,zip
36,Ada,10001
41,Alan,94105

Columns are reordered to "age, name, zip" alphabetically; each row's values move with their original header.

Best Practices & Notes

Best Practices

Sort columns alphabetically before diffing two CSV exports, so differences in column order don't show up as false differences in content.
Use CSV Column Swapper instead when only a couple of specific columns need to trade places, it's a lighter touch than a full alphabetical resort.
Rename ambiguous or inconsistent headers with CSV Column Renamer before sorting, so the alphabetical order groups related fields sensibly.

Developer Notes

Builds a `{ name, index }` pair per header cell, sorts that array by `localeCompare` (or its negation for descending), then remaps every row through the resulting index order; this keeps the sort stable and independent of the underlying cell values.

CSV Column Sorter Use Cases

Giving merged or multi-source CSV exports a consistent, predictable column order
Making a wide CSV easier to scan by grouping alphabetically similar column names together
Normalizing column order before running a diff between two versions of the same dataset

Common Mistakes

Expecting row data to be sorted; this tool only reorders columns, not rows.
Assuming numeric-looking header names sort numerically; they're compared as plain text, so "10" sorts before "2".

Tips

If you only need two columns swapped, CSV Column Swapper is a faster, more targeted alternative to a full alphabetical resort.
Combine with CSV Row Sorter if both column order and row order need normalizing for a clean comparison.

CSV Column Sorter