sponsor Vim development Vim logo Vim Book Ad

rainbow_csv.vim : Highlight columns in csv/tsv files and run SELECT queries in SQL-like language

 script karma  Rating 45/18, Downloaded by 2219  Comments, bugs, improvements  Vim wiki

created by
Dmitry Ignatovich
script type
Rainbow CSV has 2 main features:

* Highlights csv columns in different rainbow colors.
* Provides SELECT and UPDATE queries in RBQL: SQL-like transprogramming query language.

Demonstration gif:

There are 2 ways to enable csv columns highlighting:
* CSV autodetection based on file content. File extension doesn't have to be .csv or .tsv
* Manual CSV delimiter selection with :RainbowDelim command (So you can use rainbow_csv for non-table files, e.g. to highlight function arguments in different colors)

To run an RBQL query either press F5 or enter the query in vim command line e.g. :Select a1, a2

More info can be found here: https://github.com/mechatroner/rainbow_csv
install details

rate this script Life Changing Helpful Unfulfilling 
script versions (upload new version)

Click on the package to download.

package script version date Vim version user release notes
rainbow_csv-master.zip 4.3.0 2019-11-12 7.3 Dmitry Ignatovich * Redesigned syntax logic: added support for conventional Vim filetypes
* Support newlines in CSV fields
* Support multicharacter separators
* Updated RBQL
* Bug fixes and usability improvements
rainbow_csv-master.zip 4.0 2018-06-04 7.3 Dmitry Ignatovich Usability improvements
rainbow_csv-master.zip 3.0 2017-10-30 7.3 Dmitry Ignatovich Correct handling of quoted commas; Built-in SQL-like RBQL query language which supports SELECT, TOP, WHERE, ORDER BY, UPDATE, JOIN and other keywords;
rainbow_csv-master.zip 2.0 2016-03-10 7.0 Dmitry Ignatovich Persistent settings for files. Added 'header' feature. See github page for more info.
rainbow_csv.zip 1.0 2013-05-25 7.3 Dmitry Ignatovich Initial upload
ip used for rating:

If you have questions or remarks about this site, visit the vimonline development pages. Please use this site responsibly.
Questions about Vim should go to the maillist. Help Bram help Uganda.