Rainbow CSV plugins
A Vim plugin that highlights CSV/TSV columns in rainbow colors and provides an SQL-like query language (RBQL) for data manipulation.
What is Rainbow CSV plugins?
Rainbow CSV is a Vim plugin that provides syntax highlighting for CSV and TSV files, coloring each column differently to improve readability. It includes RBQL (Rainbow Query Language), an SQL-like engine for querying and transforming data directly within Vim, eliminating the need to switch to external data tools.
Vim and Neovim users who frequently work with CSV/TSV files, such as data analysts, developers, and system administrators needing to inspect or manipulate tabular data in the terminal.
It combines visual clarity with powerful data querying in a lightweight, dependency-free package, making it a versatile alternative to graphical CSV editors or command-line tools like csvkit.
Overview
🌈Rainbow CSV - Vim plugin: Highlight columns in CSV and TSV files and run queries in SQL-like language
Use Cases
Best For
- Quickly inspecting and navigating large CSV files in the terminal
- Running ad-hoc SQL-like queries on CSV data without leaving Vim
- Cleaning and transforming CSV data with Python or JavaScript expressions
- Highlighting columns in log files or other delimited text formats
- Checking CSV file consistency for quote usage and column counts
- Converting between CSV and TSV formats using RBQL queries
Not Ideal For
- Complex data analysis requiring multi-table JOINs beyond two tables
- Teams relying on graphical spreadsheet software like Excel or Google Sheets
- Files with hundreds of columns where rainbow highlighting becomes visually overwhelming
- Workflows needing real-time collaboration or cloud-based CSV editing
Pros & Cons
Pros
Automatically highlights CSV columns in different rainbow colors for improved readability, using a lightweight WYSIWYG approach that avoids computational overhead, as noted in the philosophy section.
Includes RBQL, an SQL-like language supporting SELECT and UPDATE queries with Python or JavaScript expressions, allowing data transformation directly within Vim without external tools.
Works with commas, tabs, semicolons, pipes, whitespace, and custom multi-character delimiters, and can highlight non-table files like logs or code, as shown in the commands and features.
Core functionality is written in pure vimscript with no additional libraries required, making installation straightforward and performance efficient out of the box.
Cons
RBQL only supports JOIN queries with exactly two tables and no nested queries, requiring consecutive queries for complex multi-table operations, which can be cumbersome.
For rfc_csv and rfc_semicolon dialects with multiline fields, syntax highlighting can go out of sync, requiring manual commands like ':syntax sync fromstart' to fix, and performance may degrade with large multiline ranges.
RBQL has non-standard limitations, such as not supporting aggregate functions inside expressions and requiring specific variable naming (e.g., a1, b1), which can confuse users familiar with traditional SQL.
Frequently Asked Questions
Related Projects
awk by example:zap: From finding text to search and replace, from sorting to beautifying text and more :art:
QSVBlazing-fast Data-Wrangling toolkit
ParaTextA library for reading text files over multiple cores.
graph-cliFlexible command line tool to create graphs from CSV data
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.