# Working with CSV Files

In this guide, you'll learn how to effectively work with CSV files in Paradime using the integrated Rainbow CSV feature. This tool enhances your ability to view, edit, and analyze CSV data directly within the Paradime IDE.

**Estimated completion time:** 10 minutes

{% hint style="warning" %}

### Prerequisites

* [A dbt™ project set up in Paradime](https://docs.paradime.io/app-help/guides/paradime-101/getting-started-with-the-paradime-ide/setting-up-a-dbt-project)
* A .csv file to import into your dbt™ project
  {% endhint %}

### What You'll Learn

In this guide, you'll learn how to:

1. Access Rainbow CSV features
2. Align CSV columns
3. Perform multi-cursor editing
4. Set header lines
5. Customize separators
6. Use CSVLint for data quality checks

***

### Tutorial

{% embed url="<https://youtu.be/QwyjmL2BT2Q>" %}

### Key Features

* Automatic Color Coordination: CSV columns are color-coded for easy reading.
* CSV Column Alignment: Visually align columns for better organization.
* Multi-cursor Column Editing: Efficiently make bulk edits across columns.
* Header Line Freezing: Keep column names visible while scrolling.
* Customizable Separators: Choose how columns should be distinguished.
* CSVLint: Check for consistency in quotes usage and field count.

### How to Use

#### 1. Launch Rainbow CSV (H3)

1. If you don't already have a .csv file in your project, drag one into your project's repository.
2. Open a CSV file in the Paradime IDE.
3. In the status bar at the bottom of the IDE, turn on Rainbow CSV.

<figure><img src="https://2337193041-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FHET0AD04uHMgdeLAjptq%2Fuploads%2FTgJpkcYmevodEanKR6TD%2Fimage.png?alt=media&#x26;token=6aa1a41c-332c-43e6-96f8-2cc75c878d12" alt=""><figcaption></figcaption></figure>

4. Open the Command Panel:

* On Mac: Press `⌘` + `Shift` + `P`
* On Windows: Press `Ctrl` + `Shift` + `P`

#### 2. Access the Commands Panel&#x20;

To access all Rainbow CSV commands:

1. Open the Command Panel
2. Type "Rainbow CSV"
3. You'll see a list of available commands:

<figure><img src="https://2337193041-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FHET0AD04uHMgdeLAjptq%2Fuploads%2F0pZggm5SRBnMcM8jlhsZ%2Fimage.png?alt=media&#x26;token=ac254ab6-85b6-4a67-a989-d1951de38d78" alt=""><figcaption></figcaption></figure>

#### 3. Utilize Rainbow CSV Commands&#x20;

Here are some key Rainbow CSV commands you can use:\ <br>

| Command                      | Description                                                                            | Use case                                                    | Where to Find it                 |
| ---------------------------- | -------------------------------------------------------------------------------------- | ----------------------------------------------------------- | -------------------------------- |
| **Set Header Line**          | 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:

{% hint style="success" %}

### Pro Tips

* Use Rainbow CSV for quick data quality checks before importing into your dbt™ models.
* Leverage multi-cursor editing for rapid data cleaning tasks.
* Combine Rainbow CSV with dbt™ seeds for efficient data loading and version control.
* Use CSVLint regularly to catch formatting issues early in your data pipeline.
  {% endhint %}

***

{% hint style="info" %}

### Related Documentation

* [Rainbow CSV](https://docs.paradime.io/app-help/documentation/integrations/code-ide/rainbow-csv)
  {% endhint %}

***

### Summary

You've learned how to effectively work with CSV files in Paradime using the Rainbow CSV feature. This tool enhances your ability to view, edit, and analyze CSV data directly within the Paradime IDE, improving your data handling capabilities and workflow efficiency.\
\
Next, we'll explore[ how to run dbt™ in production with Bolt](https://docs.paradime.io/app-help/guides/paradime-101/running-dbt-in-production-with-bolt).


---

# 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/guides/paradime-101/getting-started-with-the-paradime-ide/utilizing-advanced-developer-features/working-with-csv-files.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.