Data TablesView data files as tables in VS Code, from SAS datasets to CSV and Parquet. Sort and filter the rows, and see a summary of every column beside them.
Supported filesThese open as tables when you open them in VS Code:
To open another file as a table, right-click it and choose Open With...:
Working with a tableClick a column header to sort by it, and Shift-click another header to add it to the sort. The toolbar spells out the sort, such as "Sorted by AGE ↓, SEX ↑". Click a column there to scroll the table to it, or the × to go back to the file's order. Hover over a header, or tab to it, to show its ⋯ menu button. A column's menu also pins the column or hides it. Click a row to select it. Shift-click selects a run of rows, and Cmd-click (Ctrl-click on Windows and Linux) adds one. Cmd+C or Ctrl+C copies them, ready to paste into a spreadsheet. FilteringThe filter row under the toolbar holds your filters as chips. + Filter, or Filter... in a column's menu, opens a form where you pick a column and a condition and type the value. Click a chip to change it, or its × to remove it. The status line gives the rows shown and their share of the file, such as "179 of 306 rows (58.5%)". The conditions fit the column's type. "Is one of" lists the column's values with their counts, and their labels for a coded column. Text matches ignore case unless you tick Match case.
A condition such as "does not equal" keeps the rows where the value is missing. Add a second chip, "is not missing", to drop them too. Untick Enabled in a chip's form to keep the chip without applying it. With two chips or more, Match all keeps the rows that meet every chip, and Match any keeps the rows that meet at least one. Clear all removes every chip. SQL switches the row to a DuckDB SQL condition, such as
The summary panelThe summary panel beside the table lists every column with a small chart of its values and its share of missing values. The chart is a histogram for numbers and dates, and the most common values for anything else. Its counts cover the rows your filters keep. Click a column in the panel to see its full profile. The profile gives the missing and distinct counts and the top values. For numbers and dates it adds a histogram and summary statistics, such as the mean, the geometric mean and the quartiles. Profile in a column's menu opens the same view.
Compare with, under a profile, plots the column against another one. Two columns of numbers or dates draw a heatmap. A column of text, or one switched to its top values, splits the other's histogram into one per value. Each of those histograms scales to its own rows, so their shapes compare. Two columns read by their values draw a grid of counts.
Search the panel by name, or sort it by name or type. Hovering a row swaps its type icon for an eye, which hides the column from the table or shows it again, and the → button scrolls the table to that column. A hidden column's row keeps its struck-through eye. While the panel is closed, the toolbar counts the hidden columns, and a click on the count opens the panel. The panel opens at most a third of the table's width. Dragging its edge resizes it as wide as you like, while the table keeps 240 px for its rows, and a narrower editor shrinks the panel to keep that room. The Toggle Summary Panel button in the editor's title bar shows or hides the panel. SAS, Stata and SPSS labelsFiles from SAS, Stata and SPSS keep their labels. A file's own label, such as "Demographics", shows in the toolbar before the row count. The summary panel shows each variable's label under its name, and hovering over a column's header shows it too. A coded column's menu offers Show value labels, which shows "Male" in place of A special missing value keeps its code: a SAS
A table opens again as you left it, with its sort, filters and columns. The summary panel stays open or closed as you left it, and a table left in SQL mode opens with its SQL. SettingsSearch for "Data Tables" in VS Code's settings. They set how cells look, how numbers and dates format, and how delimited text reads by default. Summary Position puts the summary panel on the right or the left, and Summary Open sets whether a table opens with it. Your dataData Tables never changes your files and never connects to the internet. PlatformsmacOS on Apple silicon, Windows x64, and Linux x64 and Arm64. How it worksDuckDB reads each file in a process separate from VS Code, and the table fetches only the rows on screen. A file of millions of rows opens as fast as a small one. SQL mode takes a DuckDB SQL condition, and the chips turn into one. Once a file is open, its DuckDB database cannot read any other file. |





