tabular-data-viewer

Tabular Data Viewer 中 for Visual Studio Code

See Data Preview 🈸 vscode extension for advanced Grid Data Viewer with many common data formats support, search, sort, filters, grouping, splits, pivot tables, aggregates and basic charts 📊.

Tabular Data Viewer 中

Tabular Data Viewer provides fast DSV data loading and custom Table View 🀄 display for very large (1-8 GB) .csv, .tsv and .tab data files via table and Papa Parse CSV parser with NodeJS File Streams and Worker threads:

Features

• View large CSV and TSV data files in a custom Tabulator Table View 🀄
• Open Data File Table View 🀄 via quick file path input prompt
• Load large datasets with millions of rows and over 1GB of tabular data using Papa Parse CSV parser in a worker thread with data streaming and incremental loading into Table View 🀄
• View data loading progress, file size, colulmns, rows and load time stats display in vscode status bar
• Sort displayed table data by multiple columns
• Resize table columns
• Rearrange table columns and rows
• Hide, freeze, or delete table columns
• Freeze or delete table rows
• Select table rows column
• Persist table columns layout and sort order
• Restore customized table columns and sort configuration on vscode reload
• Copy tab delimited table data to Clipboard
• Save displayed table data in CSV (, or ; delimited), TSV, HTML table, or JSON data array format
• Generate and view Frictionless Table *.schema.json configration file created with tableschema-js.infer()
• Load saved table configuration options from auto-generated *.table.json config file when reopening previously customized Table View 🀄
• Set default Data Page Size to 1K, 10K, or 100K (default) rows per page via standard vscode Preferences -> Settings -> Extensions -> Tabular Data Viewer configuration options to speed up large datasets parsing and loading into Table View 🀄

...

Limitations

Large CSV data files streaming and display is very alpha and has the following limitations for now:

• Large datasets are paged and loaded into view for display with default page size set to 100K rows per page
• Columns sort only works for the paged data loaded and displayed in Table View 🀄 and doesn't sort data for the whole dataset
• Save data uses Tabulator Download Table Data feature and is also limited to max 100k rows for the currently displayed tabular data in Table View 🀄

Contributions

Tabular Data Viewer 中 Settings, Commands, Languages, Custom Editors and Activation Events contributed to VSCode IDE:

Settings

Create User or Workspace Settings in vscode to change Tabular Data Viewer 中 extension Settings:

You can view Tabular Data Viewer 中 Configuration Settings via standard vscode Preferences -> Settings -> Extensions -> Tabular Data Viewer Settings view or use custom Tabular Data: View Settings command from View -> Command Palette... menu prompt by typing Tabular in it. Hit Reload ↺ button in open Table View 🀄 after you toggle Tabular Data Settings to activate your configuration changes for an open table view.

Observable JS Notebook

You can try Tabular Data Viewer 🀄 Observable Notebook 📓 with public datasets and supported data formats in a browser:

Recommended Extensions

Recommended custom dataViz extensions produced by Random Fractals Inc. and other 3rd party vscode extension devs for working with data 🈸 charts 📈 geo 🗺️ data formats and Interactive Notebooks 📚 in VSCode:

Dev Log

See #TabularDataViewer 🀄 tag on Twitter for the latest and greatest updates on this vscode extension and what's in store next.

Dev Build

$ git clone https://github.com/RandomFractals/tabular-data-viewer
$ cd tabular-data-viewer
$ npm install
$ npm run compile
$ code .

Press F5 to launch Tabular Data Viewer 🀄 extension debug session, or run the following command to generate tabular-data-viewer-x.x.x.vsix package with vsce from our latest for local dev install from .vsix in vscode.

tabular-data-viewer>vsce package

Contributing

Any and all test, code or feedback contributions are welcome. Open an issue or submit a pull request to make this Tabular Data Viewer 🀄 extension work better for all.

Backers