Powerful CSV Tools

EmEditor’s CSV mode is a CSV editor that displays a CSV (comma-separated values) file in a table format. When .csv and .tsv files are opened, CSV mode is activated automatically. CSV modes can be changed with the CSV 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