# 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>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.paradime.io/app-help/documentation/integrations/code-ide/rainbow-csv.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.