Nifty Data Viewer
Open CSV, Parquet and JSON files as a fast table and query them with SQL, powered by DuckDB. Sort, page through millions of rows, and export to CSV, Parquet or JSON.
Maintained. No sign-in. No telemetry. Works in VS Code, Cursor, Windsurf, VSCodium and other editors that use Open VSX.
Features
- Parquet opens as a table. Double-click any
.parquet file and it opens as a grid with column types, instead of a wall of binary. For CSV, TSV, JSON and JSON Lines (gzipped too), use Open With… → Nifty Data Viewer, the Explorer's right-click menu, or the table button in the editor's title bar.
- Query with SQL. The file is the table
data, so you can run any DuckDB SQL against it: SELECT region, sum(amount) FROM data GROUP BY region, joins against other files with read_csv_auto('other.csv'), window functions, SUMMARIZE data, and more. Press Ctrl+Enter to run.
- Millions of rows. DuckDB streams the file and only one page of rows reaches the editor, so large files stay responsive. Page through the results, see the total count, and click a column header to sort (click again for descending, a third time to clear).
- Export the current result, sorted as shown, to CSV, Parquet or JSON. It's an easy way to convert between formats or save a filtered subset.
- Everything runs locally. DuckDB runs as WebAssembly in a background thread inside the editor. There's nothing to install, no server, and no Python.
- Double-click a cell to copy its value. Dates, timestamps, decimals, lists and structs are shown readably.
Commands
| Command |
What it does |
Nifty Data Viewer: Open in Data Viewer |
Open the active or chosen CSV, TSV, Parquet or JSON file as a table |
Nifty Data Viewer: Run SQL |
Run a query in the open data viewer |
Nifty Data Viewer: Export Query Result |
Save the current result as CSV, Parquet or JSON |
Settings
| Setting |
Default |
What it does |
nifty.data.pageSize |
1000 |
Rows per page in the data viewer |
Install
- VS Code: search for "Nifty Data Viewer" in the Extensions view, or install from the Visual Studio Marketplace.
- Cursor, Windsurf, VSCodium, Kiro, Antigravity: install from Open VSX.
Privacy
This extension collects no telemetry and needs no account.
- Nifty SQLite: SQLite Viewer & Query Editor: Browse and query SQLite databases: tables and views in the side bar, a fast grid for any table, SQL queries with results, and export to CSV or JSON, with no native modules. (Open VSX)
- Nifty JSON: Formatter, Validator & JSONPath: Format, minify, sort keys, query with JSONPath, copy paths, generate TypeScript types, and browse huge JSON files in a fast tree view. (Open VSX)
- Nifty SQL: SQL Formatter for 20 Dialects: Format SQL in 20 dialects, including dbt and Jinja templates, with your team's settings. (Open VSX)
- Nifty Git Graph: Git History & Branch Graph: See your git history as a graph: branches, merges and tags, commit details and diffs, and checkout, merge, rebase, cherry-pick and more from a right-click. No sign-in. (Open VSX)
- Nifty Mermaid: Mermaid Diagram Preview & Export: Mermaid diagrams with no account: live preview beside .mmd files and Markdown, diagrams in the Markdown preview, syntax highlighting, and export to SVG or PNG. (Open VSX)
- Nifty Monitor: CPU & Memory in the Status Bar: CPU, memory and disk usage in the status bar, including on remote SSH machines and dev containers. (Open VSX)
See all 21 Nifty tools at https://getnifty.dev
| |
