Table Explorer

Starting DuckDB in this tab…

Table Explorer
No source

A table is a query

Drop a file (CSV, Parquet, JSON, Excel), paste a table, or load a sample. Header ▾ filters and summarizes. fx adds columns. Steps stay under the formula bar. Every move is DuckDB SQL you can read.

Formula

A DuckDB expression for a derived column. Source columns stay read-only.

Click a column to insert its name.

Summarize

Change groups and measures for this step. Remove the step to go back to row-level data.

Group by
Measures

Extract text

Pull a piece of one column into a new derived column. Keep first or last — add the other side as a second step if you need both. The source is not rewritten.


    

      
      
    

  

  
    
Table Explorer

    
One source table. The grid is a derived view. Clicks become SQL. Cells are not a writable workbook.

    
    
      
  1. Get data in — drop a file (CSV, Parquet, JSON, Excel), paste from Excel, or load a sample.
    2. 
      
  2. Look at a column — click the header. The glance panel shows a histogram or top values. Click a bar to filter. The table does not go away.
    3. 
      
  3. Move like a spreadsheet — ▾ for sort / filter / summarize. fx for formulas. Steps stay under the bar. Read the SQL anytime.
    4. 
    

    

  

  
    
About this session

    
One text block — copy it into a chat. Click inside, then copy, or use Copy.

    
    

      
      

    

  

  
    
How Table Explorer thinks

    

      
Click a headerGlance that column and select it (Shift-click extends)

      
Header ▾Sort, filter, hide, group, heat, extract, hide empties

      
Row numbers / cornerSelect whole rows. Top-left corner or Ctrl+A selects all

      
Click fxWrite a DuckDB expression. Source columns stay read-only.

      
Extract textSplit on the Nth separator; keep first or last. Or a character range

      
AboutOne copyable brief: DuckDB version, how the tool works, and the loaded table schema

      
Steps / SQLSteps is the spreadsheet. SQL is a query workbook on the same source

      
Step stripClick a step to edit it. ✕ removes that step only

      
SQL tabsIndependent queries in this browser tab. Run applies one result. Back to Steps keeps the tabs

      
FROM dataEvery file or sample is this table. The pill shows which dataset is loaded

      
Ctrl + EnterRun the active SQL tab

      
Drag cellsCount / sum / average of the selection (DuckDB for large ranges)

      
Find col:textScope find. Count is the whole view. Highlight is the visible window

      
Export ▾CSV, TSV, Parquet, JSON, or NDJSON of the full compiled view, or copy SQL

      
Copy / Ctrl + CSelected cells as a table (paste into Excel). No selection: visible rows with headers. ▾ copies the same with headers

      
Drag a column edgeResize. Double-click fits the name.

      
EscClear the selection

      
Ctrl + VPaste a table as the source when empty. Use Paste to replace a loaded source

      
Ctrl + FFind in the current view

      
Ctrl + ZUndo last move

      
Ctrl + OOpen a file