# Rainbow CSV

Rainbow CSV is an extension designed to enhance CSV file readability and management. By providing color-coded column separation and various functionalities like autocompletion, delimiter detection, and query execution, this extension significantly improves data handling efficiency.

## Use cases

* **Data Exploration**: Quickly scan and understand the structure of large CSV files.
* **Data Quality & Cleaning**: Easily spot inconsistencies and efficiently edit columns using built-in functions.
* **dbt Development**: Enhance your ability to work with CSV sources and outputs in Paradime projects.
* **Collaborative Work**: Improve readability of shared CSV files among team members.

## Tutorial

{% @arcade/embed flowId="qyxGRiIKabKs0ikdrSY0" url="<https://app.arcade.software/share/qyxGRiIKabKs0ikdrSY0>" %}

{% hint style="info" %}
Access All Rainbow CSV features via the Command Panel in the Code IDE:

* Mac: ⌘+Shift+P
* Windows: Ctrl+Shift+P
  {% endhint %}

## Key Features

These functionalities, when used within Paradime, can significantly streamline your data preparation and analysis tasks, making your dbt development process more efficient and error-free.

| Feature                      | Description                                                                            | Usecase                                                     | Where to Find it                 |
| ---------------------------- | -------------------------------------------------------------------------------------- | ----------------------------------------------------------- | -------------------------------- |
| <h4>Set Header Line</h4>     | Designates the current line as the header                                              | Improves column identification while scrolling              | Command Panel                    |
| **Align CSV Columns**        | Visually aligns columns without modifying the original file                            | Enhances readability, making it easier to analyze data      | Command Panel or Status bar (UI) |
| **Set Rainbow Separator**    | Allows selection of predefined separators (comma, tab, semicolon, pipe) or custom ones | Adapts to various CSV formats, improving column distinction | Command Panel                    |
| **Edit Column Before/After** | Enables multi-cursor column editing                                                    | Facilitates efficient bulk edits in specific columns        | Command Panel                    |
| **CSVLint**                  | Automatically checks for consistency in quotes usage and field count                   | Helps maintain data integrity and spot formatting errors    | Status Bar (UI)                  |

***

Discover all Rainbow CSV features via the command panel:&#x20;

<figure><img src="https://2337193041-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FHET0AD04uHMgdeLAjptq%2Fuploads%2FBB9mNU1vEwYqPLpbRJEV%2FRainbow%20CSV%20commands.png?alt=media&#x26;token=4465804c-c9f9-46d8-a1ee-7a8d9b34c982" alt=""><figcaption><p>All available Rainbow CSV features</p></figcaption></figure>