Rainbow CSV
Last updated
Last updated
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.
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.
Access All Rainbow CSV features via the Command Panel in the Code IDE:
Mac: ⌘+Shift+P
Windows: Ctrl+Shift+P
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.
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:
