Getting Started with Spreadsheet

Probably’s spreadsheet interface combines the familiarity of Excel with powerful data science capabilities. View, edit, filter, and transform your data with enterprise-grade performance.

Beyond Traditional Spreadsheets

Handle millions of rows with instant performance, semantic search capabilities, and AI-powered transformations that traditional spreadsheets simply can’t match.

Getting to the Spreadsheet

From Any Dataset

Select your dataset from the main interface
Click the “Spreadsheet” tab in the dataset view
Your data loads instantly regardless of size

The spreadsheet view becomes available immediately after loading any dataset, whether from files, databases, or generated data.

Core Spreadsheet Features

High-Performance Data Display

Virtual Scrolling

View large datasets efficiently with pagination
Only renders visible cells for optimal performance
Seamless scrolling with automatic data loading

Smart Column Management

Auto-sized columns based on content
Resizable columns with drag handles
Hide/show columns with simple controls
Reorder columns by dragging headers

Interface Overview

Main Components

Data grid showing your dataset in tabular format
Column headers with sorting and filter controls
Row numbers for easy navigation and selection
Status bar showing row counts and selection info

Scroll bars for large datasets
Keyboard navigation with arrow keys
Search functionality to find specific values
Go to row for jumping to specific locations

View Options

Zoom controls for adjusting cell size
Column width adjustment by dragging borders
Row height automatic adjustment based on content
Full screen mode for focused data work

Key Differences from Excel

Performance Advantages

Large datasets handled efficiently with virtual scrolling
No file size limits like traditional spreadsheets
Memory efficient virtual rendering
Fast sorting and filtering with optimized data loading

Advanced Features

Column search to quickly find variables
Data type handling for different variable types
PXL integration for advanced transformations
Agent collaboration between spreadsheet and AI analysis

Data Science Integration

Statistical functions built-in
Advanced filtering with multiple conditions
Expression evaluation with PXL language
Direct visualization creation from selections

Getting Familiar

Basic Operations

Click cells to select and edit
Double-click to enter edit mode
Tab key to move to next cell
Enter key to confirm changes and move down

Selection Methods

Single cell: Click any cell
Row selection: Click row number
Column selection: Click column header
Range selection: Click and drag across cells

Quick Actions

Keyboard shortcuts for common operations
Ctrl+Z for undo operations
Ctrl+C/V for copy and paste
Delete key to clear cell contents

What’s Next?

Learn Cell Editing

Discover how to edit different data types and use advanced input features.

Editing & Data Entry

Explore Filtering

Learn about the powerful filtering and sorting capabilities for data exploration.

Filtering & Sorting