Repository files navigation

SeeData Preview 🈸 vscode extension for advancedData Grid Viewer with support of many commondata formats and Save options for smaller datasets.

Tabular Data Viewer provides fastDSV data loading and custom Table Views 🀄 for very large (1-8 GB) local and remote.csv,.tsv and.tab data files with table, View,D3FC Chart Views 📊📈,Papa Parse CSV parser,NodeJS File Streams andWorker threads:

• View largeCSV andTSV data files in a customTabulator Table orPerspective Data View 🀄
• Open localfile:/// or remotehttps:// Data File Table View 🀄 with quick Data File URL input prompt
• Explore over 750 public datasets from the curated list ofhttps://frictionlessdata.io/Data Package 📦 JSON configs with Tabular Data Resources, and Table Views 🀄 to search, view, and graph in Chart Views 📊 📈
• Load large datasets with millions of rows and over 1GB of tabular data usingPapa Parse CSV parser in a worker thread with data streaming and incremental loading into Table View 🀄
• View data loading progress, local data file size, colulmns, rows and load time stats display in vscode status bar
• Sort displayed table data by multiple columns
• Resize table columns in Tabulator Table View
• Rearrange table columns in Tabulator Table and Perspective Data Grid views
• Set default Data Page Size to 1K, 10K, or 100K (default) rows per page to speed up large datasets parsing and loading into Table View 🀄
• Auto-save table columns layout, sort order, and Perspective View configs
• Restore customized Table View 🀄 configuration on vscode reload
• Load saved table configuration options from auto-generated*.table.json config file when reopening previously customized Table View 🀄
• Generate and viewFrictionless Table*.schema.json configration file created withtableschema-js.infer()
• Copy displayed table data to Clipboard inTSV format from Tabulator Table View or inCSV format from Perspective View
• Save displayed table data inCSV (, or; delimited),TSV,HTML table, orJSON data array format from Tabulator Table View
• Save displayed table data inApache Arrow ⋙ data format from Perspective View:

Large CSV/TSV 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 is also limited to max 100k rows for the currently displayed tabular data in Table View 🀄

Install Tabular Data Viewer 中 from VSCode Extensions tab (ctrl+shift+x) by searching fortabular data inExtensions: Marketplace sidebar view, or install it directly from VS Code MarketplaceTabular Data Viewer 中 extension page in a browser.

Tabular Data Viewer 中 is designed to work withVSCode Desktop IDE version and also works withGitHub Codespaces in a browser:

Tabular Data Viewer 中 works inVSCodium too. However, VSCodium and other vscode extension compatible IDE flavors are not officially supported as they require additional testing in those IDE variants.

You can usetabular-data-viewer-x.y.z.vsix extension packages attached inAssets section with every publishedrelease of this extension on github. Followinstall from .vsix instructions in your vscode extensions compatible IDE or online container service to install it.

If you prefer to use other IDEs that support VSCode extensions published in.vsix format and download your extensions fromopen-vsx.org, we recommend you try olderData Preview version of this extension.

Currently, there are no plans to publish this extension to Open VSX Registry due to poor publishing experience in that vscode extensions marketplace and low usage by majority of developers.

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

Create User or Workspace Settings in vscode to change Tabular Data Viewer 中 extension Settings listed below. All Tabular Data Viewer Settings start withtabular.data. prefix, which is omottied in the Settings table below for better display inVSCode marketplace.

You can set your Tabular Data Viewer 中 Configuration Settings by adding them to./vscode/settings.json in your project workspace. The following workspace configuration settings will default Table Views 🀄 to usePerspective Data Grid and Dark UI theme for tabular data and basicD3FC Charts 📊📈 display:

{// Tabular Data Viewer settings for this workspace"tabular.data.view": "Perspective","tabular.data.ui.theme": "dark"}

You can also view Tabular Data Viewer 中 Configuration Settings via standard vscodePreferences -> Settings -> Extensions -> Tabular Data Viewer Settings view or use customTabular Data: View Settings command fromView -> Command Palette... menu prompt by typingTabular in it.

Hit Reload ↺ button in an open Table View 🀄 after you toggle Tabular Data Settings to activate your configuration changes.

Note:tabular.data.view type default andtabular.data.ui.theme Setting changes might require you to close and reopen Tabular Data Views for those settings to take effect.

Tabular Data Viewer 中 provides a number of global and context specific commands to load and view tabular data files andData Packages 📦.

You can access custom Tabular Data Commands fromView -> Command Palette... menu (ctrl+shift+p) by typingTabular in the command search box:

All Tabular Data Commands start withTabular Data: prefix, and exposed public Tabular Data Viewer 中 command Ids usetabular.data. prefix to enable other extensions to use Table View 🀄 and tabular data list commands.

Some of the Tabular Data Commands likeView Table andList Data Resources are enabled in vscode file explorer and in code editors for the supported data file types and formats via the corresponding context menues in vscode IDE.

Currently supported Tabular Data 中 Commands include:

Tabular Data Viewer 中 v1.8.0 and above provides a customUri Handler for launching Table Views 🀄 and othertabular.data commands from a Url in a browser. All of the listed commands above can be launched from a browser using the followingvscode:// Url format:

vscode://RandomFractalsInc.tabular-data-viewer/<command>[#<dataUrl>|?dataUrl=<dataUrl>]

which instructs a browser to open VSCode IDE Desktop application, activate Tabular Data Viewer 中 extension, and execute one of thetabular.data. commands via system-wide Urls. Commands that require a data file or data package Url accept that parameter via fragment/anchor (#) portion of the Url, or viadataUrl query parameter.

For example, the followingvscode:// Url will display Table View 🀄 for the publichttps://github.com/datasets/world-cities data repository. Copy and paste this Url in your browser to try it:

vscode://RandomFractalsInc.tabular-data-viewer/viewTable#https://raw.githubusercontent.com/datasets/world-cities/master/data/world-cities.csv

Tabular Data Viewer 中 v1.8.0 and above ships with alpha support ofhttps://frictionlessdata.io/ Data Package 📦 JSON format and over 750 built-in curated public datasets with Tabular Data 中 Resources for you to search and explore:

Public GitHub repositories have over 12Kdatapackage.json configurations you can browse using this query:https://github.com/search?p=4&q=filename%3Adatapackage.json+language%3AJSON+language%3AJSON&type=Code

You can load those Data Package 📦 configurations to view Tabular Data 中 Resources viaTabular Data: Open Data File command. For example, here is how to open Periodic Tabledatapackage.json example:https://github.com/frictionlessdata/examples/blob/main/periodic-table/datapackage.json

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

You can also experiment with some public Data Packages 📦 anddatapackage-js library in ourData Package 📦 Observable JS Notebook 📓 in a browser:

Recommended custom dataViz extensions produced byRandom Fractals Inc. and other 3rd party vscode extension authors for working with data 🈸 charts 📈 geo 🗺️ data formats and Interactive Notebooks 📚 inVSCode:

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

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

PressF5 to launch Tabular Data Viewer 🀄 extension debug session, or run the following command to generatetabular-data-viewer-x.x.x.vsix package withvsce from our latest for local devinstall from.vsix in vscode.

tabular-data-viewer>vsce package

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