EmEditor’s CSV mode is a CSV editor that displays CSV (comma-separated values) and TSV (tab-separated values) files in a table format. EmEditor automatically detects if a file is a CSV or TSV file. CSV modes can be changed with theCSV toolbar.

Here are the features that EmEditor offers for CSV editing.

View CSV data

• Define custom CSV formats
• Freeze header
• Filter lines by column values

Edit CSV files

• Insert lines/columns
• Remove Embedded Newlines
• Convert CSV formats
• Combine Lines
• Combine/Split Columns
• Extract Columns
• Insert sequential numbers
• Copy a pattern
• Flash Fill
• Transpose
• Manage Columns

Data analysis

• Join CSV tables
• Delete Duplicate Lines
• Count common strings
• Pivot table
• Sort by line or by column value