Table of Contents
CSV & TSV Viewer
CodeDB includes a built-in CSV and TSV viewer that renders tabular data as an interactive table with virtual scrolling for large datasets.
Opening CSV/TSV Files
When you open a .csv or .tsv file, CodeDB automatically shows it in Table view instead of the raw text editor. The viewer detects the delimiter based on file extension:
.csvfiles use comma (,) as delimiter.tsvfiles use tab as delimiter
View Modes
Three view modes are available via the toolbar at the top of the editor:
| Mode | Description |
|---|---|
| Table | Renders data as a formatted, scrollable table with headers |
| Raw | Shows the raw text in the Monaco code editor |
| Edit | Opens the text in Monaco for editing; switching back to Table re-parses the content |
Default View Mode
You can set the default view mode in Settings (⌘,). Options:
- Table (default) — opens CSV/TSV files in table view
- Raw — opens in the text editor
- Edit — opens in editable text mode
Column Coloring
CodeDB can color-code table columns for easier reading. Configure this in Settings:
| Setting | Effect |
|---|---|
| Off | No column coloring |
| Headers Only (default) | Column headers get distinct background colors |
| Full Columns | Both headers and data cells get subtle alternating color tints |
Eight distinct color hues cycle across columns for visual differentiation.
Virtual Scrolling
The CSV viewer uses virtual scrolling to handle large datasets efficiently. Files with 100,000+ rows render smoothly because only visible rows are added to the DOM.
- Scroll normally — rows render on demand
- The info bar shows total row and column counts
- Import supports files up to 50 MB
Editing CSV Data
- Switch to Edit mode using the toolbar
- Modify the raw text in the Monaco editor
- Switch back to Table mode to see the updated table
- Changes are automatically saved to the database
Tip: The file content is the single source of truth. Edits in Raw or Edit mode are reflected when you switch back to Table view.
