CSV Row Inspector

A small VS Code extension that shows the current CSV row as a transposed key/value table in the bottom panel.

Screenshots

What it does

• Adds a CSV Inspector container to the bottom panel.
• Shows the current row as:
  • a two-column Column / Value table
  • or JSON
• Updates automatically when you move the cursor.
• Lets you pin the current row.
• Lets you copy the current row as JSON.

Run it locally

npm install
npm run compile

Then in VS Code:

1. Open this folder.
2. Press F5 to launch the Extension Development Host.
3. Open a .csv file.
4. Run CSV Row Inspector: Focus from the Command Palette.
5. Put your cursor on any data row.

Commands

• CSV Row Inspector: Focus
• CSV Row Inspector: Refresh
• CSV Row Inspector: Copy Current Row as JSON
• CSV Row Inspector: Pin Current Row
• CSV Row Inspector: Unpin Row

Settings

• csvRowInspector.delimiter
  • auto, ,, ;, \t, |
• csvRowInspector.hasHeader
  • defaults to true
• csvRowInspector.ignoreEmptyTrailingCells
  • defaults to false

Notes

• This is designed for single-line CSV rows.
• Quoted fields and escaped quotes are supported.
• Multi-line quoted CSV fields are not supported in this first version.

Nice next upgrades

• Sticky compare mode for two rows
• Search/filter inside the inspector
• Highlight changed fields between pinned and current row
• Better delimiter + dialect detection
• TSV/PSV file associations