vex-tui

Project Overview

Vex is a terminal-based Excel and CSV editor with vim-style keybindings, live row filtering, instant data profiling, formula support, and chart export.

Key Features

• Live row filtering: Press f to filter any dataset with expressions (e.g., >1000, =Canada), Tab toggles column scope, Esc clears instantly
• Data profiling: Press W for a pandas.describe()-like column-by-column breakdown, auto-detects column types (number, text, mixed), shows non-null count, null count, unique values, Σ/avg/min/max
• Sorting: s ascending, S descending, u restores original order
• Freeze header: Ctrl+R pins the first row
• Live column statistics: Status bar auto-shows Σ/avg/min/max/n when cursor is on a numeric column
• CSV delimiter auto-detection: Supports , ; \t |, also specifiable manually
• Data visualization with chart export: Select a range with V, press v to open the chart viewer — bar chart, line chart, sparkline, pie chart; press p to export a PNG image
• 10 beautiful themes: Press t to switch live, all 256-color and truecolor

Target Audience

• Users who need to view and edit Excel/CSV in the terminal
• Developers and data analysts
• Users who like vim-style operation

Quick Start

# Open a CSV file
vex data.csv

# Specify delimiter
vex data.csv -d ';'
vex data.tsv -d '\t'
vex data.csv --delimiter '|'

Core Advantages

• Terminal-native, no GUI required
• Vim-style keybindings for efficient operation
• Live row filtering and data profiling
• Chart export for sharing as PNG images

System Requirements

• OS: Cross-platform (terminal environment)
• Additional dependencies: freeze required for chart export