Skip to main content

​
Overview

Datasets are the foundation of Rowbase. They store your structured data in a tabular format with automatic type detection, versioning, and schema validation.

​
Creating Datasets

​
From File Upload

Upload files by navigating to your project:
  1. Click Upload or drag and drop files
  2. Supported formats: CSV, Excel (.xlsx, .xls), JSON
  3. Rowbase automatically detects:
    • Column headers
    • Data types
    • Date formats
    • Number formats
You can upload multiple files at once. Each file becomes a separate dataset.

​
Schema & Data Types

Each dataset has a schema that defines its columns and their types.

​
Supported Types

TypeDescriptionAuto-Detection Examples
textString values”Hello”, “[email protected]”
numberIntegers and decimals42, 3.14, -100
booleanTrue/falsetrue, false, yes, no, 1, 0
dateDates and timestamps2024-01-15, 01/15/2024, Jan 15 2024
jsonNested objects{"key": "value"}

​
Type Coercion

Rowbase attempts to coerce values to match column types: 
"123" in a number column → 123
"true" in a boolean column → true
"2024-01-15" in a date column → 2024-01-15T00:00:00Z
Values that can’t be coerced are stored as null. Check the import preview for any conversion issues.

​
Primary Keys

Use the Primary Key operation to designate one or more columns as the primary key:
  • Ensures rows are unique based on key columns
  • Validates that key columns are not null
  • Enables identity tracking across updates

​
Versioning

Rowbase automatically tracks changes to your datasets:
  • Each import or update creates a new version
  • Operations are stored separately from data
  • You can re-run operations on new data versions
Versions are created automatically when you import data or update datasets via API.

​
Column Operations

​
Rename Columns

Click any column header to rename it. The new name is applied across all operations and formulas.

​
Change Column Type

  1. Click the column header
  2. Select Change Type
  3. Choose the new type
  4. Review any coercion warnings
  5. Confirm the change

​
Hide/Show Columns

Hide columns to simplify your view without deleting them:
  • Hidden columns are still available in formulas and API responses
  • Toggle visibility from the column menu or view settings

​
Reorder Columns

Drag column headers to reorder them, or use the column settings panel for bulk reordering.

​
Quick Filter

Click the filter icon on any column to:
  • Filter by exact value
  • Filter by condition (contains, starts with, etc.)
  • Filter by multiple values
Use the search bar to find rows containing specific text across all columns.

​
Advanced Filters

Create complex filter conditions with AND/OR logic: 
(status = "active" AND created_at > "2024-01-01")
OR
(status = "pending" AND priority = "high")

​
Exporting Data

Export your dataset in multiple formats:

CSV

Standard comma-separated values

Excel

.xlsx format with formatting

JSON

Array of objects
Export options:
  • All data - Export the complete dataset
  • Filtered data - Export only rows matching current filters
  • Selected columns - Choose specific columns to include