Skip to main content

jupyterlab_tabular_data_viewer_extension

GitHub Actions npm version PyPI version Total PyPI downloads JupyterLab 4 Brought To You By KOLOMOLO Donate PayPal

View and browse Parquet, Excel, CSV, TSV, and SQLite files directly in JupyterLab. Double-click any .parquet, .xlsx, .csv, .tsv, or .db file to open it in a simple, spreadsheet-like table view - no code required (yes, really). Navigate through your data, inspect values, and explore the structure of your tabular data files with interactive column resizing and advanced filtering capabilities.

Full disclosure: This is a shameless ripoff of your typical tabular data browsing tools. Zero ingenuity, zero creativity - just unabashed borrowing of ideas that worked elsewhere. If it looks familiar, that's the point.

Parquet Viewer

Opening files: Right-click any supported file and select "Tabular Data Viewer" from the "Open With" menu, or simply double-click to open with the default viewer.

Open With Menu

Column statistics: Hover over any column header to reveal an info icon, click it to view comprehensive statistics.

Column Statistics Icon

Column Statistics Modal

Context menu: Right-click any row to copy data as JSON.

Copy Row as JSON

Export: Click the Export link in the status bar (or right-click on the viewer) to export the whole table in your choice of format - original, Excel (.xlsx), CSV, Parquet (.parquet), or JSONL (.jsonl). Pagination never limits an export: what you get is every row, not the page on screen. When filters are active, the export popup notes that only filtered rows will be exported.

Download Filtered Data

Features

Supported File Formats:

  • Parquet files (.parquet) - Full support with efficient columnar data reading
  • Excel files (.xlsx, or an .xlsx saved under the old .xls name) - Multi-sheet support: a sheet bar appears at the bottom for workbooks with more than one sheet, and switching sheets resets all filters/sort/selection (each sheet behaves like a separate file). Mixed-type columns (e.g. integers and strings in the same column) are read as text rather than failing to open. Excel files must still be simple tabular data without merged cells, complex formulas, or advanced formatting
  • CSV files (.csv) - Comma-separated values with UTF-8 encoding (fallback to latin1)
  • TSV files (.tsv) - Tab-separated values with UTF-8 encoding (fallback to latin1)
  • SQLite databases (.db, .sqlite, .sqlite3, .db3) - User tables appear as tabs in the same bar Excel uses for sheets, and system tables (sqlite_sequence and friends) stay hidden. BLOB columns show a size placeholder such as <BLOB 42.1 KB> instead of dumping binary into the grid. Databases are identified by their magic header rather than trusting the extension, so a .db file that is not SQLite is reported rather than misread. Connections are read-only: the viewer never writes to your database

Core viewing and navigation:

  • Simple table display showing your data in familiar spreadsheet format
  • Column headers with field names and simplified datatype indicators
  • Interactive column resizing - drag column borders to adjust width independently
  • Frozen index column - row numbers stay fixed when scrolling horizontally through wide datasets
  • Row selection - click anywhere on a row to highlight it with subtle color shading. Click again to deselect, or click another row to switch selection
  • Progressive loading - starts with 500 rows, automatically loads more as you scroll (your patience rewarded)
  • Datasource type indicator in the status bar - SQLite, Parquet, Excel, CSV or TSV prefixes the file statistics, so the format actually being read is never a guess
  • File statistics (column count, row count, file size) at a glance
  • Fixed status bar remains visible during horizontal scrolling (because it got tired of moving)
  • Handles large files efficiently with server-side processing

Advanced filtering and sorting:

  • Column sorting with three-state toggle (ascending, descending, off)
  • Per-column filtering with substring or regex pattern matching
  • Multi-select value filter - Click filter button next to any column to select from unique values with counts. Supports filtering on empty strings and null values
  • Case-insensitive search option
  • Numerical filters supporting comparison operators (>, <, >=, <=, =)
  • Clear filters functionality to reset all active filters
  • Multiple filters work together to narrow down results

Additional features:

  • Column statistics modal - View comprehensive statistics including data type, row counts, null values, unique counts, and type-specific metrics (numeric: min/max/mean/median/std dev/outliers; string: most common value/length stats; date: earliest/latest dates). Includes scrollable list of unique values sorted by frequency with counts and percentages. Copy statistics as JSON with one click
  • Export - Export link in the status bar (or right-click on the viewer) opens a format picker: original, Excel (.xlsx), CSV, Parquet (.parquet), or JSONL (.jsonl). Original is omitted for SQLite sources - a database cannot be written back out. Exports preserve active filters and sort order. Filename includes the slugified sheet name for multi-sheet Excel, the table name for SQLite, and a _filtered suffix when filters are applied
  • Right-click context menu on rows to copy data as JSON
  • Refresh view - Right-click on viewer and select "Refresh View" to reload data from file while preserving scroll position, filters, and sorting
  • Cell text truncation - Configurable maximum character limit for cell display (default: 100 characters). Text longer than limit shows "..." ellipsis. Set to 0 for unlimited display
  • Complex data types display - List/tuple and dict values display as JSON strings for easy inspection of nested/structured data
  • Absolute row indices - Row numbers always show original file position, even with active filters or sorting
  • Configurable file type support via Settings - Enable/disable Parquet, Excel, CSV/TSV, or SQLite handling
  • All features work seamlessly across all supported file formats

Installation

Requires JupyterLab 4.6.0 or higher and Python 3.10 or higher.

pip install jupyterlab_tabular_data_viewer_extension

Uninstall:

pip uninstall jupyterlab_tabular_data_viewer_extension

Configuration

Configure extension behavior through JupyterLab Settings:

  1. Open Settings → Settings Editor
  2. Search for "Tabular Data Viewer Extension"
  3. Configure options:
    • Enable Parquet files - Default: enabled
    • Enable Excel files - Default: enabled
    • Enable CSV files - Default: enabled
    • Enable TSV files - Default: enabled
    • Enable SQLite files - Default: enabled
    • Maximum Cell Characters - Default: 100. Maximum characters to display in a cell before truncating with "...". Set to 0 for unlimited display
    • Maximum Unique Values - Default: 100. Maximum number of unique values to display in filter dialog and column statistics. Set to 0 for no limit
    • Rows Per Page - Default: 500. How many rows are fetched and rendered at a time. Filtering, sorting and column statistics always run over the whole table regardless of this value - it bounds only how much is displayed at once

When a file type is disabled, files open with JupyterLab's default handler instead.

Metadata

Release files for jupyterlab-tabular-data-viewer-extension 1.7.16

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for jupyterlab-tabular-data-viewer-extension 1.7.16
File Size Uploaded Provenance Actions
jupyterlab_tabular_data_viewer_extension-1.7.16.tar.gz 1.4 MB Without provenance Details for jupyterlab_tabular_data_viewer_extension-1.7.16.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for jupyterlab-tabular-data-viewer-extension 1.7.16
File Interpreter ABI Platform Actions
jupyterlab_tabular_data_viewer_extension-1.7.16-py3-none-any.whl Python 3 none any Details for jupyterlab_tabular_data_viewer_extension-1.7.16-py3-none-any.whl

Total release size: 1.6 MB

Release files / jupyterlab_tabular_data_viewer_extension-1.7.16.tar.gz

Download URL jupyterlab_tabular_data_viewer_extension-1.7.16.tar.gz
Size 1.4 MB
Tags Source
SHA-256 checksum
How to use checksums
5c945abc454c1364de2adcfc5da678e3b24738ab5c97b2bb401fae532e87963d
BLAKE2b-256 checksum
How to use checksums
42be801af9c6dbc695613be77ee6cd315d551470ab174d722df6429460c22ca6
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/7.0.0 CPython/3.14.10

Release files / jupyterlab_tabular_data_viewer_extension-1.7.16-py3-none-any.whl

Download URL jupyterlab_tabular_data_viewer_extension-1.7.16-py3-none-any.whl
Size 127.0 kB
Tags Python 3
SHA-256 checksum
How to use checksums
2400dd85b31ea77f0500833f02045d5c8ee970e79dbeb0357233949f104798b4
BLAKE2b-256 checksum
How to use checksums
6cfddbcee57032eb76456c11473937195a909256767d9cf9364cce353c77e888
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/7.0.0 CPython/3.14.10

Security for jupyterlab-tabular-data-viewer-extension 1.7.16

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Release history Release notifications | RSS feed

This release

1.7.16 This release

2 release files No provenance

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page