Navigation
Views
Home
Data View
Chart Builder
Dashboard
Merge
Data Cleaner
Pivot Table
Tools
Settings
Modules
🗄SQL Reference
🐍Python Ref
ƒxFormula Ref
GPQLGPQL Reference
📝Notes
Diff
Import, clean, merge, visualize, and export — all in one place.
Drop a file to get started
CSV · TSV · Excel · JSON · .dfp — supports multiple datasets
fx
Datasets Import data to see datasets here
📦 Insert Dataset
Ctrl+Enter to run · Use dataset names as table names
Drag snippet into editor or click to insert
No queries run yet
GPQL General Purpose Query Language
Ctrl+Enter to run · Each command on its own line · Full Reference →
Quick insert:
Edit Mode — click any cell to edit · Tab / Enter to navigate · Esc to cancel
Recording macro 0 steps
No data loaded
Column Stats ×
📊
📊
Chart Builder
Chart Type
Data
Y Series
Style
Default
Warm
Cool
Earth
Neon
Pastel
Mono
Axes
Advanced
Quick Templates
Export
Live preview
Dashboard
No charts yet
Build a chart and click + Add to Dashboard
🔗 Merge / Join Datasets
Left Dataset
Dataset
Join Key Column
Include Columns
Only rows matching in both
Right Dataset
Dataset
Join Key Column
Include Columns
Output
Configure above and click Execute Merge.
🧹 Data Cleaner
Operation Log
🔀 Pivot Table Rows: Cols: Values:
Sort: Top N rows:
Filters:
Configure above and click Build
⚙ Settings
Customize DataFramework.io — themes, fonts, colors, and layout.
🎨 Themes
💡 Accent Color
Primary Accent
Active tabs, highlights, buttons, links
Custom:
✍ Typography
UI Font
Buttons, labels, menus, navigation
Mono Font
Data cells, formula bar, code areas
UI Font Size
Labels, buttons, navigation
px
Table Font Size
Text inside data table cells
px
📐 Layout
Panel Width
Width of the slide-out nav/dataset panel
px
Table Row Height
Height of each row in the data table
🖌 Color Overrides
🗃 Data Table
Zebra Striping
Alternate row background for readability
Freeze First Column
Keep first column visible when scrolling
Show Row Numbers
Display row index column
Number Format
How numeric values are displayed in cells
Rows per page
Max rows shown in table view (0 = all)
📊 Chart Defaults
Default Chart Type
Type pre-selected when opening Chart Builder
Default Aggregation
Pre-selected aggregation method
Animation Duration
Chart render animation speed (ms)
Default Color Palette
Color scheme for new chart series
🔄 Pivot Defaults
Default Aggregation
Show Totals by default
🖥 Dashboard Preferences
Grid Columns
Number of columns in dashboard grid (1–4, or auto)
Card Height
Default chart card height in pixels
Show chart subtitles
Display chart type and X column under card title
Card gap
Space between dashboard cards (px)
px
💾 Auto-Save & Performance
Auto-save settings
Automatically persist theme, fonts, and preferences to browser storage
Table render limit
Max rows rendered at once (higher = slower on large data)
Confirm on delete
Show confirmation dialog before deleting datasets or rows
📥 Import Defaults
Auto-detect column types
Automatically classify columns as number, string, or date on import
CSV delimiter
Default field separator for CSV files
Navigate to Data view on import
Automatically switch to Data view after importing a file
🔢 Number Display
Decimal separator
Character used as decimal point in displayed numbers
Thousands separator
Character used to group thousands in large numbers
Null display text
Text shown in empty/null cells
♿ Accessibility & UX
Reduce animations
Disable chart and UI transitions for reduced motion
High contrast borders
Use stronger borders between table cells
Toast duration
How long notification toasts stay visible
⌨ Keyboard Shortcuts
💡All Ctrl shortcuts work with ⌘ Cmd on Mac. Custom shortcuts are saved with your configuration.
👁 Live Preview
12345.67
#ProductRevenueCategoryStatus
1Alpha Pro$12,450ElectronicsActive
2Beta Suite$8,200SoftwarePending
3Gamma Plus$15,900ServicesInactive
🧩 Installed Modules
💾 System Configuration
Your settings (theme, colors, fonts, table prefs) are automatically saved in this browser. Export a .dfconfig file to back up your configuration and restore it in any browser.
Browser Storage Status
○ Checking…
📲 App Mode
🐍 Python IDE
Scripts
Loaded Datasets
Quick Snippets
Python not loaded
Loading Python runtime…
Fetching Pyodide (first load may take 10–15s)
// Python runtime will load when you first run code.
No DataFrames created yet. Use df = get_dataset('name') to load data.
Available Packages
Automations
Select or create an automation
No automations yet
Click + New to create your first automation
🗺 Geo & Maps
Column mapping: lat lon
No map data
Load a dataset with latitude & longitude columns, then select them above
🔬 Data Quality
Rules
Quality Score
Run checks to see score
Select a dataset and run checks to see quality report.
🔤 Regex Studio
Pattern Library
📅 Timeline View
Select a dataset with date columns
Reference
🧬DFL Language
ƒFormulas
🗄SQL
🐍Python
GPQL
🗄
SQL Reference
Select a topic from the sidebar
🐍
Python & Pandas Reference
Select a topic from the sidebar
ƒx
Formula Reference
Select a category from the sidebar
GPQL Reference
GPQL
General Purpose Query Language
Select a command from the sidebar
Dataset Diff — compare two datasets or text
LEFT / ORIGINAL
RIGHT / MODIFIED
DIFF OUTPUT ■ Added ■ Removed
Paste text in both panels and click Compare.
Datasets
No datasets loaded
Examples
🧬 DFL Data Framework Language
Ctrl+Enter to run  ·  Tab = indent
🧬
Welcome to DFL — Data Framework Language
DFL is a simple Python-like scripting language built for DataFramework. Load datasets, filter and transform rows, aggregate data, and save results — no programming experience needed.
📤 Output
Run a script to see output here…
🧙 Advanced Import Wizard
1
Load File
2
Select Columns
3
Filter Rows
4
Clean Data
5
Import
📂
Drop a file here or click to browse
CSV · TSV · Excel (.xlsx) · JSON — up to 50MB
Columns:
Row Filters:
Header row:   |  Skip top N rows:   |  Max rows (0=all): 
Transform
Case
Column
Find & Replace
Step Log
Live Preview
✅ Ready to Import
Dataset Name
After Import
Find & Replace
Col Row #
Type to search…
🔬 Column Inspector
Felix
Data Assistant
Local AI not loaded
Dataset Builder
Define columns and enter data manually
Columns
Data Rows 0
Rename Column
Change Type
Delete Column
📼
Macros & Snapshots
Record replayable steps · Save & restore dataset versions
⏺ Macros
📸 Snapshots
Record a sequence of data operations and replay them on any dataset.
Save a named snapshot of the current state to restore later.