Standardize CSV Column Names & Order

Trim and case-normalise column names, then pick which columns to keep and in what order — so files from different sources line up.

Why this matters

When you merge tables from different sources, the headers never agree: "Email", " email ", and "E-Mail" should be one column, and the column order differs from file to file. Until the headers match, you can’t stack or join the tables.

Re-typing headers and dragging columns into order in a spreadsheet is tedious and error-prone, especially across many files that all need the same target shape.

TidyCSV trims and re-cases header names, and lets you select and reorder the columns you keep — so every file conforms to one template, ready to concatenate or import.

How to do it with TidyCSV

1. Load a CSV into TidyCSV.
2. Enable header standardisation — trim header names and apply lowercase or Title Case for consistency.
3. Choose which columns to keep and drag them into your target order.
4. Export the standardised CSV; repeat for each source file so they all share the same column layout.

Before & after

FAQ

Related