Skip to main content
The Code IDE includes Rainbow CSV for viewing and editing CSV files: color-coded columns, alignment, multi-cursor editing, and a CSV linter. It’s useful for cleaning data before you load it as a dbt™ seed.
Prerequisites
  • A dbt™ project set up in the IDE.
  • A .csv file in your project (drag one into the file tree if needed).
Estimated time: 10 minutes.

​
Steps

1

Turn on Rainbow CSV

Open a CSV file, then enable Rainbow CSV from the status bar at the bottom of the IDE. Columns become color-coded for easier reading.
A CSV file with Rainbow CSV color-coding enabled
2

Open the command panel

Press Cmd/Ctrl + Shift + P and type “Rainbow CSV” to see the available commands.
Rainbow CSV commands in the command panel
3

Use the commands

Columns are color-coded and aligned, and CSVLint flags any inconsistent rows. Run CSVLint before loading the file as a dbt™ seed to catch formatting issues early.

​
Next steps

Rainbow CSV integration

The full feature reference.

Managing seeds

Load CSVs into your warehouse as dbt™ seeds.

Related topics

Bulk CSV UploadRainbow CSVBolt Environment VariablesCode IDE Environment VariablesAgent Environment Variables