Skip to main content

Data

Open, explore, and prepare datasets (SPSS-style Data View + Variable View).

Files​

Open File​

What it is. Load data from CSV, TSV, Excel (.xlsx/.xls), SPSS (.sav), Stata (.dta), or JSON.

When to use. Anytime you start a new analysis. File > Open Data File...

Options / Parameters

  • Format — Auto-detected from file extension.
  • .sav (SPSS) — Preserves variable labels, value labels, and measurement level.
  • .dta (Stata) — Preserves labels, variables, and value labels.
tip

Drag-and-drop a file onto the window also works.

Export Data​

What it is. Save the active dataset as CSV / XLSX / SAV / DTA / JSON.

When to use. To share cleaned data or hand off to another tool.

Export Report​

What it is. Generate a complete report (Markdown / HTML / LaTeX) containing everything in the Output tab — analyses, tables, charts.

When to use. At the end of your work, for documentation or to attach to a paper/thesis.

Options / Parameters

  • HTML — Word-compatible (opens as .doc) and browser-friendly.
  • Markdown — For GitHub, Obsidian, or further conversion.
  • LaTeX — Uses booktabs and APA-style formatting.

Dataset Tabs​

Multiple datasets at once​

What it is. Each open dataset gets its own tab above the Data View. Click to switch active.

When to use. To compare datasets, run merges, or keep originals and transforms side-by-side.

Options / Parameters

  • Duplicate — Right-click > Duplicate — creates a copy with independent transforms.
  • Rename — Gives the dataset a descriptive name (file on disk is unchanged).
  • Properties — Shows detailed info (rows, cols, types, missing).
  • Export — Save that specific dataset to a file.
  • Close — Close the tab (in-memory changes are lost if not saved).

Views​

Data View​

What it is. Table with one row per observation. Excel-style.

When to use. To inspect, filter, and edit values.

tip

Double-click a cell to edit. Shift+click selects a range.

Variable View​

What it is. Table with one row per variable (name, label, type, measure, missing, role).

When to use. To configure metadata: change a label, measurement level (scale/ordinal/nominal), missing values, etc.

Options / Parameters

  • Type — numeric / string / date / boolean.
  • Measure — scale (continuous numeric), ordinal (order matters), nominal (categories).
  • Role — input / target / both / none — used by some models.
  • Missing values — Values treated as missing in analyses (e.g. -99).