Align CSV Data into Readable Columns

Aligning CSV Data

Comma-separated values (CSV) are compact and machine-readable, but they are notoriously hard for humans to scan. When every field runs into the next with only a comma between them, it is easy to lose track of which value belongs to which column, especially with rows of varying lengths.

Before

Name,Age,City,Country
Alice,30,New York,USA
Bob,25,London,UK
Charlie,35,Tokyo,Japan

After (pipe-delimited, left-aligned)

Name    | Age | City     | Country
Alice   | 30  | New York | USA
Bob     | 25  | London   | UK
Charlie | 35  | Tokyo    | Japan

How It Works

1. Split on comma — each line is divided into cells wherever a comma appears.
2. Measure column widths — the tool scans every row and records the longest cell in each column position.
3. Pad cells — shorter cells receive trailing spaces (left-aligned) so that every cell in a column occupies the same width.
4. Join with output delimiter — the padded cells are reassembled using the chosen output delimiter (here, a pipe with surrounding spaces).

Tips

• If your CSV contains commas inside quoted fields, pre-process the data to use a different delimiter first.
• Right-align numeric columns (like Age) for easier comparison of values.
• Use the Trim whitespace option to strip any extra spaces that CSV exporters sometimes add around values.