Tabiew: A TUI for Viewing and Querying CSV, TSV, JSON, SQLite, and More

Tabiew is a lightweight TUI application that allows users to view and query tabular data files, such as CSV, Parquet, Arrow, and ...

• ⌨️ Vim-style keybindings
• 🛠️ SQL support
• 📊 Support for CSV, Parquet, JSON, JSONL, Arrow, FWF, Sqlite, and Excel
• 🔍 Fuzzy search
• 📝 Scripting support
• 🗂️ Multi-table functionality

Tabiew started as a humble hobby TUI project for viewing CSV data but has evolved to incorporate various features and improvements from valuable community feedbacks. As the project expanded, so did the need for comprehensive documentation, leading to the creation of the wiki page. The wiki offers explanations of features and the best practices to get the most out of Tabiew.

There are various ways to install Tabiew:

You can install from the official repositories using pacman:

Download the .deb package from the GitHub releases page and run:

Download the .rpm package from the GitHub releases page and run:

Installing Tabiew using Homebrew from Homebrew core:

or tap:

Note: Please be aware that installing Tabiew from the tap involves compiling it from the source, which may take some time to complete.

Installing Tabiew from Crates.io:

Ensure you have rustc version 1.80 (or higher) installed. Download the desired source version from the release page. Extract the downloaded file and navigate into the extracted directory. Then run the following command:

Start Tabiew with tw

To open TSV file(s), use:

To open parquet file(s), use:

To open a URL, use curl to pipe the output directly to Tabiew:

Key Combination Functionality

Enter	Open sheet
h j k l or ← ↓ ↑ →	Navigation
b / w	Previous / next column
e	Toggle Auto-Fit
Ctrl + u / Ctrl + d	Move half page up/down
Home or g	Move to first row
End or G	Move to last row
Ctrl + r	Reset data frame
q	Close
:	Command Pallete
/	Fuzzy Search

Command Example Description

Q or query	Q SELECT * FROM df	Query the data in Structured Query Language(SQL). The table name is the file name without extension
S or select	S price, area, bedrooms, parking	Query current data frame for columns/functions
F or filter	F price < 20000 AND bedrooms > 4	Filter current data frame, keeping rows were the condition(s) match
O or order	O area	Sort current data frame by column(s)
tabn	tabn SELECT * FORM user WHERE balance > 1000	Create a new tab with the given query
q or quit	q	Return to table from sheet view otherwise quit
schema	schema	Show loaded data frame(s) alongside their path(s)
reset	reset	Reset the table to the original data frame
help	help	Show help menu

Contributions are welcome! Please fork the repository and submit pull requests with your features and bug fixes.

This project is licensed under the MIT License - see the LICENSE file for details.