Hello CSV (VS Code Extension)

A fast, interactive, and theme-aware CSV & TSV tabular viewer and in-place editor for Visual Studio Code.

🌟 Features

1. In-Place Cell Editing & Spreadsheet Controls

• Direct Cell Editing: Double-click any cell, or select it and press Enter or F2 to edit inline.
• Direct Typing: Click any cell once and start typing to immediately replace its content and begin editing (just like Excel and Google Sheets).
• Top Formula / Value Bar: An Excel-style address and value bar (A1, B4...) right under the toolbar for viewing and editing long text or URLs with live two-way sync.
• Save to Disk: Press Ctrl + S (Cmd + S) or click "💾 Save" to write changes back to the CSV file with full RFC 4180 escaping (preserving delimiters, internal quotes, and newlines).
• Visual Change Tracking: Modified cells display a subtle amber corner marker and the editor tab displays an unsaved indicator (●).
• Undo / Redo & Revert: Full Ctrl + Z undo, Ctrl + Y redo, and a "↩ Revert" button to discard unsaved edits.
• Table Operations:
  • + Row: Append a new row or insert below the selected row.
  • - Row: Delete the selected row.
  • + Col: Add a new column to the table.
  • Double-click any column header to rename it.

2. Tabular Exploration & Navigation

• Sticky Headers & Row Counter: Headers and the 1-based row counter stay fixed during vertical and horizontal scrolling.
• Instant Search & Filter: Real-time multi-column search with match highlighting and filtered row counts.
• Click-to-Sort: Click any column header to cycle between Ascending, Descending, and Natural order (supports both numeric and string values).
• Fast Client-Side Pagination: Smooth 60fps performance even on 10,000+ row datasets. Select between 25, 50, 100, 250, or All rows per page.
• Delimiter Auto-Detection & Selector: Automatic detection or manual override for Comma (,), Semicolon (;), Tab (\t), and Pipe (|).
• Toggle Header Row: Treat the first row as column titles or view generic column letters (A, B, C...).
• Clipboard Export: One-click Copy MD (Markdown table) or Copy TSV (ready to paste directly into Excel or Google Sheets).
• Auto-Sync on Save: Editing the CSV file externally or in a split text editor automatically updates the table preview when clean.
• Native VS Code Theming: Automatically matches your current VS Code theme (Dark+, Light+, High Contrast, and community themes).

⌨️ Keyboard Shortcuts

🚀 How to Use

1. Explorer Context Menu: Right-click any .csv, .tsv, .tab, or .txt file in VS Code's File Explorer and select "Preview with Hello CSV".
2. Editor Context Menu: Right-click inside an open CSV file and select "Preview with Hello CSV".
3. Editor Tab Bar: Click the table icon ($(table)) in the editor tab bar when viewing a CSV.
4. Command Palette: Press Ctrl + Shift + P (or Cmd + Shift + P) and type:

   Hello CSV: Preview with Hello CSV
   

📦 Publishing to VS Code Marketplace

Prerequisites

1. An Azure DevOps account.
2. A Personal Access Token (PAT) with Marketplace (Manage) permissions.
3. A publisher created on the VS Code Marketplace Management Portal.

Packaging the Extension

# Build the production bundle
npm run build

# Package into a .vsix file
npx @vscode/vsce package --no-dependencies

Publishing via CLI

# Log in with your publisher ID and Personal Access Token
npx @vscode/vsce login <publisher-name>

# Publish directly to the Visual Studio Code Marketplace
npx @vscode/vsce publish

Alternatively, upload the generated hellocsv-0.2.0.vsix directly on the Marketplace Manage Page.

🧪 Development & Testing

# Install dependencies
npm install

# Run unit tests
npm test

# Run build
npm run build

# Watch mode during development
npm run watch

To run and debug the extension:

1. Open the project in VS Code.
2. Press F5 to launch the Extension Development Host.

📄 License

This extension is licensed under the MIT License.